Microsoft Office Access 2016

Course Length : 1 Day

Course Objectives: In this course, you will create and manage an Access 2016 database.

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Course Content

Lesson 1: Getting Started with Access (3 Topics)

Lesson 2: Working with Table Data (2 Topics)

Lesson 3:Querying a Database (3 Topics)

Lesson 4:Using Forms (2 Topics)

Lesson 5:Generating Reports (6 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will create and manage an Access 2016 database.

    • Design a relational database.
    • Join tables to retrieve data from unrelated tables.
    • Validate data entered into a database.
    • Use advanced queries to manipulate your data.
    • Organize a database for efficiency and performance, and to maintain data integrity.
    • Customize reports to organize the displayed information and produce specific print layouts.

Course Content :

Lesson 1: Designing a Relational Database (3 Topics)

Lesson 2: Joining Tables (3 Topics)

Lesson 3: Using Data Validation (2 Topics)

Lesson 4: Creating Advanced Queries (5 Topics)

Lesson 5: Organizing a Database for Efficiency (3 Topics)

Lesson 6: Using Advanced Reporting Techniques (3 Topics)

    Course Length : 1 Day

    Course Objectives : In this course, you will learn to create and manage a fundamental Access 2016 database.

      • Customize a form layout to improve usability and efficiency of data entry.
      • Share data across applications.
      • Use macros to improve user interface design.
      • Use VBA to enhance tasks.
      • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
      • Lock down and prepare a database for distribution to multiple users.
      • Create and modify a database switchboard and set the start-up options.

    Course Content :

    Lesson 1: Implementing Advanced Form Design (3 Topics)

    Lesson 2: Sharing Data Across Applications (4 Topics)

    Lesson 3: Using Macros to Improve User Interface Design (4 Topics)

    Lesson 4: Using VBA (2 Topics)

    Lesson 5: Using Advanced Database Management (3 Topics)

    Lesson 6: Distributing and Securing a Database (4 Topics)

    Lesson 7: Managing Switchboards (3 Topics)