It looks like you're using IE11...
This browser offers limited functionality on our website. We recommend you use the latest version of Chrome, Safari, Edge and Firefox.
One day: 9.30am to 4.30pm
Microsoft Access is a database software application. It is a tool for storing information which can then be retrieved using reports and queries.
All the information in the database is held in tables created by the user and forms are used to add information to the database in a more user friendly format. Queries are used to retrieve information from the database, which can then be displayed as a report. This course is an introduction to Access covering tables, forms, queries and reports.
A basic understanding of Microsoft Windows.
Exercise | Details |
---|---|
Exercise 1 | Creating an Access database
|
Exercise 2 | Creating tables
|
Exercise 3 | Amending the design of a table
|
Exercise 4 | Creating Tables
|
Exercise 5 |
Creating relationships
|
Exercise 6 |
Entering information into a table
|
Exercise 7 |
Creating forms
|
Exercise 8 |
Formatting a form
|
Exercise 9 |
Adding a form header and footer
|
​Exercise 10 |
Modifying forms
|
Exercise 11 | Creating queries in design view
|
Exercise 12 | Creating queries in design view based on two tables
|
Exercise 13 | Reports
|
Exercise 14 | Finding information in a table
|
Exercise 15 | Creating Filters
|
Exercise 16 | Sorting information
|
After completing this course you will be able to:
You will complete all of these using Microsoft Access.
External attendees: £110 plus VAT per candidate.