Access 2013 Intermediate
4.4 (5 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.
35 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Access 2013 Intermediate

Take your Access skills to the next level by learning advanced query, form, report, and macro techniques.
4.4 (5 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.
35 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 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 Improved Accuracy in Data Entry
  • Share Data with Other Applications
  • Work with Action Queries
  • Learn Advanced Query Techniques
  • Automate Processes with Macros
  • Learn Advanced Form Techniques
  • Work with Advanced Report Techniques
View Curriculum
Requirements
  • Access 2013 Introduction or equivalent experience.
Description

This course is designed to teach students intermediate level skills in Microsoft Access 2013. 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 increase their knowledge of Access.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
03:46:40
+
Introduction
1 Lecture 02:20
+
Designing Tables for Improved Accuracy in Data Entry
4 Lectures 23:17

Setting Default Values and Required Fields
05:26

Restricting Data Entry - Validation Rules
06:45

Restricting Data Entry - Input Masks
07:44
+
Sharing Data with Other Applications
6 Lectures 27:21

Importing Data from a Text File
03:42

Importing Data from Excel
04:57

Exporting Data to a Text File
02:54

Linking External Data Sources
07:42

Using Word Merge
05:43
+
Action Queries
6 Lectures 28:44

Creating an Update Query
06:30

Creating an Append Query
04:32

Creating a Delete Query
06:16

Creating a Make Table Query
04:38

Changing the Start Number of an AutoNumber Field
04:41
+
Advanced Query Techniques
9 Lectures 44:15

Creating Find Unmatched and Find Duplicate Queries
05:10

Creating Parameter Queries
03:31

Using Like Keyword in Parameter Queries
04:25

Creating a Top X Query
03:25

Reviewing Calculated Query Fields
06:47

Summarizing Query Data with Totals
04:09

Inserting WHERE Statements in a Summary Query
04:16

Creating a Crosstab Query
06:54
+
Automate Processes with Macros
5 Lectures 36:09

Creating Macros to Open Forms by Record
06:18

Validating Data Entry with Macros
07:07

Creating a Macro to Automate Data Entry
06:44

Advanced Data Entry Using Macros and DLOOKUP Functions
09:26
+
Advanced Form Techniques
6 Lectures 34:09

Organizing Form Fields with a Tab Control
09:26

Creating a Combo Box Control
05:11

Creating an Option Group Control
05:08

Configuring a Combo Box Control to Show Search Results
05:45

Using a Sub-Form to Show Data from a Related Table
04:03
+
Advanced Report Techniques
5 Lectures 26:01

Showing Data In Columns
03:44

Inserting a Sub-Report
06:53

Configuring Reports with Parameter Queries
06:21

Sending Reports
02:40
+
Conclusion
1 Lecture 04:24
Course Recap
04:24
About the Instructor
Intellezy Trainers
4.4 Average rating
5,030 Reviews
28,825 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.