Class / Schedule

PC End User

Access 2016 Level 3 (2 Days)

01-04-D729
Simplify your managerial and analytical tasks. Make your data work for you by learning advanced Access techniques. Previous classes, as well as your experienced use of Access, have given you a solid foundation in tables, queries, and reports. In Level 3, you will practice structuring existing data, writing advanced queries, and working with macros. You will also perform general database maintenance.

    Performance Objectives: Upon completion of this course you should be able to:

    • Restructure data into appropriate tables
    • Ensure data dependency
    • Minimize redundancy
    • Write advanced queries to analyze data
    • Advance form design and summary reports
    • Create and revise Access 2016 macros
    • Customize reports with advanced features
    • Use administration tools to maintain your database
    • Distributing and Securing a Database
    • Managing a Switchboard

    Competencies covered in this course: Customized Layout, Sharing Data, Macros, VBA Enhancement tasks and Data Organization

      Intended Audience: Experienced Access users. It is strongly recommended that you take a Level 1 and 2 Access course before taking Level 3.To be successful in this course, you should be familiar with using a mouse and keyboard; comfortable launching and closing programs; navigating to information stored on the computer; and managing files and folders.

        Recommended Prerequisite: To be successful in this course, you should be familiar with using a mouse and keyboard; comfortable launching and closing programs; navigating to information stored on the computer; and managing files and folders.

        Scheduled Class Location and Dates
        City Facility Date and Time Course Cost Cancel Date Instructor
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Apr 19 2017 8:00am-4:30pm
        • Apr 20 2017 8:00am-4:30pm
        $289.00 Sun, 04/02/2017 - 17:00 Darin Murphy