|
Access Query and Reports |
an eWord company |
|
Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 2000 and XP/2002. |
|
General Course Information This course will provide you with the skills to create queries and reports using Microsoft Access.
You will learn to Ø Use the querying, analyzing, and reporting capabilities of Access Ø Use operators with queries Ø Create basic reports
What skills you need A basic understanding of database concepts and use of an Access database is assumed
Electus training Electus is a South Australian company with 20 years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.
Training includes Each participant receives a training reference manual/workbook and supplementary training materials. Refreshments are provided.
|
|
Duration Half day 9:00am-12:30pm
Who needs to come This course is designed for anyone who is currently using an Access database and who needs to learn the basics of creating queries and reports using Access.
Regular venue 37 Angas Street Adelaide SA (near Victoria Square)
How to book Contact Electus by
Course dates Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.
|
Course Content
|
Using Simple Queries · Using Queries · The Simple Query Wizard · Creating a Query in Design View · Opening and Running a Query · Adding a Table to a Query Modifying Query Results · Sorting and Printing a Query · Adding Criteria to and Hiding a Field in a Query Creating Basic Reports · Using the Report Wizard · Using AutoReport · Working in Print Preview · Basing a Report on a Query · Grouping and Summarising Report Data Using Queries with Operators · Using Comparison Operators · Using the And Condition · Using the Or Condition · Using the Between...And Operator · Using the Expression Builder · Using Wildcard Characters Designing Advanced Queries · Setting Top Values · Creating and Formatting Calculated Fields · Creating a Function Query (overview) · Creating a Parameter Query · Creating a Concatenation Query (overview) · Filter a Query
|
Creating Action Queries (Overview Only) · Creating a Make-table Query · Creating an Update Query · Creating an Append Query · Creating a Delete Query Using Advanced Query Wizards (Overview Only) · Using the Crosstab Query Wizard · The Find Duplicates Query Wizard · The Find Unmatched Query Wizard |