Microsoft Access 2010 Introduction

Course objectives

• Organise data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
• Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
• Modify a table's design; use the attachment data type; find and replace data; sort, filter, and delete records.
• Set field properties, create input masks, and set validation rules.
• Create queries, and sort and filter the results; modify queries; and perform operations in queries.
• Create, modify, and work with forms; and use them to sort and filter records.
• Create reports by using the Report button, the Report Wizard, Design view, Layout view, and queries; modify and print reports.

Course outline

Getting started

• Database concepts
• Exploring the Access environment
• Getting help

Databases and tables

• Planning and designing databases
• Exploring tables
• Creating tables

Fields and records

• Changing the design of a table
• Finding and editing records
• Organising records

Data entry rules

• Setting field properties
• Working with input masks
• Setting validation rules

Basic queries

• Creating and using queries
• Modifying query results and queries
• Performing operations in queries

Using forms

• Creating forms
• Using Design view
• Sorting and filtering records

Working with reports

• Reports
• Modifying and printing reports