Microsoft Access Beginners

Summary


In this course, you will learn the fundamentals of Access: Tables, Queries, Forms, and Reports. Database design best practices will be examined. You will create a simple ERP database to see how they work together.


Prerequisites


No previous experience with Microsoft Access is required. Must be comfortable with basic computing.

Course Outline



1 - Access Overview
  • Why Is This Section Important?
  • What Types of Applications Can You Develop In Access?
  • Access as a Scalable Product
  • What Exactly Is a Database?
  • Getting to Know the Database Objects
2 - Databases and Tables
  • Why Is This Section Important?
  • Creating a New Database
  • Building a New Table
  • Selecting the Appropriate Field Type for Your Data
  • Working with Field Properties
  • The All-Important Primary Key
  • Working with the Lookup Feature
  • Working with Table Properties
  • Using Indexes to Improve Performance
3 - Table Relationships
  • Why Is This Section Important?
  • Introduction to Relational Database Design
  • Establishing Relationships in Access
  • Establishing Referential Integrity
4 - Queries
  • Why Is This Section Important
  • Everything You Need to Know About Query Basics
  • Ordering Your Query Result
  • Refining Your Query with Criteria
  • Working with Dates in Criteria
  • Understanding How You Can Update Query Results
  • Building Queries Based on Multiple Tables
  • Creating Calculated Fields
  • Getting Help from the Expression Builder
  • Summarizing Data with Totals Queries
  • Excluding Fields from the Output
  • Nulls and Query Results
  • Refining Your Queries
  • Building Parameter Queries
5 - Forms
  • Why Is This Section Important?
  • Uses of Forms
  • Anatomy of a Form
  • Creating a New Form
  • Working with the Form Design Window
  • Selecting the Correct Control for the Job
  • Control Morphing
  • Conditional Formatting
  • What Form Properties Are Available, and Why Should You Use Them?
  • What Control Properties Are Available, and Why Use Them?
  • Bound, Unbound, and Calculated Controls
  • The Command Button Wizards: Programming Without Typing
  • Building Forms Based on More Than One Table
  • Basing Forms on Queries: The Why and How
6 - Reports
  • Why Is This Section Important?
  • Types of Reports Available
  • Anatomy of a Report
  • Creating a New Report
  • Working with the Report Design Window
  • Selecting the Correct Control for the Job
  • What Report Properties Are Available and Why Use Them?
  • What Control Properties Are Available, and Why Use Them?
  • Inserting Page Breaks
  • Unbound, Bound and Calculated Controls
  • Working with Sorting and Grouping
  • Improving Performance and Reusability by Basing Reports on Stored Queries or Embedded SQL Statements