Microsoft Access

Course Description

Learn Microsoft Access with this comprehensive course from TeachUcomp, Inc. Mastering Access Made Easy features 105 video lessons of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more.

Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs.  Simply launch the easy-to-use interface, click to start a video lesson or open one of the manuals and you’re on your way to mastering Access.

Course Syllabus & Sample Lessons

Select any of the video lessons markedto view them in a new window. 

To view samples of the instruction manuals in PDF, click here: Introductory Access | Intermediate Access | Advanced Access

CHAPTER 1-	Getting Acquainted with Access
Lesson 1.1-	Creating a New Database
Lesson 1.2-	Overview of a Database
Lesson 1.3-	The Access Interface
Lesson 1.4-	Touch Mode
Lesson 1.5-	Viewing Database Objects in the Navigation Bar
Lesson 1.6-	Opening and Closing Databases
CHAPTER 2-	Creating Relational Database Tables
Lesson 2.1-	The “Flat File” Method of Data Storage
Lesson 2.2-	The Relational Model of Data Storage
Lesson 2.3-	Tips for Creating a Relational Database
Lesson 2.4-	Creating Relational Database Tables
Lesson 2.5-	Assigning a Primary Key to a Table
CHAPTER 3-	Using Tables
Lesson 3.1-	Using Datasheet View
Lesson 3.2-	Navigating in Datasheet View
Lesson 3.3-	Adding Records in Datasheet View
Lesson 3.4-	Editing and Deleting Records in Datasheet View
Lesson 3.5-	Inserting New Fields
Lesson 3.6-	Renaming Fields
Lesson 3.7-	Deleting Fields
CHAPTER 4-	Field Properties
Lesson 4.1-	Setting Field Properties
Lesson 4.2-	The ‘Field Size’ Property
Lesson 4.3-	The ‘Format’ Property for Date/Time Fields
Lesson 4.4-	The ‘Format’ Property for Logical Fields
Lesson 4.5-	Setting Default Values for Fields
Lesson 4.6-	Setting Input Masks
Lesson 4.7-	Setting Up Validation Rules and Responses
Lesson 4.8-	Requiring Field Input
Lesson 4.9-	Allowing Zero Length Entries
CHAPTER 5-	Joining Tables in a Database
Lesson 5.1-	The Relationships Window
Lesson 5.2-	Enforcing Referential Integrity
Lesson 5.3-	Creating Lookup Fields
CHAPTER 6-	Indexing Tables
Lesson 6.1-	Indexes
Lesson 6.2-	Creating Indexes
Lesson 6.3-	Deleting Indexes
CHAPTER 7-	Queries
Lesson 7.1-	Using the Simple Query Wizard
Lesson 7.2-	Designing Queries
Lesson 7.3-	Joining Tables in a Query
Lesson 7.4-	Adding Criteria to the QBE Grid
Lesson 7.5-	Running A Query
Lesson 7.6-	How is Using the QBE Grid Writing SQL Code?
Lesson 7.7-	Sorting Query Results
Lesson 7.8-	Hiding Fields in a Query
Lesson 7.9-	Using Comparison Operators
Lesson 7.10-	Using ‘AND’ and ‘OR’ Conditions
CHAPTER 8-	Advanced Queries
Lesson 8.1-	Using the ‘BETWEEN…AND’ Condition
Lesson 8.2-	Using Wildcard Characters in Criteria
Lesson 8.3-	Creating a Calculated Field
Lesson 8.4-	Creating ‘Top Value’ Queries
Lesson 8.5-	Function Queries
Lesson 8.6-	Parameter Queries
CHAPTER 9-	Advanced Query Types
Lesson 9.1-	Make-Table Queries
Lesson 9.2-	Update Queries
Lesson 9.3-	Append Queries
Lesson 9.4-	Delete Queries
Lesson 9.5-	Crosstab Queries
Lesson 9.6-	The ‘Find Duplicates’ Query
Lesson 9.7-	The ‘Find Unmatched’ Query
CHAPTER 10-	Creating Forms
Lesson 10.1-	Forms Overview
Lesson 10.2-	The Form Wizard
Lesson 10.3-	Creating AutoForms
Lesson 10.4-	Using Forms
Lesson 10.5-	Form and Report Layout View
Lesson 10.6-	Form and Report Design View
Lesson 10.7-	Viewing the Ruler and Gridlines
Lesson 10.8-	The ‘Snap to Grid’ Feature
Lesson 10.9-	Creating a Form in Design View
CHAPTER 11-	Form & Report Controls
Lesson 11.1-	Selecting Controls
Lesson 11.2-	Deleting Controls
Lesson 11.3-	Moving and Resizing Controls
Lesson 11.4-	Sizing Controls ‘To Fit’
Lesson 11.5-	‘Nudging’ Controls
Lesson 11.6-	Aligning, Spacing and Sizing Controls
Lesson 11.7-	Formatting Controls
Lesson 11.8-	Viewing Control Properties
CHAPTER 12-	Using Controls
Lesson 12.1-	The Controls Group
Lesson 12.2-	Adding Label Controls
Lesson 12.3-	Adding Logos and Image Controls
Lesson 12.4-	Adding Line and Rectangle Controls
Lesson 12.5-	Adding Combo Box Controls
Lesson 12.6-	Adding List Box Controls
Lesson 12.7-	Setting Tab Order
CHAPTER 13-	Subforms
Lesson 13.1-	Creating Subforms
Lesson 13.2-	Using the Subform/Subreport Control
CHAPTER 14-	Reports
Lesson 14.1-	Using the Report Wizard
Lesson 14.2-	Using Basic Reports
Lesson 14.3-	Creating a Report in Design View
Lesson 14.4-	Sorting and Grouping Data in Reports
Lesson 14.5-	Creating Calculated Fields
CHAPTER 15-	Subreports
Lesson 15.1-	Creating Subreports
CHAPTER 16-	Charting Data
Lesson 16.1-	Using Charts
CHAPTER 17-	Macros
Lesson 17.1-	Creating a Standalone Macro
Lesson 17.2-	Assigning Macros to a Command Button
Lesson 17.3-	Using Program Flow with Macros
Lesson 17.4-	Creating Autoexec Macros
Lesson 17.5-	Creating Data Macros
Lesson 17.6-	Editing Named Data Macros
Lesson 17.7-	Renaming and Deleting Named Data Macros
CHAPTER 18-	Switchboard and Navigation Forms
Lesson 18.1-	Creating a Switchboard Form
Lesson 18.2-	Creating a Navigation Form
Lesson 18.3-	Controlling Startup Behavior
CHAPTER 19-	Advanced Features
Lesson 19.1-	Getting External Data
Lesson 19.2-	Exporting Data
Lesson 19.3-	Setting a Database Password
CHAPTER 20-	Advanced Features
Lesson 20.1-	Using Access Help
Lesson 20.2-	The Tell Me Bar- 2016 Only

Microsoft Access Training Course Overview

Microsoft Access is the most popular commercial relational database program on the market today. During this Access 2016 video training course, our expert instructor will show you all about relational databases, forms, reporting, macros and much more. This Access tutorial covers the same material as our three-day classroom training and was designed to provide a solid foundation in Access.

Course includes video lessons, printable instruction manuals, a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission, and a course certificate of completion.

At TeachUcomp, Inc., you choose how you want your Access training delivered.

Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.

Courses are also available individually via digital download and online for a one-time charge.