Access 2010 - Beginner

Overview

About this course

Self-paced lessons on Access 2010 basics: opening and creating databases and working with tables, queries, forms and reports.

Curriculum

Curriculum

9 modules

Introduction

Using the File Tab
Using Templates
Reviewing the Ribbon
Customizing the Quick Access Toolbar
Understanding the Navigation Pane

Opening a Database
Using the Navigation Pane
Reviewing the Anatomy of a Table
Adding a Record
Using the Navigation Buttons
Using the Search Text Box
Using the Field Quick Filter Button
Reordering Columns

Creating a New Table in Design View
Understanding the Table Design View
Understanding the Different Data Types
Adding Fields
Adding Calculated Fields
Adding and Validating Record Data
Using the Datasheet View
Adding Pre-Defined Fields
Modifying Fields

Searching with Wildcards
Using the Replace Feature
Adding Totals
Understanding Table Relationships
Adding the Subdatasheet

Using the Query Wizard
Using the Query Design View
Setting Query Criteria
Creating a New Query
Using Range Operators

Creating Simple Forms Using the Form Wizard
Understanding the Form Design View
Selecting, Moving, and Resizing Controls
Creating a Simple Form Using the Form Button
Using Labels
Formatting Controls
Setting Tab Order

Creating Simple Reports Using the Report Wizard
Selecting, Moving, and Resizing Controls
Using Report Bands
Using Groups
Using Controls
Changing the Page Layout

Course Recap

Who it's for

Who it's for

Users of Access 2010.

Before you start

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