Microsoft Access: Level 2 training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Microsoft Access: Level 2  

 Email information about this seminar Microsoft Access: Level 2 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Microsoft Access: Level 2 by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for students who wish to gain the understanding of Microsoft Office Access 2010, 2013 or 2016

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

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. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

microsoft+access+database+2010+2013+2016 training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Microsoft Access: Level 2 seminar

 

 

Training Course Syllabus:


Access Level 2 (2016/2013/2010) Course Description

Duration: 1.00 days (8 hours)

This course is suited for those using Microsoft Access Level 2 (2016/2013/2010). This course will be taught using Microsoft Access.  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 (2016/2013/2010) will result in a robust, functional database for your users.
 

Intended Audience for this Access Level 2 (2016/2013/2010) Course

This course is intended for students who wish to gain the understanding of Microsoft Office Access 2010, 2013 or 2016.

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

Access Level 2 (2016/2013/2010) 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
 

Access Level 2 (2016/2013/2010) Course Outline:

1.Designing a Relational Database

a. Relational Database Design
b. Create a Table
c. Create Table Relationships

2.Joining Tables

a. Create Query Joins
b. Relate Data Within a Table
c. Work with Subdatasheets

3.Using Data Validation

a. Use Field Validation
b. Use Form and Record Validation

4.Creating Advanced Queries

a. Create Parameter Queries
b. Summarize Data
c. Create Subqueries
d. Create Action Queries
e. Create Unmatched and Duplicate Queries

5.Organizing a Database for Efficiency

a. Data Normalization
b. Create a Junction Table
c. Improve Table Structure

6.Using Advanced Reporting Techniques

a. Include Control Formatting in a Report
b. Add a Calculated Field to a Report
c. Add a Subreport to an Existing Report

7.Appendix A: Microsoft Office Access 2016 Exam 77-730

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

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

Seminar Summary:

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. (see full course description)

print this agenda print agenda for the Microsoft Access: Level 2 training seminar

 view dates and locations for this seminar

 

 

 

Custom Search