Microsoft Access

Microsoft Access is a file-based desktop application that enables organizations to manage and leverage data. The relational database also includes tools that allow you to quickly build database-bound forms and reports.

Microsoft Access is an excellent alternative to client-server databases for individuals and small teams — both technical and non-technical. The user-friendly interface enables you to import and export data to other applications, use templates to create and publish data and effortlessly build and publish web databases.

32 Hrs.

Access 2019 - Part 1

[Introduction]

16 Hrs.

About this course

This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

Audience Profile

This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the 2019 interface.

At Course Completion

After completing this course, students will be able to:

Gain an understanding of database concepts and terminology.
Learn about the Access interface.
Learn to work with table views, queries, forms, reports, and macros and modules.
Learn to plan a database.
Learn database design fundamentals.
Learn to work with forms and the Form Wizard.
Learn to work with reports and the Report Wizard.

Prerequisites

Familiarity with using a personal computer, mouse, and keyboard.
Comfortable in the Windows environment.
Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Access 2019 - Part 2

[Advanced]

16 Hrs.

About this course

his Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Audience Profile

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

At Course Completion

After completing this course, students will be able to:

Understand database relationships.
Work with table relationships.
Work with queries at an advanced level.
Work with forms at an advanced level.
Work with reports at an advanced level.
Work with macros.
Complete the desktop application with the navigation form.