Access 2002 Is Access the Right Tool for My Project?

Objective:
This course provides a general overview of what Access can do. The intention is to help students determine whether Access is the right tool for their needs. Students gain an introduction to the basics of Access, including the seven components of an Access database.

Prerequisite Skills:
Comfortable with the Windows environment.

Course Description:
If you're in charge of managing a process that has you scrambling to find and update information from a variety of places, Access could make your job easier. In Access, you can create a database to collect a wide range of information related to a particular subject or purpose, such as planning an event, managing expenses, or tracking inventory. You can then manage all of the information from a single file so that you have to update it in only one place.

This course provides a general overview of how you can use Access to organize, analyze, and present your data.

Attend this course if you want to:

• Become familiar with the Access screen.
• Understand database terminology.
• Open existing databases.
• Create a new database.
• View data in tables or forms.
• Create a new table to store data.
• Add, edit, and save records in a table.
• Use a query to find specific data.
• Create reports to present your data a particular way.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Getting Started with Databases and Tables

Objective:
Learn to create an Access database and design and modify the table component.

Prerequisite Skills:
Comfortable with the Windows environment.

Course Description:
Do you need to learn how to plan a database, determine what information to include in the database, and decide how that information should be organized? Do you know what you need to include in your database but aren't sure how to create it?

Attend this course if you want to:

• Plan a database.
• Create a new database.
• Create a new table to store your data.
• Add records to a table.
• Modify, save, and delete records in a table.
• Open existing tables.
• Modify and save tables.
• Use wizards to create a database or table.
• Use the switchboard to move to different components of a database.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Making the Most of Tables

Objective:
Learn to create more advanced tables and apply various functions such as searching, customizing data properties, defining relationships, enforcing referential integrity, working with subdatasheets, importing, and linking.

Prerequisite Skills:
Comfortable creating Access databases and simple tables.
(Suggested Course: Access 2002 Getting Started with Databases and Tables)

Course Description:
Do you want to manipulate and customize your tables to make them more effective? Do you want to learn to use more advanced functions such as searching, customizing data properties, defining relationships, importing, and linking?

Attend this course if you want to:

• Create hyperlink and lookup fields.
• Define data type properties.
• Create, define, and modify table relationships.
• Enforce referential integrity to ensure records in related tables are updated properly.
• Work with subdatasheets to view related information in a nested table.
• Import data into a table.
• Link a table to another file.
• Search for records in a table.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Creating Forms

Objective:
Learn to create and modify forms using AutoForm, the Form Wizard, and Design View.

Prerequisite Skills:
Comfortable creating and working with Access databases and tables.
(Suggested Courses: Access 2002 Getting Started with Databases and Tables and Access 2002 Making the Most of Tables)

Course Description:
Do you want to make a data entry in Access easier? Do you want to learn about the different types of forms you can create and the different methods for creating them?

Attend this course if you want to:

• Understand forms and form types.
• Understand the controls you can use to enter data or view information in a form.
• Navigate through existing forms in Form view, Datasheet view, and Design view.
• Sort and filter data.
• Add, modify, delete, and save records.
• Create a form using AutoForm or the Form Wizard.
• Create a form using the Design view.
• Define the form display size to match the size of your monitor.
• Add fields to a form.
• Modify forms.
• Work with control properties and form properties.
• Delete a form.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Queries I: Creating Select Queries

Objective:
Learn to sort and filter records, create simple queries, modify queries, create multiple-table queries, and apply simple calculations to queries.

Prerequisite Skills:
Comfortable creating and working with Access databases and tables.
(Suggested Courses: Access 2002 Getting Started with Databases and Tables and Access 2002 Making the Most of Tables)

Course Description:
Have you created a database, but now want to view, change, or analyze only certain data within it? Do you want to sort or filter your data to work with it more effectively? Do you want to select specific data for inclusion in a form or report?

Attend this course if you want to:

• Learn about different types of queries.
• Sort and filter records in a table.
• Save a filter as a query.
• Use a wizard to create a simple query.
• Create a query using the Design view.
• Print a query.
• Modify and save a query.
• Set properties for a query.
• Build multiple table queries.
• Define criteria in a query.
• Apply simple calculations to a query.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Working with Reports

Objective:
Learn the basics of viewing and generating reports using the Report Wizard. Also learn to modify, enhance, sort, and group report data.

