Microsoft Access (Advanced)

Course Highlights

You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.


Instructor-led, group-paced, classroom-delivery learning model with structured hands- on activities.

Students will learn advanced Access skills, including how to structure existing data, summarize data, simplify tasks with macros, add interaction and automation with macros, make forms more usable, make reports more powerful, and expand the reach of data beyond Access.

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:

  • Put existing data into correctly designed tables and compact your database.
  • Use a variety of techniques to summarize data.
  • Create and revise basic Access macros.
  • Create macros that require data entry in certain fields and automate data entry in others.
  • Use advanced features to enhance forms.
  • Use advanced features to enhance reports and distribute a report to non-Access users.
  • Use Office Links to use Access data in other Office programs.

  • Course Includes

  • Lesson 1: Structuring Existing Data
  • Lesson 2: Summarizing Data
  • Lesson 3: Simplifying Tasks with Macros
  • Lesson 4: Adding Interaction and Automation with Macros
  • Lesson 5: Making Forms More Usable
  • Lesson 6: Making Reports More Powerful
  • Lesson 7: Expanding the Reach of Your Data

  • Requirements

    This course is suitable for anyone who uses Access as a tool for getting their work done. Job responsibilities might include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced capabilities, and using Access tools, as well as supporting less- advanced Access users.

    Show the next months
    © Copyright - Trigraph Professional Training