|
Microsoft Certified Application Specialist (MCAS)
1 Day Course
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
-
Make select queries more versatile and useful by using parameters; use action queries to update data values and add or delete records.
-
Generate different query types by creating various types of joins between tables; use crosstab queries to summarize data.
-
Use advanced form features including properties, functions, and design tools to facilitate data entry and improve accuracy in forms; display table information that has a one-to-many relationship by creating forms that contain subforms.
-
Automate tasks by creating macros to open forms and control form properties.
-
Make forms more functional by using macros to provide user interaction and automate data entry.
-
Make reports more concise and easier to understand by using properties and functions in report controls; create mailing labels.
-
Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.
Prerequisites
The Level III course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. To ensure the successful completion of this course, the following Element K courses or equivalent knowledge are recommended for familiarity with: basic and intermediate features of Access tables, relationships, queries, forms, and reports, as well as Level I and Level II.
Course content
Lesson 1: Parameter and action queries
-
Creating parameter queries
-
Creating action queries
Lesson 2: Query joins and crosstab queries
-
Joining tables and working with join properties
-
Creating crosstab queries
-
Editing limitations in query datasheets
Lesson 3: Using advanced form techniques
-
Organizing field placement
-
Using functions to control data entry
-
Adding an option group to a form
-
Using a form as the user interface
-
Creating a form that contains a subform
Lesson 4: Creating basic macros to automate forms
-
Macro basics
-
Attaching a macro to a command button
-
Revising a macro
-
Attaching a macro to an event in a form
Lesson 5: Using macros to provide user interaction and automate tasks
-
Using a macro to provide user interaction
-
Using macros to automate data entry
-
AutoKeys and AutoExec macros
Lesson 6: Using advanced report techniques
-
Customizing the appearance and functionality of a report
-
Mailing and other types of labels
Lesson 7: Access 2000 and the Internet
-
Using hyperlinks
-
Access tools for working on the Internet
Appendix A: Replicating databases
Appendix B: Using Access with other applications
-
Linking and importing data
-
Using the OfficeLinks tool
For more information on Acumen Classes
Please contact Joann Etling 314.333.3330
or
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63144
|
