Access 2016 Introduction
4.5 (20 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.
91 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Access 2016 Introduction

Learn the basics of building an Access database with well built tables, queries, forms and reports.
4.5 (20 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.
91 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand Databases and Database Terminology
  • Work with Data
  • Create Databases and Objects
  • Work with Queries
  • Work with Reports
  • Work with Forms
View Curriculum
Requirements
  • Basic computer skills. Knowledge of basic database concepts is helpful but not required.
Description

This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create a basic database, create tables, queries, reports and forms, perform calculation with fields, numbers, and dates, navigate and work with tables and the various data types, understand and work with select queries, review and work with various reports and reporting features, and review data entry forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course.

Who is the target audience?
  • Students who want to learn database concepts and build basic databases.
Compare to Other Microsoft Access Courses
Curriculum For This Course
52 Lectures
02:56:44
+
Introduction
1 Lecture 01:03
+
Getting Started
7 Lectures 35:47

Understanding Database Terminology
05:18

Navigating the Access Interface
06:11

What is a Flat File Database?
04:26

What is a Relational Database?
08:49

Relating Tables
05:31

Reviewing the Access Ribbon
03:36
+
Working with Data
5 Lectures 13:17

Navigating Tables
01:44

Editing Data
03:00

Adding New Records
02:12

Using Subdatasheets
02:52
+
Creating Databases and Objects
11 Lectures 43:16

Using Table Data Sheet View
04:06

Working with Field Data Types
03:59

Using Table Design View
03:31

Using Calculated Fields
03:51

Calculating Numbers
03:20

Calculating Dates
01:27

Calculating Strings
02:09

Using the Lookup Wizard
04:36

Editing Lookups
04:05

Using Indexes
01:46
+
Working with Queries
10 Lectures 30:01

Creating Simple Queries
04:31

Understanding the Dynaset
02:03

Entering Criteria: Exact Match and Range Operators
04:06

Understanding AND versus OR
03:19

Using Wild Cards
02:20

Using Keywords
02:32

Sorting and Hiding Fields
01:49

Creating Multi-Table Queries
03:19

Additional Tips
02:59
+
Working with Reports
7 Lectures 25:33

Understanding Report Types
02:45

Building Effective Reports
01:53

Using AutoReport
03:41

Understanding the Report Wizard
03:51

Using the Report Design View
08:15

Creating Labels
02:29
+
Working with Forms
10 Lectures 26:41

Understanding Form Types
01:46

Creating Forms
02:02

Navigating Forms
01:39

Editing Data in Forms
03:06


Using the Form Design View
03:40

Working with Controls
02:52

Using Form Layout View
02:10

Additional Tips
02:28
+
Conclusion
1 Lecture 01:06
Course Recap
01:06
About the Instructor
Intellezy Trainers
4.4 Average rating
5,132 Reviews
29,088 Students
138 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.