MS Access Advanced ver 2007/2010 – Course Outline
This course concentrates on Form and Report Design. Overview on Table design and Query Design. In this course the delegates would be expected to design a simple integrated database, consisting of tables, queries, forms, reports and macros.
The course covers ISETT Unit Standard: 116936 and 117927
Duration: 14 hours suggested 2 day course (if only specific topics are covered the course can be done in one day)
Target Group: This course is intended for a delegate who knows the basics of MS Access. Delegates should already be able to create their own queries in MS Access and they must understand the concepts of a database. 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: 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: Database Design
What is the aim of the database?
What must the database generate as output?
What fields do I need?
Which tables must I create from the fields?
What data must be validated and which fields are you going to be compulsory to fill in. What other properties will be needed, e.g. formatting
How will I input the information?
How will I automate my database?
Testing the Database
Topic 2: Trust Centers and setting up trusted locations
Topic 3: Tables (Overview)
Topic 4: Normalisation – explaining the concept and illustrate with tables being imported from Excel
Topic 5: Relationships between tables
Different types of Relationships
Setting Referential Integrity to protect data
The Cascade Update Related Fields Option
The Cascade Delete Related Records Option
Topic 6:Queries (Overview)
Different Types of Queries
Creating a query to search for a blank field
Using the left, middle, right, str$ functions to create codes
Topic 7: Specialised Queries
Creating a Parameter Query
Using Calculations in A Query
Setting Formats for a field in a Query
Find Unmatched Query
Topic 8: Action Queries
Make-Table Query, Delete Query, Append Query, Update Queries
Topic 9: Forms
Tips and Tricks when designing a Form
To insert fields not displayed on a form
Disable Fields on a Form
To hide a Field on a Form
Tab Indexes on a Form
Topic 10: Using Controls in Forms
Adding controls to a form that perform tasks
Calculations on a Form
Working with Combo Boxes to find specific data on a form and formatting this combo box to always show the
Creating Forms with Sub Forms
Topic 11: The Startup Menu Option – opening the database with a specific form and hiding objects
Topic 12: Reports
Sort records in a report
Using grouping in reports to display totals
Create a report based on more than one table
Showing/Hiding Headers and Footers in a Report
Section width greater than Page Width
Saving A Form as A Report
Creating Mailing Labels
Topic 13: Documenting The Design Of A Database
Topic 14: Exporting to Word/Excel/PDF format