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.