Microsoft Access for Beginners - The Complete Beginner's Guide to Access

About Microsoft Access for Beginners - The Complete Beginner's Guide to Access

Introduction to the Course

Download the Course Files

Flat vs Relational Databases. Why Relational Databases are More Efficient.

Create and Save a New Access Database

Understand Access Objects

Naming Conventions

Create the Camrof Ltd Products Table

Create the Camrof Ltd Suppliers Table

Understand & Use the Caption Property

Understand & Use the Field Size Property

Understand & Use the Format Property

Understand & Use the Lookup Wizard to Create Drop-Downs

Understand & Use the Field Description

Enter a Record in the Products Table

Enter a Record in the Suppliers Table

Import Records into the Products Table

Import Records into the Suppliers Table

Sort Records in a Table

Filter Records in a Table

Apply Formatting to the Datasheet View

Freeze Columns in a Table

Build Relationships Between Tables Using the Relationships Window

Build Relationships Between Tables Using the Lookup Wizard

Create the Product Form Part 1

Create the Product Form Part 2 - Placing Controls

Create the Product Form Part 3 - Designing the Form

Create the Product Form Part 4 - Formatting Controls

Create the Product Form Part 5 - The Form Header and Footer

Create the Products Form Part 6: Adding Command Buttons

Create the Products Form Part 7: Form Properties

Create the Supplier Form Part 1: Using the Layout View to Create a Form

Create the Supplier Form Part 2: Formatting Controls in the Layout View

Create the Supplier Form Part 3: Finishing Touches

Create a Form Which Includes a Subform Using the Form Wizard

Create Your First Select Query

Create a Select Query That Includes Two Related Tables

Create a Select Query That Uses And/Or Criteria

Create a Select Query That Uses Comparison Operators

Create a Select Query That Uses Between And Criteria

Create a Query That Uses Wildcard Criteria

Create the Products Report Part 1

Create the Products Report Part 2

Create the Suppliers Report Using the Report Wizard

Create a Navigation Form Part 1

Create a Navigation Form Part 2

Create a Navigation Form Part 3

Student Project: Teala Training Database