Duration: 3 days

Fee: US$ 180.00

Full Course Outline

Prerequisites: Windows 95 or equivalent knowledge

Entering and Viewing Data in Microsoft Access

v        Viewing, entering and customizing data

· Entering and viewing data using forms

· Speeding up data entry using editing tools

· Manipulating Datasheet Views

v        Increasing efficiency using sub forms

· Validating your data

·  Maintaining your database by entering data in forms

v        Viewing only the information you need

· Putting records in order using the sort button

· Creating mailing labels

· Creating more complex filters

Expanding and Creating Databases

v        Controlling database growth

· Controlling data through field properties

· Creating links using multiple-field primary keys

· Controlling and filtering fields

v        Getting and working with external data

· Getting connected through an external table

· Importing a table

· Adding hyperlinks to your database

· Hyper linking to an Office document

Turning Data into Meaningful Information

v        Getting answers to questions about your data

· Bringing data together using a query

· Refining queries

v        Analyzing your data

· Providing meaningful names for datasheet columns

· Summarizing and calculating using a cross tab query

· Setting a parameter to limit a cross tab

v        Merging data from two tables onto one form

· Adding a calculated control to a form

Refining Your Database

v        Streamlining data entry

· Adding toggle buttons to assist the user

· Creating a Macro

v        Customizing a report

· Summarizing data by creating a detail report

· Summaries data by grouping records

· Creating a custom Auto Report

v        Sharing summarized and grouped data

· Summarizing data by creating a grouped report

· Keeping related groups on the same page

· Preparing reports for publication on the Internet or an Intranet