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: Reports
This module explains how to extract information from a database as a report. It also explains how to
modify report design and content, add subreports to reports, and preview and print reports.
Lessons
·
Creating a Report by Using a Wizard
Modifying Report Design
Creating a Report Manually
Modifying Report Content
Adding a Subreport to a Report
Previewing and Printing a Report
Key Points
Lab : Reports
·
Use the Report wizard to create a report based on two tables.
Change the layout and formatting of a report.
Create a report from scratch.
Modify the content of a report.
Display calculations in a subreport of a main report.
Preview a report and review printing options.
After completing this module, students will be able to:
·
Create reports to extract information from a database.
Customize the design and content of reports.
Use subreports to enhance the display of information.
Provide neatly printed copies of reports.
Leader in Professional IT Training
Module 2: Database Management
This module explains how to make databases easier to use while protecting them from unauthorized
users and carrying out preventive maintenance.
Lessons
·
Making Favorite Access Commands Quickly Available
Creating Custom Categories
Assigning a Password to a Database
Preventing Database Problems
Key Points
Lab : Database Management
·
Add a button to the Quick Access Toolbar.
Create a custom category with groups and objects.
Protect a database with a password.
Back up a database, and run utilities to detect problems.
After completing this module, students will be able to:
·
Make commands available on the Quick Access Toolbar.
Provide users with easy access to the objects they need to work with.
Password-protect a database.
Avoid database problems by running maintenance utilities.
Module 3: Database Distribution
This module explains more ways to protect databases that will be used by multiple people on multiple
computers.
Lessons
·
Creating a Switchboard
Controlling the Features Available to Database Users
Preventing Changes to Database Code
Securing a Database for Distribution
Key Points
Lab : Database Distribution
·
Create a switchboard with one-click navigation to forms, reports, and two common actions.
Set and bypass startup options.
Assign a password to database code.
Save a database as an ACCDE file.
After completing this module, students will be able to:
·
Use a switchboard to expose only the objects users need to interact with.
Use startup options to hide or display features.
Password-protect VBA code.
Leader in Professional IT Training
·
Create a secure database file so that users can view and update data but not change base
objects.
Leader in Professional IT Training
Programme scope, delivery arrangements and suitability are confirmed during enquiry.