SUMMARY:   Access is a visual tool with which to design and develop database applications. This hands-on course teaches key relational database design techniques including proper table design, establishing relationships between tables, creating and using indexes and assigning primary keys. Attendees will use the Northwind sample database and learn how to manipulate data and query for information using the many tools provided by Access. These techniques will be reinforced through Hands-on exercises. This is a four day course at the end of which attendees will be able to create and maintain their own Access databases. AUDIENCE:   Anyone who has a need for or responsibility for designing and maintaining a data store. This includes managers and key personnel whose job is to maintain and provide important enterprise information. PREREQUISITES:   Familiarity with the Windows operating environment is assumed. Some basic understanding of databases would be helpful. DURATION:   4 Days COURSE CONTENT:   DAY 1 TOPICS What is an Access database How Access interacts with Windows Where is the data in a database Sorting your data using keys and indexes Creating order out of chaos How to use the help system What are the objects in the MDB file Gathering the necessary design information Modeling the data Building tables Understanding and creating table relationships Understanding the field object Data validation Assigning Primary Keys DAY 2 TOPICS Understanding data integrity How to use the Datasheet Linking to tables in external Access databases Designing Select Queries Using expressions in Queries Parameter Queries Access Forms as user interfaces Building forms using Wizards Importing spreadsheet data from Microsoft Excel DAY 3 TOPICS Using the Form designer Taking advantage of Form controls Setting properties Proper Form design Creating Reports with Autoreports The Report Design window Sorting and Grouping in Reports Understanding Macros  The Macro design window Using macros with Form Buttons Access as a Client/Server front-end Connecting to SQL Server using ODBC DAY 4 TOPICS Using List Boxes on forms How main Form/sub Forms work The different types of Action Queries Query filtering Summarization Queries A short primer on VBA Converting macros to VBA Password protecting your database DL/07