| |
|
Cloud Accelerate
Partner
|
|
|
|
|
|
Microsoft Access Series
| | | | Course Number: | ALTO-1539 | | Length: | 5 Day |  | | Price: | $1,985.00 | | | |
Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
| Start Date | End Date | Location |
|---|
| 03/19/2012 | 03/23/2012 | |
|
|
|
|
| | | This five day course combines the introductory, intermediate and advanced courses.The two-day introductory segment is a comprehensive yet selective exploration of the key features and functions of the powerful Access products. You will learn the crucial configuration steps and design techniques that make it possible to create robust, full-featured database applications without any programming. The major components in Access have dozens and sometimes even hundreds of options for the way they can be used. This course does not attempt to cover everything, rather, it concentrates on the features and functions that will make the most effective use of your time and efforts.The two-day intermediate segment is intended for those already familiar with basic Access operations and are ready to make the transition from Access user to application developer. You will learn how to directly control and manipulate Access from behind the scenes to create queries, data entry forms and reports that function precisely in the manner you require. Access is far more powerful and flexible than it might initially appear, making Access suitable for every kind of database application.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) |
|
|
|
|
|
|
|
|
|
|
|
| |
|