Access 2007 - Beginner

Overview

About this course

Self-paced lessons on Access 2007 basics: opening and creating databases and building tables, queries, forms and reports.

Curriculum

Curriculum

11 modules

Introduction

Starting Access
Navigating the Main Screen
Using the Quick Access Toolbar and Ribbon
Using the Navigation Pane
Navigating in the Document Window

Opening a Table
Navigating a Table
Using Quick Search
Using Quick Filter

Adding Fields
Changing the Data Type
Adding a Lookup Field
Deleting a Field

Understanding The Design View
Setting Input Masks
Using The Lookup Tab
Indexing A TableÂ

Adding a Record
Using Zoom Mode
Using Shortcut Keys
Filtering Data

Using the Find Dialog Box
Using Replace
Deleting Records
Changing Table Appearance

Understanding Query Types
Using the Query Wizard
Using the Query Design View
Using the QBE Grid
Entering Criteria
Creating a Query Manually
Using Logical Operators in Criteria
Using Wildcards in Criteria

Understanding Forms
Creating a New Form
Using the Form Design Window
Selecting, Moving, and Resizing Controls

Understanding Report Design Steps
Creating a Report
Modifying Controls in a Report
Basing a Report on a Query
Adjusting and Printing a Report

Course Recap

Who it's for

Who it's for

Users of Access 2007.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.