|
Intermediate MS Access Training
Overview: This is an intermediate-level course for those who want to learn
the more advanced features MS Access.
You will learn how to develop complex databases, tables, and queries.
Also included in the course is how to link data from other programs to
Access databases.
| Benefits of
Intermediate MS Access Training |
•
Develop a deeper understanding of MS Access
• Understand how to design and create more complex databases
• Be able to build sophisticated queries
• Learn how to link data from other applications |
| Who Should Attend |
•
Beginning to intermediate web developers
• Office personnel responsible for organization's site
development or maintenance
• People wanting to build their own web site
• Individuals considering career change
|
|
What You'll Receive |
•
Intermediate MS Access Training Manual with valuable instruction,
examples, hands-on exercises, and resources
• Personal attention with hands-on database building exercises
• Recommended MS Access book to supplement training
|
|
Course Outline |
- Importing External Data
- Importing Spreadsheets
- Publishing a Database Object
- Creating a Primary Key
- Converting Field Types
- Changing Field Sizes
- Custom Display Formats
- Input Masks
- Using the Lookup Wizard
- Assigning Captions
- Setting Default values
- Using the Expression Builder
- Creating Validity Rules & Text
- Creating Queries
- Saving/Opening Queries
- Using Wildcards
- Compound Queries
- Creating calculated Controls
- Using Summary Operators
- Querying Multiple Tables
- Action Queries
- Creating Permanent Relationships
- Enforcing Referential Integrity
- Creating Custom Reports
- Saving/Opening Reports
- Creating Custom Forms
- Saving/Opening/Printing Forms
- File Management
- Database Properties
|
Contact Advantage
Internet Marketing today to schedule Intermediate MS Access Training
in Maryland. |
