Course Info

MA2003-3 - Microsoft Access 2003 Advanced

Categories Database Training, Microsoft Access Training, Microsoft Office Training, MOUS Certification Training, Applications Training

Duration 1 day (7 hours)

Pre-requisites
MA2003-1 - Microsoft Access 2003 Introduction and MA2003-2 - Microsoft Access 2003 Intermediate, or equivalent experience.

Courseware MA20033-TL (100 pages)

Price $195

Notes

In this advanced Microsoft Access 2003 training 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.

"Perfect. The application to learn for database management! [The instructor] is wonderful!!!." -- Rosemarie W. from San Diego, CA

Querying with SQL
      SQL and Access
      Writing SQL statements
      Attaching SQL queries to controls
Advanced queries
      Creating crosstab queries
      Creating parameter queries
      Using action queries
Macros
      Creating, running, and modifying macros
      Attaching macros to the events of database objects
Advanced macros
      Creating macros to provide user interaction
      Creating macros that require user input
      Creating the AutoKeys and AutoExec macros
      Creating macros for data transfer
Importing, exporting, and linking objects
      Importing objects
      Exporting objects
      Interacting with the XML documents
      Linking Access objects
      Working with Windows SharePoint Services
Database management
      Optimizing resources
      Replicating and synchronizing databases
Security fundamentals
      Protecting databases
      Encrypting and decrypting databases
      User-level security
Microsoft Office Specialist exam objectives map
      Comprehensive exam objectives