Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases. Participants of this course should understand basic concepts involved in working with a personal computer (PC) and be familiar with Windows 95/98. No prior knowledge of databases or Access is assumed.

Overview of Access 2000

• Introduction to database concepts and terminology
• An introduction to Access 2000
• Database planning and design

Creating tables

• Examining a table
• Creating a table using the Table Wizard
• Creating a table using Design view
• Types of primary keys

Working with tables

• Modifying the table design
• Finding and editing records
• Filtering and sorting records

Creating and Using Select Queries

• Creating a Select Query to view specific fields
• Specifying criteria in a Query to view specific records
• Using queries to perform calculations
• Joining tables in a query

Creating and using forms

• Creating a form with Form Wizard
• Modifying the form design
• Using a form to locate and organize information
• Multiple table forms

Creating and using reports

• Creating a report using Report Wizard
• Creating a report that contains totals

Database maintenance

• Creating a database
• Managing a database and its objects
• Database Maintenance

Intermediate Access 2000

Students will learn how to enhance their database designs by using the principles of normalization and table relationships and how to query multiple tables for data that is used in customized forms and reports. They will also learn how to create data access pages to share data over an intranet or the Internet. The Access 2000 - Beginning Level course is required or equivalent knowledge.

Principles of table design

• Normalizing data
• Normalizing data for fourth and fifth normal forms

Principles of table relationships

• Analyzing table relationships
• Establishing and testing referential integrity

Table design techniques

• Data validation techniques
• Indexing techniques

Designing select queries

• Using calculated fields in queries
• Creating multiple table queries
  

Customizing form design

• Customizing the form design
• Performing calculations on a form
• Adding combo boxes to a form
• Adding unbound controls

Working with data acess pages

• Creating data access pages

Customizing reports

• Customizing a report created by the Report Wizard
• Working with Sub-reports

Using the Chart Wizard

• Creating a chart in a form or report

Advanced Access 2000

Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. They will gain experience with Internet-related features, including hyperlinks and the Web toolbar. The Access 2000 - Intermediate Level is required or equivalent knowledge.

Parameter and action queries

• Creating parameter queries
• Creating action queries

Query joins and crosstab query

• Joining tables and working with join properties
• Creating crosstab queries
• Editing limitations in query datasheets

Using advanced Form techniques

• Organizing field placement
• Using functions to control data entry
• Adding an option group to a form
• Using a form as the user interface
• Creating a form that contains a subform

Creating Basic Macros to Automate Forms

• Macros basics
• Attaching a macro to a command
• Revising a macro
• Attaching a macro to an event in a form

Using macros to provide user interaction and automate tasks

• Using macros to provide user interaction
• Using macros to automate tasks
• AutoKeys and AutoExec macros

Using advanced report techniques

• Customizing the appearance and functionality of a report
• Mailing and other types of labels

Access 2000 and the Internet

• Using hyperlinks
• Access tools for working on the Internet

Access 2000 for Developers

Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code. You will learn how to build an application by designing and creating the database objects and a graphical user interface. Participants of this course should understand table, query, form, report and macro design and function as well as data normalization and table relationships. Access 2000 - Beginning level, Intermediate level and Advanced level courses are required or equivalent knowledge.

• Planning an application
• Examining a completed application
• Developing a distributed application design

Adding Command Buttons to Guide User Navigation

• Using one form for two purposes: to add or edit records

Automating a Dialog-box Form with a Macro Group

• Creating a macro group
• Customizing an unbound form to behave like a dialog box
• Documenting a macro group

Creating a Switchboard Form

• Using the Switchboard Manager
• Setting database startup properties

Working with Custom Toolbars and Menus

• Using a macro group to show and hide a toolbar
• Creating a custom menu bar for a form
• Startup properties for toolbars and menu bars

Creating a Splash Screen Form

• Creating a form as a Splash Screen
• Automating the Splash Screen form by using Visual Basic code
• Documenting the application

Using Visual Basic Procedures

• Creating a public function
• Adding general procedures in a form module
• Creating event procedures
• Viewing a live web site on a form

Adding Security to an Application

• Security overview
• Steps to securing a database by using user-level security
• Documenting database security
• Securing a database with a database password
• Distributing the secured application