| DURATION PRE-REQUISITES
COURSE OBJECTIVE
COURSE CONTENT
|
One day
Keyboard familiarity. Must have a basic working knowledge of Microsoft
Windows 2000 or XP and attended Access for Windows XP Introductory course
or have a proficient working knowledge at that level.
At the end of this course delegates will be able to use and apply intermediate
features of Access for Windows XP.
Relational Database Design
- Deciding your tables
- The importance of Normalization
- Fields and relationships and Database Diagrams
- Relationship Types and Options
More Table Features.
- Setting Field properties and using lookups
- Multiple indexes
- Importing or Exporting Tables
- Attaching Tables
Select Query Design
- Select Queries
- Calculated fields
- Adding Parameters to select Queries
Other Queries
- Update Queries
- Append Queries
- Delete Queries
- Making a table with a Query
Form Design
- Customizing a Form
- Setting Form Properties
- Forms and Subforms
- Formatting and Graphics
- The use of Form Controls
- Different types of controls
- Setting Control Properties
- Using Expressions in forms
- Calculations
Report Design
- Setting Report properties
- Setting Field and Label properties
- Using the Report Toolbox
Reports Layouts
- Sorting and Grouping Data
- Using Group Heaters and Footers
- Using Expressions in Reports
Macro Basics
- What is a Macro & Why use Macros?
- Creating a Macro
- Adding Actions to a Macro
- Running a Macro
- Saving a Macro
- Using Macros with Forms
Database Multiuser Considerations
- Sharing and Editing Data in a Multiuser Environment
- Multiuser options
|
|
