Course
Length: One Day
Fees: Training at Client Offices:
One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT
Overview: Access 2002 (XP) is a relational database
application. A relational database contains a large amount of
data that is split into numerous tables; each table should
include only the information pertinent to one subject, such as
Customer, Orders, or Items. As a result, each table is smaller;
more manageable; and, in turn, more efficient. These tables can
then be joined together to make them related. When tables are
related, you can access information from any field in any
related table, eliminating the need to add the same information
to more than one table. In addition, you can create reports,
forms, and queries from data stored in any related table.
The Advanced Course including
tasks such as advanced report design; sub-forms; creating
switchboards; developing a data access page & pivot tables;
database security; creating and using macros; exporting data to
MS Office and more.
Using Advanced Report
Design
 |
Using Reports in Design
View |
|
Creating a Calculated
Control |
|
Grouping Data in a Report |
|
Creating a Header for Each
Group |
|
Creating a Running Summary |
|
Inserting a Date/Time
Control |
|
Inserting a Page Break |
|
Changing the Report
Margins |
|
Using the Label Wizard |
Using Subforms/Subreports
|
Working with Subforms/Subreports |
|
Creating a Subform/Subreport |
|
Editing the Layout of a
Subform |
|
Displaying a Subform in
Datasheet View |
|
Adding a Subform
Header/Footer |
|
Displaying a Subform Total |
Using Other Form
Techniques
|
Viewing the Properties of
an Object |
|
Changing a Control
Property |
|
Adding a Logic Control &
Command Button |
|
Saving a Form as a Report |
|
Creating a Form Letter |
Creating a Switchboard
and Setting the Startup Options
|
Create a Database
Switchboard |
|
Modify a Database
Switchboard |
|
Set the Startup Options |
|
Modify the Startup Options |
Developing a Data Access
Page and Including a PivotTable and PivotChart
|
Create a Data Access Page
in Design View |
|
Incorporate a ComboBox
Control in the Data Access Page |
|
View Data Access Pages
with the Browser |
|
Add Records to a Database
Using the Data Access Page |
|
Plan a PivotTable |
|
Develop a PivotTable with
the Office PivotTable Tool |
|
Develop a PivotChart from
a PivotTable |
Distributing and Securing
the Database
|
Split a Database |
|
Implement Security |
|
Set Passwords |
|
Encrypt and Decrypt a
Database |
Integrating Access into
Your Business
|
Link Tables to External
Data Sources |
|
Replicate an Access
Database |
Creating & Using Macros
|
Opening the Macro Design
Window |
|
Creating & Saving a Macro |
|
Assigning an Argument to
an Action |
|
Using Single Step Mode for
Testing |
|
Running & Editing a Macro |
|
Creating a Macro using the
Macro Builder |
|
Macros Properties |
|
Assigning a Macro to a
Control |
|
Creating a Command Button |
|
Adding a Condition to a
Macro |
|
Creating an Autoexec Macro |
Exporting Data to Excel
and Word
|
Exporting Data to an Excel
Workbook |
|
Dragging and Dropping Data
into Excel |
If you have other questions, please contact us at
enquiry@it-uk.com or
complete
our response form
|
