Credential(s) Offered
Industry certification, Secondary school diploma
Method of Delivery
Hybrid or blended
When offered
Daytime Hours
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
Related Classes
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
Details
Program Length (Weeks)
1
Hours
7
Entrance Requirements
Combination of Education and Course(s)
School
WIOA Approved Program
Yes
Curriculum Competency Based
Access Level 3: Advanced Topics
Training Location(s)
343 Gorham Rd South Portland, ME
Local WIB
4 - Coastal Counties Local Area 4
Type of Attainment:
Postsec. Awards/Cert./Diplomas; <1 yr.
Name of Credential
Access
Type of financial aid offered or have access to
N/A
Refund Policy
https://vtec.org/About/Cancellation/
Is the proposed curriculum currently certified by an accrediting agency or similar national standardization program?
Yes - Microsoft
Is this proposed curriculum considered a nontraditional program of training services for women?
No
Is this proposed curriculum considered a nontraditional program of training services for men?
No
Cost Items
Books (Estimated)
$45.00 Courseware and Labs
Testing/Exam Fees
$125.00
In-State/District Tuition
$495.00 1-Day Course
Total In-State Program Cost
$665.00