-
Duration
One day: 9.30am - 4.30pm
-
Description
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.
-
Prerequisites
A basic understanding of Microsoft Windows.
-
Agenda
Exercise Details Exercise 1 Creating an Access database - Creating, naming and saving a database
Exercise 2 Creating tables - Creating, naming and saving a table
- Defining a primary key and indexing fields within a table
Exercise 3 Amending the design of a table - Changing the properties for the fields in the table
- Creating lookup fields
Exercise 4 Creating Tables - Creating, naming and saving a table
- Defining a primary key and indexing fields within a table
Exercise 5 Creating relationships
- Linking tables
Exercise 6 Entering information into a table
- Entering information into a table using Datasheet View
Exercise 7 Creating forms
- Creating simple forms
- Using the Form Wizard
Exercise 8 Formatting a form
- Formatting the appearance of a form using the available tools
Exercise 9 Adding a form header and footer
- Add a header and footer to your form
- Insert pictures into your form
​Exercise 10 Modifying forms
- Formatting the form
- Creating headers and footers
Exercise 11 Creating queries in design view - Creating, saving and executing queries based on one table
Exercise 12 Creating queries in design view based on two tables - Creating, saving and executing queries based on two tables
Exercise 13 Reports - Creating various types of reports using basic reports and the report wizard
- Formatting the appearance of a report using the available tools
Exercise 14 Finding information in a table - Locating specific records within a table
Exercise 15 Creating Filters - Using a filter in a table’s datasheet view
Exercise 16 Sorting information - Sorting the information in a table
-
Goals and objectives
Goals- To introduce the concept of a database.
- To introduce ways in which information can be displayed and obtained from a database.
ObjectivesAfter completing this course you will be able to:
- open Microsoft Access
- create, open and save a database
- create tables within a database into which records can be entered
- edit the information within a table
- link multiple tables
- create and edit forms used to enter information
- create and execute queries to retrieve specific information
- create queries based on multiple tables
- create filters and sorts
- create reports based on tables or queries
- create formulae within Access to the summarise data in reports
- navigate between tables, forms, reports and queries using the Database Window
- save the database
- close Microsoft Access.
You will complete all of these using Microsoft Access.
-
Costs
External attendees: £110 plus VAT per candidate.