Microsoft Access 2003 Advanced
Microsoft Access 2003 Advanced brings you the power of Access beyond the basic features. Importing and exporting, macros, extracting statistic data from a vast material and presenting the result in various ways, including sales charts and publishing database data to the Internet, and how you handle many-to-many relations in a database structure are among the subjects covered. Complicated? Not when you've taken this course!
|
Titel: Microsoft Access 2003 Advanced
Item: A302E-W3
Teacher: Nick Atkinson
Runningtime: aprox 2h
Price: 995 sek excl. VAT
Kursinnehåll:
1. Tables, Querys & Relations
Field Properties
Types of Relationships
Referential Integrity
Junction Tables
Create an Update Query
Advanced Queries
2. Functional Forms
Form Properties
Sub Form
Toggle & Option Button
List & Combo Box
Events in Forms
Switchboard Manager
3. Macros
Functions of Macros
Create a Macro
Link a Macro
Conditions in Macros
Autostart
Convert to VBA Code
4. Visual Basic for Applications
The VBA Editor
Variables & Functions
Procedures, Functions & Modules
Conditional Statements
Message Boxes
Debugging
5. DAO & Integration
Generating E-mails with DAO
Working with Record Sets
Error Handling in VBA
Object Linking & Embedding
Analyze with Excel
Mail Merge in Word
6. News & Miscellaneous
Database Utilities
Security
Tools for Analyzing Data
Smart Labels & Auto Correction
Object Dependencies
Database Splitter
