- 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.29.22 | 09.29.22 | 1 Day | TH | 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 |
12.05.22 | 12.05.22 | 1 Day | M | 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 |
*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 is intended for students who will be working with existing databases rather than building them from scratch. It is best suited to database end users rather than database designers/managers. This course provides the basic concepts and skills to start using Microsoft Access 2019: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.
You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports. The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Access or another database system before.
View the Microsoft Office Access: Level 1 Training Course Outline
Lesson 1: Getting Started with Access 2019
- Topic A: Launch Access and Open a Database
- Topic B: Use Tables to Store Data
- Topic C: Use Queries to Combine, Find, Filter, and Sort Data
- Topic D: Use Forms to View, Add, and Update Data
- Topic E: Use Reports to Present Data
- Topic F: Get Help and Configure Options in Microsoft Access
Lesson 2: Creating Tables
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
Lesson 3: Creating Queries
- Topic A: Create Basic Queries
- Topic B: Perform Calculations in a Query
- Topic C: Sort and Filter Data in a Query
Lesson 4: Creating Forms
- Topic A: Start a New Form
- Topic B: Enhance a Form
Lesson 5: Creating Reports
- Topic A: Start a New Report
- Topic B: Enhance Report Layout