MS Access Basic ver 2007/2010 – Course Outline
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
Input Mask Settings
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
Changing Column Widths
Changing Font Size and Row Heights
Topic 12: Subdatasheets In Tables
Topic 13: Defining Default Relationships Between Tables