|
Microsoft Office: Beginning Access
General Information
-
Course Duration: 3 hours
Audience: Users wanting to become familiar with Access; users
wanting to become certified as Expert Users of Access
Prerequisites: A basic
familiarity with Windows 98,2000 or XP user environments
|
Topics Covered
- Introducing databases
- Starting Access
- Using databases
- Creating databases
- Hands-on: Creating a database
- Help
- Creating tables
- Hands-on: Creating a table
- Defining relationships
- Hands-on: Defining a relationship
- Entering and changing data
- Hands-on: Inserting a column
- Sorting and searching for records
- Hands-on: Sorting records
- Working with filters
- Hands-on: Filtering records
|
Course Aim
To provide
an introduction to using Access |
Learning Objectives
After taking this course, the user should be able
to
- use and create databases in Access
- create and design tables
- enter data and manage databases
|
Microsoft Office: Intermediate Access
General Information
- Course Duration:
4 hours
Audience: Users wanting to become familiar with Access; users
wanting to become certified as Expert Users of Access
Prerequisites:
Familiarity with databases and Access
|
Topics Covered
- Working with forms
- Creating forms
- Hands-on: Creating a form using Autoform
- Subforms
- Hands-on: Creating a subform
- Building a custom form
- Getting more from controls
- Hands-on: Creating an option group
- Formatting forms
- Creating charts
- Using reports
- Customizing reports
- Hands-on: Creating an autoformat
- Sub-reports
- Printing
- Hands-on: Printing a report
|
Course Aim
To provide an introduction to using, creating, and
printing forms and reports in Access |
Learning Objectives
After taking this course, the user should be able
to
- use and create forms
- use and create reports
- customize forms and reports
- print forms and reports
|
Microsoft Office: Advanced Access
General Information
- Course Duration:
4 hours
Audience:
Users wanting to become familiar with Access; users wanting to become
certified as Expert Users of Access
Prerequisites:
A good understanding of Access
|
Topics Covered
- Introduction to queries
- Select queries
- Hands-on: Creating a select query
- Customizing queries
- Hands-on: Customizing a query
- Total and summary queries
- Crosstab queries
- Hands-on: Using crosstab queries
- Using action queries
- Hands-on: Creating and running an update query
- Creating macros
- Hands-on: Creating a macro
- Ways to run macros
- Hands-on: Modifying a macro group
|
Course Aim
To demonstrate how to use macros, share and secure databases, link and
import data, and access the Internet in Access |
Learning Objectives
After taking this course, the user should be able to
- create and run queries in Access
- customise queries
- use action and crosstab queries
- create and run macros
|
|