Database Training with Microsoft Access

Topic 1. Getting Started

Key database concepts

Launching Access and the backstage screen

Creating the database file

Understanding the Trust Center

Digging into Ribbon tabs

Using the Navigation pane

Using the Tell Me feature

Using the Quick Access Toolbar

Signing in to a Microsoft account

Making backups

Accessing Access help

Topic 2. Creating Tables

Understanding table structure and relationships

Creating a table and setting data types

Entering data

Understanding primary and foreign keys

Importing tables

Topic 3. Setting Field Properties

Establishing relationships and maintaining referential integrity

Editing table structure in Design view

Controlling input with masks

Setting the default value

Establishing validation rules

Creating lookup fields

Setting additional field properties

Topic 4. Organizing Records

Formatting columns

Sorting table data

Filtering table data

Searching and replacing values

Topic 5. Using Queries

Understanding queries

Creating queries with the Simple Query Wizard

Building queries in Design view

Establishing constraints with criteria

Specifying criteria with wildcards

Leveraging multiple criteria with AND and OR statements

Filtering with mathematical comparisons

Creating flexible queries with parameter requests

Building expressions

Obtaining summary statistics

Topic 6. Working with Specialty Queries

Using update queries

Using make table queries

Finding unmatched records

Using delete queries

Using append queries

Creating a union query in SQL view

Getting a different look with crosstab queries

Topic 7. Creating Forms

Understanding the role of forms

Generating forms from tables

Adjusting form elements in Layout view

Using the Form Wizard

Topic 8. Designing Forms

Creating forms in Design view

Exploring the form property sheet

Setting data sources

Adding components with form controls

Understanding input boxes

Record navigation

Adding buttons

Assigning a tab order

Checking out the More Forms options

Creating a navigation form

Topic 9. Creating Reports

Introducing reports

Using the Report Wizard

Creating a report in Design view

Editing a report in Layout view

Grouping and sorting records

Creating calculated totals

Applying conditional formatting rules

Creating labels

Adjusting print settings

Topic 10. Working with Macros (Optional)

Creating macros

Embedding macros into buttons

Attaching data macros to tables

Launching macros at startup