Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Access 2016 - Intermediate (EN)

Von Sonic Performance

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

play symbol Course Overview: Access 2016 - Intermediate (EN)
03:15
lecture locked Understanding Relational Databases
03:42
lecture locked How to Analyze the Relational Database Design Process
02:35
lecture locked Understanding Primary Keys
02:28
lecture locked Exploring Table Relationships
05:20
lecture locked How to Create a Table in Access
08:15
lecture locked How to Create a Table Relationship
03:34
Quiz zum Kurs „Designing a Relational Database (EN)“
play symbol Introduction to Joining Tables
01:25
lecture locked Working with Inner and Outer Joins
02:07
lecture locked How to Create Inner and Outer Joins
04:43
lecture locked Joining Unrelated Tables
02:32
lecture locked How to Relate Data Within a Table
03:05
lecture locked Introduction to Working with Subdatasheets
00:32
lecture locked Working with Subdatasheets
03:34
Quiz zum Kurs „Joining Tables (EN)“
play symbol Introduction to Using Data Validation
02:10
lecture locked Using Field Validation
04:09
lecture locked How to Use the Input Mask
08:05
lecture locked Forming Validation
04:27
lecture locked Recording Validation
05:03
Quiz zum Kurs „Using Data Validation (EN)“
play symbol Introduction to Creating Advanced Queries
01:50
lecture locked Creating Parameter Queries
03:35
lecture locked How to Use Wildcards in a Parameter Query
05:57
lecture locked Creating Queries with Multiple Parameters
02:09
lecture locked Creating Crosstab Queries
06:33
lecture locked Creating Action Queries
02:44
lecture locked How to Update Queries
06:18
lecture locked Appending Queries
03:28
lecture locked Deleting Queries
05:40
lecture locked How to Make Table Queries
02:13
lecture locked Introduction to Unmatched and Duplicated Queries
01:13
lecture locked How to Create Unmatched Queries
03:35
lecture locked Creating Duplicate Queries
03:11
Quiz zum Kurs „Creating Advanced Queries (EN)“
play symbol Using Data Normalization
05:29
lecture locked Working with the Table Analyzer Wizard
05:40
lecture locked Introduction to Junction Tables
00:55
lecture locked Junction Tables
03:42
lecture locked Improving Table Structures
08:15
Quiz zum Kurs „Organizing a Database for Efficiency (EN)“
play symbol Using Advanced Reporting Techniques
01:24
lecture locked Data Bars: Conditional Formatting
04:48
lecture locked Adding a Calculated Field to a Report
04:11
lecture locked Adding a Subreport to an Existing Report
07:21
lecture locked Follow-Up: Access 2016 - Intermediate (EN)
01:09
Quiz zum Kurs „Using Advanced Reporting Techniques (EN)“
Quiz zum Kurs „Access 2016 - Intermediate (EN)“

Details

  • Enthaltene Vorträge: 42
  • Laufzeit: 2:42 h
  • Enthaltene Quizfragen: 19
  • Enthaltene Lernmaterialien: 1


Dozenten des Kurses Access 2016 - Intermediate (EN)

 Sonic Performance

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.


Rezensionen

(1)
5,0 von 5 Sternen
5 Sterne
5
4 Sterne
0
3 Sterne
0
2 Sterne
0
1  Stern
0