The intermediate Microsoft Access course covers queries, forms and reports.
Versions 2007 and 2010
Duration
1 day (minimum of 6 people)
Outcomes
To enable delegates to:
- Create queries
- Create forms
- Create reports
Unit Standards
Not applicable
Prerequisites
Delegates should be familiar with those topics covered in the Beginners Level.
Course content
Module 1: Introduction
- Compacting and repairing a database
- Making a backup of a database
- Trust centres
Module 2: Queries
- Viewing existing queries
- Creating queries
- Changing the size of the query design window
- Query names
- Examples of typical criteria
- Creating a query with a sorting order
- Working with fields in the design grid
- Adding a table in the query design
- Using or-based criteria in a query
- Combining and-or conditions in a query
- Using calculations in a query
- Create a query that is based on more than one table
- Using a concatenation operator in a query (combining two or more fields)
- Calculating totals in a query (group by)
- Creating a query from another query
- Determining the top 10
- Creating a parameter query
- Printing query results
- Specialised queries
- Advanced query features
- Crosstab queries
- Find unmatched query
- Find duplicates query
- Action queries
- Creating a make-table query
- Creating a delete query
- Creating an append query
- Update queries
- Join types in queries
Module 3: Creating Forms
- Using the form button
- To delete a form
- Creating a form with the form wizard
- Different views for a form
- Tips and tricks when designing a form
- To insert fields not displayed on a form
Module 4: Reports
- Creating a report using the report wizard
- Deleting a report
- Totals/summary options on reports
- Printing a report
- Exporting a report as an excel file
- Saving a report
- Deleting a report
