Access Introduction

Description

This 1-day classroom course is suitable for anyone new to Microsoft Access. It takes you through designing and creating a databse from scratch in a hands-on way. Course notes are provided.

What you will learn

Designing and creating a Database
• Creating a Table
• Primary Key
• Setting up Table Fields and applying Field Properties
• Working between Design and Datasheet View
• Entering new records
• Selecting, deleting and editing data
• Sort and Filter Data
• Print Table data

Queries
• Criteria and Expressions
• Designing a Query in the Query By Example Grid
• Sorting and Hiding
• Writing criteria – comparison operators
• Wildcard Searches

Creating and Customising Data Forms
• Creating data entry forms
• Entering and editing data via a form
• Formatting Data Entry forms
• Modifying form and form item properties

Creating and Customising Reports
• Using the Report Wizard
• Creating Reports from Tables and queries
• Creating Grouped Reports
• Modifying Report Designs