MO-A2
Microsoft Office Access: Level 2 Training Class:
- Ways to Train:
- Live Classroom Class is delivered at a Centriq location with a live instructor actually in the classroom.
- Live Virtual Class Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
- HD Class Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
- Ways to Buy:
- Retail Class can be purchased directly via check, credit card, or PO.
- CV Centriq Vouchers Class is available for students using Centriq Vouchers.
- CP Centriq Choice Pass Eligible Class is available to students utilizing Centriq Choice Pass program.
| Start Date | End Date | Duration | Days | Start Time | End Time | Time Zone | Location | Ways to Train | Ways to Buy | Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 09.30.22 | 09.30.22 | 1 Day | F | 8:30AM | 4:00PM | Central | Virtual Only | Live Virtual Classroom | Cash CV Centriq Vouchers CP Centriq Choice Pass Eligible |
$249.00 1.0 CV
|
Enroll Now |
The course assumes you have completed Access 2019 Level 1, or you have equivalent skills in using Access. You will benefit most from this course if you want to be an advanced user of Access 2019.
*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Access 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.
*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Access 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.
Audience
This course provides the concepts and skills for the advanced use of Microsoft Access: How to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.
View the Microsoft Office Access: Level 2 Training Course Outline
Lesson 1: Promoting Quality Data Input
- Topic A: Restrict Data Input Through Field Validation
- Topic B: Restrict Data Input Through Forms and Record Validation
- Topic A: Data Normalization
- Topic B: Associate Unrelated Tables
- Topic C: Enforce Referential Integrity
- Topic A: Create Lookups Within a Table
- Topic B: Work with Subdatasheets
- Topic A: Create Query Joins
- Topic B: Create Subqueries
- Topic C: Summarize Data
- Topic A: Apply Conditional Formatting
- Topic B: Create Tab Pages with Subforms and Other Controls
- Topic A: Apply Advanced Formatting to a Report
- Topic B: Add a Calculated Field to a Report
- Topic C: Control Pagination and Print Quality
- Topic D: Add a Chart to a Report