DURATION
: 1 day
About this Course
This one-day instructor-led course provides students with an overview of the more complex features and
functions of Microsoft Office Access 2007.
Audience Profile
This course is intended for information workers who want to learn intermediate-level Access 2007 skills.
Pre-requisite
Before attending this course, students must have:
·
Basic computer knowledge.
Basic file-management skills.
Basic knowledge of the Access 2007 interface and database, table, and form creation and
manipulation.
At Course Completion
After completing this course, students will know how to control the types of data that can be entered in
a table, extract or manipulate data by using queries, and customize forms and reports to meet their
needs. They will also know how to customize and maintain an Access database and how to prepare a
database that will be used by other people. Specifically, they will be able to:
·
Restrict the type and amount of data in a field.
Specify the format of data in a field.
Restrict data by using validation rules.
Create a simple or multi-column lookup list.
Add controls to a form.
Enter data in a form by using VBA.
Create a form by using an AutoForm.
Add a subform to a form.
Locate information that matches multiple criteria.
Create a query by using a wizard or manually.
Perform calculations by using a query.
Update information in a table.
Delete information from a table.
Create a report by using a wizard or manually.
Modify report design and content.
Leader in Professional IT Training
·
Add a subreport to a report.
Preview and print a report.
Make favorite Access commands quickly available.
Create custom categories.
Assign a password to a database.
Prevent database problems.
Create a switchboard.
Control the features available to database users.
Prevent changes to database code.
Secure a database for distribution
Module 1: Data Integrity
This module discusses ways to help ensure the accuracy of data entered into a database.
Lessons
·
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List
Key Points
Lab : Data Integrity
·
Add fields and restrict data types.
Change the Field Size property.
Use input masks to format data.
Create and test validation rules.
Use the Lookup wizard to create a list.
Use the Lookup wizard to create a two-column list.
After completing this module, students will be able to:
·
Restrict the type and amount of data entered in a field.
Require that data entered in a field be in a certain format.
Use validation rules to prohibit invalid data.
Use simple and multi-column lookup lists to limit data to a set of options.
Leader in Professional IT Training
Leader in Professional IT Training
Module 2: Custom Forms
This module explains how to customize forms to facilitate data entry and display.
Lessons
·
Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
Adding a Subform to a Form
Key Points
Lab : Custom Forms
·
Add, replace, and delete controls.
Enter data in a form by using VBA.
Use the Form wizard to create a form.
Displaying a subform within a main form.
After completing this module, students will be able to:
·
Customize forms by adding controls.
Use VBA to enter data that can be calculated from other fields.
Use the Form wizard to control the creation of forms.
Use subforms to enter data in more than one table.
Module 3: Queries
This module explains how to search for records that match multiple-criteria by using advanced filtering
and queries, as well as how to perform calculations and update and delete table information.
Lessons
·
Locating Information That Matches Multiple Criteria
Creating a Query by Using a Wizard
Creating a Query Manually
Performing Calculations by Using a Query
Updating Information in a Table
Deleting Information from a Table
Key Points
Lab : Queries
·
Find information that matches two criteria while exploring the design grid.
Create a query based on two related tables.
Create a query that calculates a new field.
Summarize the values in records selected by a query.
Create a query to update table data.
Create a query to delete table data.
Leader in Professional IT Training
After completing this module, students will be able to:
·
Match records that meet multiple criteria.
Create queries to find records and create calculated fields
Summarize matched records.
Have Access update and delete records.
Leader in Professional IT Training
Programme scope, delivery arrangements and suitability are confirmed during enquiry.