Microsoft Access for Office 365 (Desktop or Online): Part 1
*Both instructor-led and self-paced online learning options are available.
Target Student:
This course is designed for students looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Course Length: 1 Day
Schedule your Access training.
Course-specific Requirements:
- 1 gigahertz (GHz) 64-bit (x64) processor.
- 4 gigabytes (GB) of Random Access Memory (RAM).
- 32 GB available storage space.
- Monitor capable of a screen resolution of at least 1280 × 1024 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
- Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
- IP addresses that do not conflict with other portions of your network.
- Microsoft® Windows® 10 Professional or Enterprise.
- Microsoft® 365 license.
Course Objectives:
- Navigate within the Access application environment, create a simple database, and customize Access configuration options.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
Microsoft Access for Office 365 (Desktop or Online): Part 2
*Both instructor-led and self-paced online learning options are available.
Target Student:
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365.
Course Length: 1 Day
Schedule your Access training.
Course-specific Requirements:
- 1 gigahertz (GHz) 64-bit (x64) processor.
- 4 gigabytes (GB) of Random Access Memory (RAM).
- 32 GB available storage space.
- Monitor capable of a screen resolution of at least 1280 × 1024 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
- Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
- IP addresses that do not conflict with other portions of your network.
- Microsoft® Windows® 10 Professional or Enterprise.
- Microsoft® 365 license.
Course Objectives:
- Provide input validation features to promote the entry of quality data into a database.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Improve the usability of Access tables.
- Create advanced queries to join and summarize data.
- Use advanced formatting and controls to improve form presentation.
- Use advanced formatting and calculated fields to improve reports.
Microsoft Access for Office 365 (Desktop or Online): Part 3
*Both instructor-led and self-paced online learning options are available.
Target Student:
Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills.
Course Length: 1 Day
Schedule your Access training.
Course-specific Requirements:
- 1 gigahertz (GHz) 64-bit (x64) processor.
- 4 gigabytes (GB) of Random Access Memory (RAM).
- 32 GB available storage space.
- Monitor capable of a screen resolution of at least 1280 × 1024 pixels, at least a 256-color display, and a video adapter with at least 4 MB of memory.
- Fast Ethernet (100 Mb/s) adapter or faster and cabling to connect to the classroom network.
- IP addresses that do not conflict with other portions of your network.
- Microsoft® Windows® 10 Professional or Enterprise.
- Microsoft® 365 license.
Course Objectives:
- Share data across applications.
- Use action, unmatched, and duplicate queries to manage data.
- Create complex reports and forms.
- Use macros to improve user interface design.
- Use VBA to extend database capabilities.
- Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
- Implement security strategies and distribute a database to multiple users.
Microsoft Office Access 2016: Part 1
*Both instructor-led and self-paced online learning options are available.
Target Student:
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Course Length: 1 Day
Schedule your Access training.
Course-specific Requirements:
- 1 GHz or faster 32-bit (x86) or 64-bit (x64) processor.
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit).
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit).
- 1,024 × 768 resolution monitor recommended.
- Printer (optional) or an installed printer driver.
- Microsoft® Windows® 10 Professional or Enterprise.
- Microsoft® Office Professional 2016.
Course Objectives:
- Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
Microsoft Office Access 2016: Part 2
*Both instructor-led and self-paced online learning options are available.
Target Student:
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.
Course Length: 1 Day
Schedule your Access training.
Course-specific Requirements:
- 1 GHz or faster 32-bit (x86) or 64-bit (x64) processor.
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit).
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit).
- 1,024 × 768 resolution monitor recommended.
- Printer (optional) or an installed printer driver.
- Microsoft® Windows® 10 Professional or Enterprise.
- Microsoft® Office Professional 2016.
Course Objectives:
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Validate data entered into a database.
- Use advanced queries to manipulate your data.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Customize reports to organize the displayed information and produce specific print layouts.
Microsoft Office Access 2016: Part 3
*Both instructor-led and self-paced online learning options are available.
Target Student:
Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.
Course Length: 1 Day
Schedule your Access training.
Course-specific Requirements:
- 1 GHz or faster 32-bit (x86) or 64-bit (x64) processor.
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit).
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit).
- 1,024 × 768 resolution monitor recommended.
- Printer (optional) or an installed printer driver.
- Microsoft® Windows® 10 Professional or Enterprise.
- Microsoft® Office Professional 2016.
Course Objectives:
- Customize a form layout to improve usability and efficiency of data entry.
- Share data across applications.
- Use macros to improve user interface design.
- Use VBA to enhance tasks.
- Organize data into appropriate tables to ensure data dependency and minimize redundancy.
- Lock down and prepare a database for distribution to multiple users.
- Create and modify a database switchboard and set the start-up options.
