The course concentrates on designing tables in a database, setting up relationships between the tables and setting up lookups between the tables. Table properties are explained in detail.  Linking/Importing from other applications are also covered.  Sample database templates are used for illustration. The user is introduced to queries, forms and  reports.

Delegates will be created a simple database during the course to illustrate all the features of a database.

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: 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 Terminology

What is a table?

What is the Primary key of a table?

What is a Foreign key?

What is a query?

What is a form?

What is a report?

what is a macro?

What is a module?

Topic 2: Database Templates

Topic 3: Security in Access

               Trust Centers:  Setting up Trusted Locations   

Topic 4: Navigation in the MS Access environment

               The Access Screen

               Navigating in an existing database

               Using the ribbon

               Shortcut Menus and Shortcuts

               Using the Wizards to create tables, queries, forms and reports

Topic 5: Printing In Access

Topic 6: Using Help

Topic 7: Naming Conventions for objects in a database

Topic  8: Database Planning

Topic 9: Designing Tables

               Setting The Primary Key

               Selecting The Data Type For Table Fields

               Captions

               Input Mask Settings

               Formatting Numbers/Text/Dates

               Default Value

               Using Validation Rules and Validation Text

               Indexing in tables

                   Using Unique Indexes

               Lookups to other tables/queries or create a typed list

               Copying/Deleting a table

Topic 10: Importing/Linking tables

Topic 11: Navigating And Working In Tables

         Editing A Table

         Finding /Replacing data

         Deleting records

         Rearranging Fields

         Changing Column Widths

         Sorting

         Changing Font Size and Row Heights

         Hiding/Unhiding Columns

         Freezing/Unfreezing Columns

         Filtering Data

Topic 12: Subdatasheets In Tables

Topic 13: Defining Default Relationships Between Tables