Access - Introduction

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Outcomes: 

• 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 some text
• Create Reports for Data Output 

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