Microsoft Access Intermediate
Who is the course for?
This is a practical hands-on course designed for database users who need to extend their Access skills. Practice tasks and case studies ensure that techniques can be applied quickly in a demanding financial and business environment
Is this course suitable for me?
Take the Skills quiz
Pre-requisites
The course assumes that you have a basic understanding of a relational databases, and that you know how to create tables and select data with queries
What are the objective of the course?
By the end of the course, you will be able to:
Import and link data and describe the difference between importing and linking
Create and use action queries to delete, update and append data
Export and use data in another application; create forms using wizards, and basic design techniques to make them more user-friendly
Create reports using wizards, and modify the layout using basic design techniques
What does the course cover?
Reviewing Access: How Access objects work together; the importance of using appropriate relationships in a database; creating and running queries with various criteria
Working with imported data: Importing or linking data; importing data from other applications (such as Excel or text files); importing from other Access databases; defining an import specification
Exporting data: Exporting to a text file, worksheet or database files; merging Access data with a Word document
More on queries: Using the query wizards to find duplicates or unmatched records; using action queries to create tables, delete data, append or update records; summarising information with cross-tab queries and totals
Creating forms and reports: Using the form and report wizards to create a basic form and report
Customising forms: Using the form design view; adding controls; setting properties of controls; setting form properties; changing the tab order
Customising reports: Working in design view; report sections and their properties; working with groups; adding subtotals and totals; controlling page breaks
How long does the course last?
1 day