Prerequisite Skills:
Comfortable creating and working with Access databases and tables.
(Suggested Courses: Access 2002 Getting Started with Databases and Tables and Access 2002 Making the Most of Tables)

Course Description:
Do you want to summarize data from your database in a report you can print? Do you want to learn some of the different ways to view and generate Access reports and to modify, enhance, and sort the data you capture in a report?

Attend this course if you want to:

• Understand the difference between forms and reports.
• View existing reports using the different views.
• Create reports using AutoReport or the Report Wizard.
• Save a report you created.
• Format a report with AutoFormat.
• Work with a report in Design view.
• Add custom fields, calculations, and graphics to a report.
• Print a report.
• Create mailing labels.
• Save a report as a Word document or Excel file.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Enhancing Forms

Objective:
Learn to customize forms by adding basic and advanced controls, enhancing form controls, creating multi-page forms or adding tabs to a form, adding pictures, and working with subforms.

Prerequisite Skills:

• Comfortable creating and working with Access databases and tables.
  (Suggested Courses: Access 2002 Getting Started with Databases and Tables and Access 2002 Making the Most of Tables)

• Comfortable with simple Access queries.
  (Suggested Course: Access 2002 Queries I)

• Comfortable creating basic forms in Access.
  (Suggested Course: Access 2002 Creating Forms)

Course Description:
Do you want to make your forms more visually appealing and user friendly? Do you want to learn to use more advanced form controls and to add tabs, pictures, and multiple pages to a form?

Attend this course if you want to:

• Understand and use the controls from the Toolbox.
• Insert basic controls.
• Apply formatting options such as colors, borders, and backgrounds to form controls.
• Add an image to a form.
• Create a multi-page form.
• Add tabs to a multi-page form.
• Create a pivot table.
• Add advanced and data validation controls.
• Create a header or footer for a form.
• Add your company logo or other graphics to the background of the form.
• Modify field properties.
• Work with subforms.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Queries II: Creating Total, Crosstab, Parameter, and Action Queries

Objective:
Learn to create more advanced queries by defining calculations, creating total queries, defining crosstab queries, creating parameter queries, and creating different action queries.

Prerequisite Skills:

• Comfortable creating and working with Access databases and tables.
  (Suggested Courses: Access 2002 Getting Started with Databases and Tables and Access 2002 Making the Most of Tables)

• Comfortable creating simple Access queries.
  (Suggested Course: Access 2002 Queries I)

Course Description:
Do you want to learn more advanced methods for filtering your data? Do you want to learn how Total, Crosstab, Parameter, and Action queries can help you view, select, and analyze your data at a higher level?

Attend this course if you want to:

• Understand advanced queries.
• Build calculations in a query.
• Use Total queries to apply calculations to selected data.
• Create a Crosstab query to summarize data in a compact format.
• Create a Parameter query to prompt users to enter criteria for selecting records.
• Create an Action query to change selected data within a table.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)

Access 2002 Designing Advanced Reports

Objective:
Learn to create a report from the Design view, use subreports, create calculations, and define multi-column reports. Also learn to create reports using charts and crosstab reports.

Prerequisite Skills:

• Comfortable creating and working with Access databases and tables.
  (Suggested Courses: Access 2002 Getting Started with Databases and Tables and Access 2002 Making the Most of Tables)

• Comfortable with simple Access queries.
  (Suggested Course: Access 2002 Queries I)

• Comfortable creating basic reports in Access.
  (Suggested Course: Access 2002 Working with Reports)

Course Description:
Do you want to create a more customized report to meet more specific needs? Do you want to use subreports, create calculations in a report, or group and sort the information in a report?

Attend this course if you want to:

• Learn to create reports using the Design view.
• Use the grid to place, move, align, and resize controls with precision.
• Sort or group the information in a report to control how it displays.
• Create subreports and subforms (reports within a report).
• Use expressions to display a date, page number, or calculation in a report.
• Add a chart to a report.
• Create a crosstab report.
• Print a report on a pre-printed form.
• Print multiple report columns on a page.
• Export reports to another application or create report snapshots so that users without Access can view your report.
• Hide any duplicate values in a report.
• Number the records in a report.

Class Length: 90 minutes

Delivery Options:

• On-site instructor-led (contact us for details)

• Virtual classroom - public (attend Access 2003 class) - Check schedule and/or register

• Virtual classroom - dedicated (up to ten people from the same organization) - contact us for details

• Virtual classroom - one on one (register for a 1-on-1 Application Support session)