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

 

Further information

We Are Excel
Provider:
We Are Excel
Duration:
1 Day
Price:
£240 (ex VAT)
Availability:
On demand
Course type:
Classroom
Locations:
London (Aldgate), iHub Birmingham

Contact Information

We Are Excel

WeWork Offices
2 Leman Street
London
E1 8FA

Locations