Microsoft Access 365

(Basic)

(ELK-91-144)

Duration: 1 day @ 7 hours
or
2 days @ 3.5 hours per day
(Morning or Afternoon Sessions Available)

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Access® 365 can help you and your organization with this task.

Microsoft® Access® for Office 365™: Part 1 (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.

Course Objective: In this course, you will create and manage an Access database.

This Microsoft Access Beginners course covers the following 5 modules:

1.  Working with an Access Database

2. Creating Tables

3. Creating Queries

4. Creating Forms

5. Creating Reports

(Intermediate)

(ELK-91-145)

Duration: 1 day @ 7 hours
or
2 days @ 3.5 hours per day
(Morning or Afternoon Sessions Available)

Your training and experience using Microsoft® Access® 365 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries.

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports.

Extending your knowledge of Access will result in a robust, functional database for your users.

Microsoft® Access® for Office 365™: Part 2 (this course):

Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.

Course Objective: In this course, you will optimize an Access database.

This Microsoft Access Intermediate course covers the following 6 modules: 

1. Promoting Quality Data Input

2. Improving Efficiency & Data Integrity

3. Improving Table Usability

4. Creating Advanced Queries

5. Improving Form Presentation

6. Creating Advanced Reports

(Advanced)

(ELK-91-146)

Duration: 1 day @ 7 hours
or
2 days @ 3.5 hours per day
(Morning or Afternoon Sessions Available)

You've covered many of the basic functions of Microsoft® Access® 365, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more.

Knowledge of these features separate database professionals from the casual database users or occasional designers.

Microsoft® Access® for Office 365™: Part 3 (this course):

Focuses on managing the database and supporting complex database designs , including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

Course Objective: In this course, you will manage an Access database and add complex database features to improve its usability, efficiency, performance, and security.

This Microsoft Access Advanced course covers the following 7 modules:

1. Importing & Exporting Table Data

2. Using Queries to Manage Data

3. Creating Complex Reports & Forms

4. Creating Access Macros

5. Using VBA to Extend Database Capabilities

6. Managing a Database

7. Distributing & Securing a Database