Data is everywhere. Today, most job roles involve some form of data management. Nearly everyone in every line of business is affected in some way by the need to wrangle data. A relational database application such as Microsoft Office Access can help you and your organization stay on top of this task.

This course focuses on the design and construction of an Access database: viewing, navigating, searching and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms and reports.

Note: The Microsoft Office Specialist (MOS) certification test voucher is also available as an option for specific applications.

• Windows Introduction or equivalent knowledge

Lesson 1: Getting started with Microsoft Office Access 2019

• Launch Access and open a database
• Use tables to store data
• Use queries to combine, find, filter and sort data
• Use forms to view, add and update data
• Use reports to present data
• Get help and configure options in Microsoft Access

Lesson 2: Creating Tables

• Plan an Access database
• Start a new Access database
• Create a new table
• Establish table relationships

Lesson 3: Creating Queries

• Create basic queries
• Perform calculations in a query
• Sort and filter data in a query

Lesson 4: Creating Forms

• Start a new form
• Enhance a form

Lesson 5: Creating Reports

• Start a new report
• Enhance report layout