Access Database Design 2
Training
In London
Description
-
Type
Training
-
Location
London
-
Duration
1 Day
To give users an insight into some of the more advanced features in Access. Delegates will gain further understanding of database design principles, advanced forms, reports and query design, including using calculations. Suitable for: This course is suitable for existing users of Access who want to customise forms, queries and reports.
Facilities
Location
Start date
Start date
About this course
Participants on this course should have a good working knowledge of Access, gained from prior attendance on an "Access Database Design 1" course
Reviews
Course programme
Access – Database Design
(Part 2- Intermediate/Advanced)
Course outlines
Forms
What is a Form?
Form Sections
Form Controls
Form Control Layout
Using Form Controls
Control Properties
Control Wizards
Multiple Table Forms
Advanced Form Design
Using Advanced Forms Features
The Form Worksurface
Creating a Calculated Control
Adding a Graphic to a Form
Multi-Table Forms
Using the Subform Control
Switchboard Forms
Access And The Internet
Using Hyperlinks
Using Hyperlinks in Forms
Exporting Datasheet Views to Html
Data Access Pages
Reports
Using Report Wizards as the Basis for Reports
Report Sections
Report Controls
Report Control Layout
Using Specific Controls
Publishing Datasheet Views on the Internet
Adding Hyperlinks to Datasheet Views
Adding Hyperlinks to Html Pages
Advanced Report Design
Applying Sorting and Grouping to Reports
Performing Calculations on Reports
Adding a Graphic to a Report
Using the Subreport Control
Modifying Section Properties
Using the Chart Wizard
Importing, Exporting, and Linking Data
Importing From other Data Sources
Linking Data
Exporting Data
Database Management Tools
Database Administration
Documenting the Database Structure
Backing up and Restoring a Database
Compacting and Repairing a Database
Setting a Database Password
Encrypting and Decrypting a Database
Fee £220+VAT
Additional information
Payment options: All Courses can be held privately at our premises or otherwise.
Access Database Design 2