Start

Introduction

Introduction to Database Objects and the Access Interface

Exploring the Login and Homes Forms

Exploring Datasheet View, Design View, and SQL View for Query Objects

Exploring Report View, Layout View, Design View, and Print Preview for Report Objects

Examining VBA Code

Exploring the Relationships Window and Closing the Database

Creating Blank Databases

Switching Default Table to Design View and Renaming the Primary Key Field

Field Descriptions, Format and Text Limit, and Input Mask

Creating New Tables in Design View

Manually Entering Table Data

Importing from Excel - Appending with Different Data Types Error - Customers

Importing from Excel - Adding Data into New Tables

Reviewing Data Types and Field Properties for Imported Tables - Orders

Setting a Composite Key - Order Details

Sorting Table Data

Introduction to Relationships

Common Fields Between Tables

Creating Relationship Errors

Manually Repopulating Table Fields

Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error

Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship

Conclusion

Start

Introduction

Fixing Minor Table Issues

Creating Two Queries Using the Simple Query Wizard

Customizing Queries with Criteria and Criteria Wildcards

Creating Customer Forms Using the Form Wizard

Creating Employee Forms Using the Form Wizard

Creating Forms by Using Save As on a Table Object

Entering Customer Records

Creating Reports by Using Save As on a Query

Queries, Forms, and Reports Recap

Introduction to Query Reports and Complex Queries

Changing Queries to a Left Outer Join

Using the Like Keyword for a Range of Characters

Creating Custom Fields with Calculations in a Query

Creating and Formatting Another Calculated Field

Creating Automated Requests for Criteria

Using Wildcards in a Parameter Query

Crosstab Query Wizard

Find Unmatched Query Wizard

Introduction to Action Queries

Append Action Query

Delete Action Query

Report Design View

Conclusion

Start

Introduction

Introduction to Advanced Forms and Automation

Using Subform Control to Connect Sub and Main Forms

Creating Tabbed Forms and Populating Pages

Renaming Page Tabs and Adding Form Headers to Tabbed Forms

Creating Split Forms

Adjusting the Tab Order on a Form

Adding Command Buttons to Forms for Navigation

Adding Items to Switchboards

Introduction to Designing Macros to Automate Database Tasks

Using Message Boxes to Inform Users

Automating Parameter Queries with Macros

Viewing Related Records in a Form with Macros

Testing the Previous Macro

Using Macros to Validate Data Entry

Using VBA to Secure a Form with a Password

Creating User Input Boxes with VBA

Advanced Forms and Automation Recap

Introduction to Database Security and Options

Examining Back-End Databases

Moving Back-End Databases and Using the Linked Table Manager to Point to a New Path

Applying the Compact and Repair Tool

Generating Database and Relationship Reports

Conclusion

Introduction

Database Objects and the Access Interface

Creating New Databases

Entering Data into Tables

Relationships

Queries, Forms, and Reports

Query Reports and Complex Queries

Advanced Reports, Automating Queries, and Using Query Wizards

Action Queries

Advanced Forms and Automation

Designing Macros to Automating Database Tasks

Access Visual Basic for Complex Automation

Database Security and Options

Conclusion

Start

Database Basics

Accessing the Northwind Template

Navigation Pane Default View and Datasheet and Design Views for Tables

Exploring Form View, Layout View, and Design View for Form Objects

Exploring Report View, Layout View, Design View, and Print Preview for Report Objects

Examining VBA Code

Exploring the Relationships Window and Closing the Database

Creating Blank Databases

Adding Remaining Fields to the Customers Table

Field Descriptions, Format and Text Limit, and Input Mask

Creating New Tables in Design View

Manually Entering Table Data

Importing from Excel - Appending with Different Data Types Error - Customers

Importing from Excel - Adding Data into New Tables

Reviewing Data Types and Field Properties for Imported Tables - Products

Order Details Table - Discussing Composite Key Fields

Inclusive Filtering, Exclusive Filtering, and Filtering by Form

Adding Tables to the Relationships Window and Organizing Them

Creating a One-To-Many Relationship Between Customers and Employees Tables

Creating Relationship Errors

Manually Repopulating Table Fields

Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error

Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship

Conclusion

Start

Introduction to Queries, Forms, and Reports

Creating Two Queries Using the Simple Query Wizard

Customizing Queries with Criteria and Criteria Wildcards

Viewing Expanded Table Data

Creating Employee Forms Using the Form Wizard

Creating Forms by Using Save As on a Table Object

Using Forms for Data Entry

Creating Reports by Using Save As on a Query

Queries, Forms, and Reports Recap

Introduction to Query Reports and Complex Queries

Changing Queries to a Left Outer Join

Using the Like Keyword for a Range of Characters

Creating Custom Fields with Calculations in a Query

Creating and Formatting Another Calculated Field

Query Reports and Complex Queries

Introduction to Automation, Wizards, and Advanced Reports

Using Wildcards in a Parameter Query

Crosstab Query Wizard

Find Unmatched Query Wizard

Introduction to Action Queries

Append Action Query

Delete Action Query

Report Design View

Conclusion

Start

Opening a Sample Database

The Database Objects

Introducing Tables

Simple Data Entry

Introducing Queries

Introducing Forms

Data Entry Into Forms

Introducing Reports

Finding Data in Tables

Filtering

Adding Total Rows

Creating Tables in Design View

Entering Your First Record

Using Quick Starts to Create Tables

Summary

Introduction

Looking at the First Draft of a Database

The Relationships Window

Relating by Dragging Field Names

Dragging to Create 1-to-1 Relationships

Limit-To-List Properties

Enforced Referential Integrity

Seeing the Referential Integrity Being Enforced

More Field Properties

00. Introduction

01. What is Microsoft Access?

02. Planning Your Database

03. Getting Started

04. Customer Table, Part 1

05. Customer Table, Part 2

06. Entering Data, Part 1

07. Entering Data, Part 2

08. Sorting & Filtering

09. Customer Queries

10. Customer Form 1

11. Customer Form 2

12. Customer Reports