|
|
|
|
|
Microsoft Access - Advanced | | | | Course Number: | ALTO-1539C | | Length: | 1 Day |  | | Price: | $395.00 | | | | Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
| Start Date | End Date |
|---|
| 03/12/2010 | 03/12/2010 | | 04/30/2010 | 04/30/2010 | | 06/25/2010 | 06/25/2010 |
|
|
|
|
| | | The one-day advanced segment is an absolutely intense day intended for experienced Access developers who want to fine-tune their applications to exploit the many powerful features and functions built into Access. Access applications have numerous options for dealing with multiple users: different forms of security, concurrency and isolation can be combined to solve any conceivable design problem. Access can be extended by incorporating server-based data sources, ActiveX controls and servers into your applications. |
|
|
|
|
|
Key Concept
Overview of Access and the Jet Database Engine
- The Importance of Database Design
- Table Design
- Field Data Types
- Important Field Properties
- Maintaining Data Integrity
- Using Datasheets
Query Fundamentals
- Basic SELECT Queries
- Filtering and Sorting
- Calculated Columns
- Joining Multiple Tables
- Insert, Update and Delete Queries
Form Design
- Controls and Properties
- Single Record Forms
- Continuous Forms
- Main/Sub Forms
- Forms
Importing, Exporting and Attaching Data
- Text Files
- Spreadsheets
- FoxPro/dBase and Others
- Server-based Data
Report Design
- Using Groups and Totals
- Controlling Page Breaks and Grouping
- Calculations
- Subtotals, Grand Totals, Running Sums
Automating Tasks with Macros
- Startup Housekeeping
- Switchboards
- Multi-Step Processes
|
|
|
|
 | Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
|
|
|
|
|
|
| |
|