Access Level 3: Advanced Topics

Instructional Program (CIP)

Description

• Course Overview


• You've covered many of the basic functions of Microsoft® Office Access®, 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.
  
  This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Access 2019/2021.
  
  This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.


• Audience


• Students taking this course are database administrators or prospective database administrators who have experience working with Access 2019/2021 and need to learn advanced skills.

Prerequisites

• To ensure your success in this course, you should have experience working with Access 2019/2021, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships. You can obtain this level of skills and knowledge by taking the following Logical Operations courses:
  
  Microsoft® Office Access® 2019/2021: Part 1
  Microsoft® Office Access® 2019/2021: Part 2

Register

Related Classes

• Access 2021/2019 Level 1


• Access 2021/2019 Level 2

View All

Course Disclaimer

*Course cost listed does not include the cost of courseware $ 25.65. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to a minimum enrollment. Course may run as a virtual instructor led course if minimum enrollment is not met.

Exam not included.

Course Details

• Lesson 1: Importing and Exporting Table Data


• Topic A: Import and Link Data


• Topic B: Export Data


• Topic C: Create a Mail Merge


• Lesson 2: Using Queries to Manage Data


• Topic A: Create Action Queries


• Topic B: Create Unmatched and Duplicate Queries


• Lesson 3: Creating Complex Reports and Forms


• Topic A: Create Subreports


• Topic B: Create a Navigation Form


• Topic C: Show Details in Subforms and Popup Forms


• Lesson 4: Creating Access Macros


• Topic A: Create a Standalone Macro to Automate Repetitive Tasks


• Topic B: Create a Macro to Program a User Interface Component


• Topic C: Restrict Records by Using a Condition


• Topic D: Create a Data Macro


• Lesson 5: Using VBA to Extend Database Capabilities


• Topic A: Getting Started with VBA


• Topic B: Using VBA with Form Controls


• Lesson 6: Managing a Database


• Topic A: Back Up a Database


• Topic B: Manage Performance Issues


• Topic C: Document a Database


• Lesson 7: Distributing and Securing a Database


• Topic A: Split a Database for Multiple-User Access


• Topic B: Implement Security


• Topic C: Convert an Access Database to an ACCDE File


• Topic D: Package a Database with a Digital Signature

Access 2016 Level 3

Access 2019 Level 3

Details

Cost Items

Demand Occupation(s)