|
Alto's Microsoft Access hands-on, lab oriented seminars teach you
what you need to know to put Access to work immediately. In a matter
of days you will be mastering its database objects, query
capabilities, ability to incorporate data from many sources and
visual programming language. You will be delivering state-of-the-art
Windows database applications in record time. Our expert instructors
will guide you through Access' s powerful features, saving you
months of confusion and frustration.
Introduction to
Microsoft Access
Alto Consulting & Training Course
(Alto Course
1539A)
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.
Key Concept
Course Outline
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
Intermediate Microsoft
Access
Alto Consulting & Training Course
(Alto Course 1539B)
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.
Key Concept
-
Go beyond the visible surface of Access and take direct
control of your tables, queries, forms and reports via
programming.
-
Produce full-featured database applications, quickly and
efficiently.
Course Outline
Basic Controls
- Common Properties, Methods, Events
- Text boxes and Labels
- Command Buttons
- Check Boxes
- Option Groups, Option and Toggle Buttons
- Tabs versus Page Breaks
Programming with Access
- Access VBA Source Code Editor
- Source Code Organization
- Appropriate Use of Source Code
Advanced Controls
- Conditional Formatting
- List Boxes and Combo Boxes
- Subforms
- Object Frames and ActiveX Controls
Advanced Query Features Grouping and
Totaling
- Cross-Tab Queries
- Parameterized Queries
- Outer Joins
- Union Queries
- Sub Queries
Data Access Objects (DAO) Opening
Databases and Workspaces
- Creating Recordsets
- Navigating Through Recordsets
- Insert, Update and Delete
- Creating and Modifying Tables
- Creating Queries in Source Code
Programming with Forms Form Events
- Working with Sub Forms
- Synchronizing Forms
- Manipulating the Form's Recordset
- Advanced Validation Techniques
Programming with Reports Report Events
- Using Reports with Cross-Tab Queries
- Manipulating Reports at Runtime
- Working with Sub-Reports
Comprehensive Appendixes Manipulating
Program Data
- Controlling Program Flow
- Strings and Dates
- Using Objects and Collections
Advanced Microsoft
Access
Alto Consulting & Training Course
(Alto Course
1539C)
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
-
Learn how to create reliable, secure, and optimized
multi-user Access applications that can be distributed for use
by customers, employees, staff members and others.
Course Outline
Error Handling Syntax and Tactics
- Trapping and Reporting Errors
- Handling Errors
- Logging Errors
Multi-User Programming Techniques
- Database, Table and Page Locking
- Concurrency versus Isolation
- Transactions
Working with Security
- Nature and Purpose of Access Security
- Users and Groups
- Objects and Permissions
Working with Database Servers (SQL
Server)
- Configuring ODBC Data Sources
- Attaching to Server Tables and Views
- Working with Pass-Through Queries
- Calling Server Stored Procedures
- Jet versus ODBC Direct
Working with ActiveX Controls and
Servers
- Using Excel Spreadsheets
- Using Word Documents
- Using Visual Basic Objects
Optimizing Access Applications
- Investigating Query Performance
- Improving Query Performance
- Forms and Reports
- Source Code
Distribution with the Office Developer
Edition
- Differences Between Access Runtime and Retail
- Designing with Distribution in Mind
- Working with the Setup Wizard
|
