This course concentrates on the design of queries.  Forms and Reports are handled on an introductory level only.

The course covers ISETT Unit Standard: 116936

Duration: 7 hours

Target Group: This course is intended for a delegate who would have to design new tables in MS Access or users who need to link/import existing Excel data into Access. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

Prerequisites: It would be an advantage to have attended the MS Access Basic course, but if the user is not going to be designing tables and ONLY going to be using existing data i.e. SQL tables or tables that have already been set up, they can start with this course. 

The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills.  Excel knowledge would be an advantage, but is not essential. 

Method of training: Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.

Topic 1: Tools to run MS Access efficiently

         Compacting and repairing a database

         Making a backup of a database

         Working with Trust centers – Trusted locations

Topic 2: Queries

         Viewing Existing Queries

         Using the Query Window

         Examples Of Typical Criteria

         Creating A Query With A Sorting Order

         Adding Another Table In The Query Design

         Create A Query That Is Based On More Than One Table

Topic 3:  Using Calculations In A Query

         Using A Concatenation Operator In A Query (Combining Two Or More Fields)

         Calculating Totals In A Query (Group By)

Topic 4: More advanced Query options

         Creating a query from another query

         Determining the top 10

         Creating a parameter query (Prompting the user to supply the criteria)

Topic 5: Printing query results

Topic 6: Specialised queries

         Crosstab Queries

         Find Unmatched Query

         Find Duplicates Query

Topic 7: Action Queries

         Creating a Make-Table Query

         Creating a Delete Query

         Creating an Append Query

         Update Queries

Topic 8: Join Types In Queries

Topic 9: Forms (Introduction)

         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

Topic 10: Reports

         Creating a report using the report wizard

         Totals/summary options on reports

         Printing a report

Topic 11: Exporting A Report As An Excel File

Topic 12: Send An Access Report To A Mail Recipient (Email) 

               PDF format

               Excel format