Mastering Access 2016 - Intermediate
5.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5 students enrolled

Mastering Access 2016 - Intermediate

Create Custom Database Apps With This Modern Data-Crunching Powerhouse!
5.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5 students enrolled
Created by Chip Reaves
Published 9/2018
English
English [Auto]
Current price: $23.99 Original price: $34.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • A copy of Microsoft Access is Recommended.
Description

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules

Microsoft Access lets ordinary users develop powerful apps customized for their business needs. 

In this course experienced Microsoft Access trainer Kathy Jones will walk you through building your first Microsoft Access database, including creating tables, using queries, and implementing forms and reports. 

Who this course is for:
  • Users who want to get more out of their Microsoft Access experience.
Course content
Expand 20 lectures 02:43:59
+ Introduction
20 lectures 02:43:59
Creating a Table
09:16
Creating Table Relationships
07:55
Creating Query Joins
09:58
Relating Data within a Table
05:21
Working with Subdata Sheets
03:36
Using Field Validation, Part 1
07:37
Using Field Validation, Part 2
10:30
Using Forms and Record Validation
05:11
Creating Parameter Queries
14:25
Summarizing Data
03:59
Creating Subqueries
07:31
Creating Action Queries
11:09
Creating Unmatched and Duplicate Queries
05:35
Data Normalization
08:18
Creating a Junction Table
04:33
Creating a Table Structure
08:13
Including Control Formatting in a Report
04:34
Adding Calculated Fields to a Report
07:05
Adding a Sub-Report to an Existing Report
13:27