Getting Started — Database Design
Learn Access terminology, relational database design, primary and foreign keys, normalization, and data integrity.
Microsoft Office Training
Microsoft Access Lessons
Learn databases, tables, queries, forms, and reports in Microsoft Access.
Two-part learning path
Begin with relational database fundamentals and core Access objects, then continue into advanced queries, automation, forms, and reports.
Advertisement
Access Learning Path
Choose a Module
Work through the lessons in order to build the No Fault Travel database, or open the topic that matches the skill you need today.
1
Module 1
Access: The Basics
Build a complete relational database from the ground up, then use tables, forms, queries, reports, and combo boxes to enter, retrieve, and present information.
Creating Databases
Create an Access database and design tables with suitable field names, data types, descriptions, and primary keys.
Creating Relationships
Create one-to-many table relationships and apply referential integrity and cascade options.
Understanding Field Properties
Use field size, format, input masks, validation rules, validation text, and default values.
Working with Data in Tables
Enter, sort, edit, resize, undo, and delete records in Access tables.
Creating and Using Forms
Create forms with the Form Wizard and Design View, enter records, navigate, and find information.
Creating and Using Queries
Create select queries, add fields, sort results, apply criteria, and combine related tables.
Creating and Using Reports
Create mailing labels and reports, group and summarize records, and refine report layouts.
Combo Boxes and Form Enhancements
Improve forms with titles, formatting, aligned controls, and combo boxes that display related values.
2
Module 2
Access: Beyond the Basics
Extend your database skills with lookup fields, filters, outer joins, calculated queries, advanced forms and reports, macros, parameters, and action queries.
Lookup Fields and Validation Rules
Create lookup fields that display meaningful values and table-level validation rules that compare fields.
Working with Filters
Filter Access tables and forms by selection, exclusion, multiple criteria, dates, and partial text.
Working with Join Properties
Change query joins to include unmatched records and identify clients without related trips.
Creating Calculations in Queries
Create calculated fields, use built-in functions, and build totals queries with Sum, Average, and Count.
Advanced Form Features
Add calculated controls and related-record subforms to Access forms.
Advanced Report Features
Create report calculations, concatenate fields, count records, and control page breaks.
Creating and Using Macros
Automate Access tasks with standalone and embedded macros, events, SetValue actions, and conditions.
Parameter and Action Queries
Prompt users for criteria and safely update selected records with action queries.
Advertisement