Microsoft Access Level One

Microsoft Access Level One

This course is designed for anyone new to Access as well as people who are using Access but are struggling to understand or change existing databases. At the end of the course the learner will be able to create their own database containing tables, forms, queries and reports and confidently understand existing databases. During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued.

· What is a Database?
· Exploring Database Terminology
· Understanding Database Structure
· Creating a Database Table in Design View and using the Wizard
· Understanding Key Fields
· Editing an Existing Database Table
· Changing Table Field Names, Properties and Structure
· Creating a Form in Design View and Using the Wizard
· Editing an Existing Form
· Add, Move and Delete Controls in a Form
· Using the toolbox to add to a Form
· Using the Format Painter and Navigation Bar in a Form
· Creating a Report in Design View and using the Wizard
· Designing a Report and the functions that can be used
· Using Bound and Unbound Controls in a Report
· Grouping and Sorting within a Report
· Understanding and Creating Sections within a Report
· Creating a Query in Design View and using the Wizard
· Creating Multi-table Queries
· How to Manipulate Tables within the Query Window
· Understanding Calculating Fields
· Creating, Editing and Deleting a Switchboard