MA3 - Microsoft Access 2000 Advanced
In this advanced Microsoft Access 2000 course, students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar. 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 and use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.
"Very good. This course is definitely good. A lot of new and useful information.." -- Rebekah M. from San Diego, CA
"This is a fun course. If you are an intermediate user, this class teaches lots of new tricks. The speaker...did an excellent job simplifying complicated applications.." -- Shelley S. from San Diego, Ca
"Excellent. This class was very informative. I am very satisfied with the presentation and the amount of information covered in such a short time.." -- Anna L. from San Diego, CA
"[The instructor was) very good. Obviously knowledgeable. I liked the fact that this is a working professional.." -- Douglas T. from San Diego, CA
Advanced table design techniques
Validating field entries, creating a lookup field
Additional table definition topics
Advanced form techniques
Creating a master-detail form, adding a picture to a form
Displaying the current date on a form, modifying form properties
Representing data in a chart
Creating a chart, modifying a chart
Advanced query techniques
Including multiple conditions in a query, creating a parameter query
Creating a query to generate summary information
Creating an action query, changing the join type in a query
Modifying query properties
Optimizing query performance with indexes
Advanced report techniques
Creating a master-detail report, completing the report
Modifying report properties, adding a picture to a report
Working with data access pages
What is a data Access page ? creating a data Access page
Adding a grouping level to a data Access page
Adding a hyperlink to a data Access page
Transferring data between Access and other applications
Exporting an Access datasheet to Microsoft Excel
Linking or embedding external data in an Access form or report
Working with macros
What is a macro ? creating a database macro
Running a database macro
Creating and running a command button macro
Using tools menu options
Using the table analyzer wizard and the performance analyzer
Using the database splitter wizard and the linked table manager
Setting database startup options, setting a database password
Additional tools menu options
Additional advanced Access features
Creating a many-to-many relationship between tables
Creating a one-to-one relationship between tables
Creating a switchboard
Final case study
Conclusion