Access Introduction

Module 1

Introduction into How Databases Operate

• Exploring a Relational Database
• Examining Database Objects 
• How Data Is Related Between Tables 

Learning the Access Interface

• Examining Access Menu Tabs 
• Using the Access Navigation Pane 
• Using the Data View and Design View of an Object 

Creating A New Database

• Planning Steps to Create a New Database

Designing and Creating New Tables

• Create Tables in Design View
• Import Data from Excel

Entering Data into Tables

• Data Entry Techniques and Shortcuts 

Sorting and Filtering Data

• Re-arranging Records by Sorting 
• Hiding Records Using Filtering 

Introduction into Relating Table Data

• Using the Relationships Window 

Create Commonly Used Queries

• Using the Simple Query Wizard 
• Creating Queries in Design View 

Customizing Queries with Criteria

• Adding Criteria for Text, Number, And Date Fields
• Introduction into Using Wildcards in Criteria 

Module 2

Using Forms for Data Entry

• Creating Forms
• Exploring Different Form Layouts
• Perform Data Entry in Forms

Create Reports for Data Output

• Basing Reports on Queries 
• Previewing and Printing Reports 
• Understanding the Report Design Interface 
• Formatting Reports for Professional-Looking Output