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 2003 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
|
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 & 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 |
|
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
|
