Access 2016 Intermediate
4.3 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
76 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access 2016 Intermediate to your Wishlist.

Add to Wishlist

Access 2016 Intermediate

Take your Access skills to the next level by learning advanced query, form, report and macro techniques.
4.3 (13 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
76 students enrolled
Last updated 10/2016
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Design Tables for Better Data Entry
  • Share Data with Other Applications
  • Work with Action Queries
  • Advanced Query Techniques
  • Automate Processes with Macros
  • Advanced Forms
  • Advanced Report Techniques
View Curriculum
Requirements
  • Access 2016 Introduction or equivalent experience.
Description

This course is designed to teach students intermediate level skills in Microsoft Access 2016. In this course, students will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Students will also learn how to automate processes with Macros, advanced form techniques using Conditional Formatting, Tab controls, Combo Box controls and Sub-Forms, and advanced report techniques using Sub-Reports, columns and inserting charts.

Who is the target audience?
  • Students who want to take Access to the next level and improve their database design skills.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
02:02:42
+
Introduction
1 Lecture 00:52
+
Designing Tables for Better Data Entry
5 Lectures 20:30

Setting Field Size, Formats, and Captions
05:33


Restricting Data Entry: Validation Rules
02:06

Restricting Data Entry: Input Masks
06:14
+
Sharing Data with Other Applications
6 Lectures 13:49

Importing Data from a .TXT File
02:51

Importing Data from Excel
02:12

Exporting Data to a .TXT File
01:31

Linking External Data Sources
02:43

Using Word Merge
01:43
+
Working with Action Queries
6 Lectures 13:47

Creating an Update Query
02:27

Creating an Append Query
02:55

Creating a Delete Query
01:47

Creating a Make Table Query
01:39

Changing the Start Number of an AutoNumber Field
03:09
+
Advanced Query Techniques
9 Lectures 24:13
Creating Query Joins
05:13

Creating Find Unmatched and Find Duplicate Queries
02:46

Creating Parameter Queries
03:46

Using Like Keyword in Parameter Queries
02:13

Creating a Top X Query
01:22

Reviewing Calculated Query Fields
02:43

Summarizing Query Data with Totals
02:23

Inserting WHERE Statements in Summary Queries
01:02

Creating a Crosstab Query
02:45
+
Automating Processes with Macros
5 Lectures 23:32

Creating Macros to Open Forms by Record
04:05

Validating Data Entry with Macros
04:25

Creating a Macro to Automate Data Entry
03:31

Advanced Data Entry Using Macros and DLOOKUP Functions
05:47
+
Advanced Form
5 Lectures 12:32

Organizing Form Fields with Tab Controls
03:17

Creating a Combo Box Control
02:06

Creating an Option Group Control
02:48

Using a Subform to Show Data from a Related Table
02:48
+
Advanced Report Techniques
5 Lectures 12:32
Inserting a Chart on a Report
03:17

Showing Data in Columns
01:37


Configuring Reports with Parameter Queries
03:49

Sending Reports
01:38
+
Conclusion
1 Lecture 00:55
Course Recap
00:55
About the Instructor
Intellezy Trainers
4.4 Average rating
4,573 Reviews
26,716 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.