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 

What We'll Explore:

• Introduction into How Databases Operate 
• Learning the Access Interface 
• Creating A New Database 
• Designing and Creating New Tables 
• Entering Data into Tables 
• Sorting and Filtering Data 
• Introduction into Relating Table Data 
• Create Commonly Used Queries 
• Customizing Queries with Criteria 
• Using Forms for Data Entry 
• Create Reports for Data Output