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)

           Table properties

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

           Join Properties

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

           Crosstab Queries

           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
                 current record

           Creating Forms with Sub Forms

           The Switchboard

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