Microsoft Office Access 2007

Course Description
Microsoft® Office Access 2007 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access 2007 capabilities. It is designed for computer users who are new to database programs or who only plan to use Access occasionally.

Course Prerequisites
This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.

Course Objectives
After completing this course, you will be able to:

• identify parts of the Access screen
• define fields, data types and tables
• create a database using templates, create a blank database, open, save and close databases
• create a table using Datasheet View or Design View
• insert, delete and modify data in a table
• add, modify and remove primary key fields
• insert, modify and delete a field
• add a total row to a table
• format, rename and delete tables
• save database items in a variety of file formats
• import or export data from or to other applications
• find and replace data using exact or partial matches, case sensitive and wildcard searches
• sort and filter data
• create, save, close, or run a query using the wizard or in Design View
• create query criteria using comparison, wildcard, AND, OR operators, or calculated fields
• change queries field properties and apply aliases
• create one-to-one, one-to-many and many-to-many relationships
• use the table analyzer
• perform maintenance on databases
• identify object dependencies
• open a database exclusively or with shared access
• use the Database Documenter
• create a form using the Form tool or the Form wizard
• create a form in design or layout view
• add, move, resize, delete, formatting, space, anchor or group controls
• creating datasheet forms, multiple item forms, split forms, and PivotTable forms
• create a report using the Report Tool and Report Wizard
• modify a report in design or layout view
• print and preview forms and reports
• create mailing labels
• use input masks, validation rules, or indexed fields
• use the lookup wizard or create lookup fields manually
• work with query joins
• create parameter, unique, unmatched and duplicate select queries
• create summary, action, and sub queries
• use embedded macros in forms or reports
• create and modify charts
• create a subform or subreport using the wizard or the subform/subreport too

Course Outline

 Lesson 1: Introducing Access
Overview
Planning a Database
Designing the Database
Creating a Database Using a Template
Moving Around a Database
Creating a Blank Database
Organizing Files

Lesson 2: Creating and Modifying Tables
Creating Tables using Datasheet View
Moving Around a Table
Inserting, Deleting and Modifying Data in a Table
Creating Tables using Table Templates
Creating Tables Based on Existing Tables
Creating a Table in Design View
Modifying Data Types
Modifying Field Properties
Adding and Removing Primary Keys
Adding and Removing Multiple Primary Keys

Lesson 3: Manipulating a Table
Restructuring Tables
Formatting Tables
Modifying Tables
Printing and Distributing Tables
Saving a Table as a Web Page
Exporting as PDF or XPS Format

Lesson 4: Data Manipulations
Inserting and Deleting Records
Importing and Exporting Data
Exporting Data to Other Applications
Finding and Replacing Data

Lesson 5: Sorting and Filtering
Sorting Records
Filtering Records

Lesson 6: Select Questions
What is Query?
Creating a Query using the Wizard
Creating a Query in Design View
Saving, Closing and Running Queries
Adjusting Queries
    Adding, Modifying, Deleting and Changing the Order of Fields
Sorting Fields
Showing and Hiding Fields
Applying Criteria
    Using Comparison Operators
Using Wildcard Characters
Functions and Calculated Fields
Changing Field Properties
Working with Aliases
Filtering Query Data

Lesson 7: Relating Multiple Tables
Establishing Table Relationships
Enforced Referential Integrity
Print Relationships
Using the Table Analyzer

Lesson 8: Maintaining Databases
Database Maintenance
Opening Databases
Modify Database Options
Modifying Database Documenter
Saving a Database to a Previous Version
Saving a Database with a Password
Splitting Databases

Lesson 9: Working with Forms
What is a Form?
Creating a Form
Using Forms
Sorting Data
Filtering Data
Printing Forms
Exporting as PDF or XPS Format
Creating and Modifying a Form in Layout View
Creating and Modifying a Form in Design View
Creating Datasheet Forms
Creating Multiple Items Forms
Creating Split Forms
Creating Pivot Table Forms

Lesson 10: Working with Reports
What is a Report?
Creating a Report using the Report Tool
Creating a Report using the Report Wizard
Creating and Modifying Reports in Layout View
Creating and Modifying Reports in Design View
Adding and Modifying Calculated Controls
Print Preview and Print Reports
Exporting as PDF or XPS Format
Creating Mailing Labels

Lesson 11: Advanced Table Design
Advanced Field Properties
    Using Input Masks
    Using Validation Rules
    Default Values and Required Fields
    Indexed Fields
Using Lookup Fields
    Using the Lookup Wizard
    Entering Lookup Data Manually
    Using Multivalued Fields
    Using the Calendar on Date/Time Fields
Linking Tables
    Using the Linked Table Manager

Register for the 2 Day Microsoft Access 2007 Class Today. Simply fill Call Kamini at 9066-9991 or email to  training@intellisoft.com.sg for any questions.