Introduction

  • What is a Database?
  • Relational Databases
  • Definitions of Terms used
  • Planning a Database
  • Identify Reasons to Build a Relational Database

Overview of Access

  • Starting & Exiting Access
  • Access Screen Layout & Toolbars
  • Accessing Help

Creating A New Database

  • Creating a Table
  • Customizing Data Entry
  • Data Types and Formats
  • Setting Primary Keys
  • Setting Field Properties
  • Add/Edit Fields
  • Saving Tables
  • Entering /Editing/Deleting Data
  • Understand Different Types of Relationships
  • Set Relationships between Tables

Creating Forms

  • Auto form
  • Form Wizard
  • Columnar Form
  • Tabular Form
  • Entering Data in a Form
  • Modifying a Form
  • Create a Sub Form

Queries

  • Creating a Query
  • Sort Fields in a Query
  • Setting up Criteria
  • Used Expressions within the Query
  • Multi Table Queries
  • Concatenation and Calculation
  • Parameter Queries
  • Change Query Join Types

Reports

  • Create Reports
  • Print Reports