Questions? Feedback? powered by Olark live chat software

Access (2016/2013/2010) Combo Training Courses

About the Access (2016/2013/2010) Combo

Duration: 3 days (24 hours)

This course is suited for those using Microsoft Access (2016/2013/2010). This course will be taught using Microsoft Access. Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Your training and experience using Microsoft Access (2016/2013/2010) has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users

Objectives
Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options
Organize and manage data stored within Access table
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

Next Class Dates

Dec 11, 2017 – Dec 13, 2017
 
9:00am – 5:00pm EST
 
Guaranteed to run class (GTR)
 
Jan 22, 2018 – Jan 24, 2018
 
9:00am – 5:00pm EST
 
 
Feb 19, 2018 – Feb 21, 2018
 
9:00am – 5:00pm EST
 
 

Back to Top

This training consists of the following courses:

Access Level 1 (2016/2013/2010)   More on this course

1 day | 8 hours

arrow Course Objectives

  • » 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

Back to Top

arrow Course Outline

  • Getting Started with Access
    1. Orientation to Microsoft Access
    2. Create a Simple Access Database
    3. Get Help and Configure Options in Microsoft Access
  • Working with Table Data
    1. Modify Table Data
    2. Sort and Filter Records
  • Querying a Database
    1. Create Basic Queries
    2. Sort and Filter Data in a Query
    3. Perform Calculations in a Query
  • Using Forms
    1. Create Basic Access Forms
    2. Work with Data on Access Forms
  • Generating Reports
    1. Create a Report
    2. Add Controls to a Report
    3. Enhance the Appearance of a Report
    4. Prepare a Report for Print
    5. Organize Report Information
    6. Format Reports
  • Appendix A: Microsoft Office Access 2016 Exam 77-730

Back to Top

Access Level 2 (2016/2013/2010)   More on this course

1 day | 8 hours

arrow Course Objectives

  • » 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

Back to Top

arrow Course Outline

  • Designing a Relational Database
    1. Relational Database Design
    2. Create a Table
    3. Create Table Relationships
  • Joining Tables
    1. Create Query Joins
    2. Relate Data Within a Table
    3. Work with Subdatasheets
  • Using Data Validation
    1. Use Field Validation
    2. Use Form and Record Validation
  • Creating Advanced Queries
    1. Create Parameter Queries
    2. Summarize Data
    3. Create Subqueries
    4. Create Action Queries
    5. Create Unmatched and Duplicate Queries
  • Organizing a Database for Efficiency
    1. Data Normalization
    2. Create a Junction Table
    3. Improve Table Structure
  • Using Advanced Reporting Techniques
    1. Include Control Formatting in a Report
    2. Add a Calculated Field to a Report
    3. Add a Subreport to an Existing Report
  • Appendix A: Microsoft Office Access 2016 Exam 77-730

Back to Top

Access Level 3 (2016/2013/2010)   More on this course

1 day | 8 hours

arrow Course Objectives

  • » 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 startup options

Back to Top

arrow Course Outline

  • Implementing Advanced Form Design
    1. Add Controls to Forms
    2. Enhance Navigation and Organization of Forms
    3. Apply Conditional Formatting
  • Sharing Data Across Applications
    1. Import Data into Access
    2. Export Access Data
    3. Link Tables to External Data Sources
    4. Create a Mail Merge
  • Using Macros to Improve User Interface Design
    1. Create a Macro
    2. Restrict Records Using a Condition
    3. Validate Data Using a Macro
    4. Automate Data Entry Using a Macro
  • Using VBA
    1. Getting Started with VBA
    2. Enhance Access Using VBA
  • Using Advanced Database Management
    1. Manage a Database
    2. Determine Object Dependency
    3. Document a Database
  • Distributing and Securing a Database
    1. Splitting a Database for Multiple User Access
    2. Implement Security
    3. Convert an Access Database to an ACCDE File
    4. Package a Database with a Digital Signature
  • Managing Switchboards
    1. Create a Database Switchboard
    2. Modify a Database Switchboard
    3. Set Startup Options

Back to Top

This training prepares students for the following exam(s):

  • » 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills
  • » 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills
  • » 77-730: Access 2016: Core Database Management, Manipulation, and Query Skills

Back to Top

Recent Client Testimonials & Reviews

First time I have taken a virtual learning class and was very impressed with the customer support prior to and during the class as well as the professionalism and expertise of our teacher.

- Melissa T.

Course(s) Taken

» Access (2016/2013/2010) Combo

Great presenter! Awesome attitude.

- Kyra G.

Course(s) Taken

» Access (2016/2013/2010) Combo

The instructor was AWESOME, really kept the attention all the way through the class. Great class. Very impressed.

- Joshua L.

Course(s) Taken

» Access 2013 Combo

  More testimonials »  

Back to Top