Access 2016: Intermediate – Online Office Course

Access 2016: Intermediate (EN)

Your training and experience using Microsoft Access 2016 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 will result in a robust, functional database for your users.

A big problem in database entries are duplicates and incorrectly entered values. In this advanced course you will learn how to use tools like "Data Validation" and "Form Design" to manage your data entries professionally. Without a consistent set of data your queries and reports will result in wrong conclusions, which might lead to wrong business decisions.

Course Prerequisites:

To ensure your success, it is recommended you have completed Microsoft Office Access 2016: Part 1 or possess equivalent knowledge. It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

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.

Inhalte

Designing a Relational Database (EN)

Course Overview: Access 2016 - Intermediate (EN)	03:15
Understanding Relational Databases	03:42
How to Analyze the Relational Database Design Process	02:35
Understanding Primary Keys	02:28
Exploring Table Relationships	05:20
How to Create a Table in Access	08:15
How to Create a Table Relationship	03:34
Quiz zum Kurs „Designing a Relational Database (EN)“

Joining Tables (EN)

Introduction to Joining Tables	01:25
Working with Inner and Outer Joins	02:07
How to Create Inner and Outer Joins	04:43
Joining Unrelated Tables	02:32
How to Relate Data Within a Table	03:05
Introduction to Working with Subdatasheets	00:32
Working with Subdatasheets	03:34
Quiz zum Kurs „Joining Tables (EN)“

Using Data Validation (EN)

Introduction to Using Data Validation	02:10
Using Field Validation	04:09
How to Use the Input Mask	08:05
Forming Validation	04:27
Recording Validation	05:03
Quiz zum Kurs „Using Data Validation (EN)“

Creating Advanced Queries (EN)

Introduction to Creating Advanced Queries	01:50
Creating Parameter Queries	03:35
How to Use Wildcards in a Parameter Query	05:57
Creating Queries with Multiple Parameters	02:09
Creating Crosstab Queries	06:33
Creating Action Queries	02:44
How to Update Queries	06:18
Appending Queries	03:28
Deleting Queries	05:40
How to Make Table Queries	02:13
Introduction to Unmatched and Duplicated Queries	01:13
How to Create Unmatched Queries	03:35
Creating Duplicate Queries	03:11
Quiz zum Kurs „Creating Advanced Queries (EN)“

Organizing a Database for Efficiency (EN)

Using Data Normalization	05:29
Working with the Table Analyzer Wizard	05:40
Introduction to Junction Tables	00:55
Junction Tables	03:42
Improving Table Structures	08:15
Quiz zum Kurs „Organizing a Database for Efficiency (EN)“

Using Advanced Reporting Techniques (EN)

Using Advanced Reporting Techniques	01:24
Data Bars: Conditional Formatting	04:48
Adding a Calculated Field to a Report	04:11
Adding a Subreport to an Existing Report	07:21
Follow-Up: Access 2016 - Intermediate (EN)	01:09
Quiz zum Kurs „Using Advanced Reporting Techniques (EN)“

Quiz zum Kurs „Access 2016: Intermediate (EN)“

Dozenten des Kurses Access 2016: Intermediate (EN)

Sonic Performance

Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.

All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.

5 Sterne		5
4 Sterne		0
3 Sterne		0
2 Sterne		0
1 Stern		0

5 Sterne		5
4 Sterne		0
3 Sterne		0
2 Sterne		0
1 Stern		0