Access 2016 On-Demand: Comprehensive (Introduction & Advanced) Course Outline
*** Note: This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase.
About This Course
This Online On-Demand (self-study) training course includes expert lectures, PowerPoint visuals, and demonstrations. You will be able to follow along and successfully complete the course by completing the quizzes and exams. You do not need to own the software for the course and will be able to access the course from any device, provided you have internet access.
When you purchase this On-Demand course from ONLC you will receive a printed Learning Guide with access to downloadable practice files to supplement your learning. You must have the software (purchased version or free trial) to access the practice files. (Note: printed materials are not provided when you purchase the Office On-Demand Comprehensive bundle or when Office On-Demand is included with the All You Can Learn offer.)
Prefer a Live, Instructor-led Class?
If you don't feel On-Demand is right for you,consider our live, instructor-led format (ILT). For more details on the ILT option, click on the link below:
Microsoft Access Training Classes
Duration
You have 24/7 unlimited access for 180-days with this On-Demand course. This course includes 8h 31m of video presentation and, as a traditional course, takes up to 3 days to complete.
Access Introduction Course Content:
Lesson 1: Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access
Lesson 2: Working with Table Data
Modify Table Data
Sort and Filter Records
Lesson 3: Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query
Lesson 4: Using Forms
Create Basic Access Forms
Work with Data on Access Forms
Lesson 5: Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Organize Report Information
Format Reports
Lesson 6 Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships
Lesson 7: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Access Advanced Course Content:
Lesson 1: Organizing a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure
Lesson 2: Joining Tables
Create Query Joins
Relate Data Within a Table
Work with Subdatasheets
Lesson 3: Creating Advanced Queries
Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries
Lesson 4: Using Advanced Reporting Techniques
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Lesson 5: Implementing Advanced Form Design
Add Controls to Forms
Enhance Navigation and Organization of Forms
Apply Conditional Formatting
Lesson 6: Using Data Validation
Use Field Validation
Use Form and Record Validation
Lesson 7: Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 8: Using Advanced Database Management
Manage a Database
Determine Object Dependency
Document a Database
View outline in Word
GACZ16
Facebook
LinkedIn