search3
    
    50534A: Learn Microsoft Access 2010 Step by Step, Level 3

    QUICK

    INFORMATION

    course-duration

    1 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Exam Voucher

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    Customize Your Batch

    Course Information

    The Microsoft Access 2010 training Level 3 is a one-day class that introduces students with more complex features and functions of Microsoft Access 2010.

    Completion of the course equips the participants with the following skill set:

    • Importing & Exporting information.
    • Copying to and from other Office programs.
    • Creating navigation forms.
    • Creating custom categories.
    • Controlling which features are available.
    • Assigning passwords to databases
    • Splitting databases.
    • Securing databases for distribution.
    • Preventing database problems.
    • Customizing the Quick Access Toolbar.
    • Changing default program options.
    • Customizing the ribbon.

    COURSE OUTLINE

    Module 1: Import and Export Data

    In this module, participants will learn how to populate the tables of a database by importing existing information from other sources and also utilise information that exists in an Access database in other programs.

    Lessons

    • Import Information
    • Export Information
    • Copy to and from Other Office Programs

    Lab:  Importing Information
    Lab:  Exporting Information
    Lab:  Copying to and from Other Office Programs

    Module 2: Make Databases User-Friendly

    In this module participants will learn to make databases easier to access and manipulate, and more difficult to unintentionally change or delete.

    Lessons

    • Create Navigation Forms
    • Create Custom Categories
    • Control Which Features Are Available

    Lab:  Creating Navigation Forms
    Lab:  Creating Custom Categories
    Lab:  Controlling Which Features Are Available

    Module 3: Protect Databases

    In this module participants will explore how to ensure that a database’s data is secure and that its data is available and useable.

    Lessons

    • Assign Passwords to Databases
    • Split Databases
    • Secure Databases for Distribution
    • Prevent Database Problems

    Lab:  Assigning Passwords to Databases
    Lab:  Splitting Databases
    Lab:  Securing Databases for Distribution
    Lab:  Preventing Database Problems

    Module 4: Customize Access

    In this module, participants will learn to customize the program options to suit your work needs.

    Lessons

    • Changing Default Program Options
    • Customizing the Ribbon
    • Customizing the Quick Access Toolbar

    Lab:  Changing Default Program Options
    Lab:  Customizing the Ribbon
    Lab:  Customizing the Quick Access Toolbar

    WHO SHOULD ATTEND

    This course is beneficial for information workers who want to learn advanced level Access 2010 skills.


    Pre-requisites

    Before attending this course, candidates must have:

    • Basic computer knowledge.
    • Basic file management skills.
    • Basic knowledge of the Access 2010 interface and database, table, and form creation and manipulation.

    Exam

    Name Code Fee

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.