facebook-pixel
$29.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Intellezy Trainers, Instructor - Access 2016 Introduction

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

Instructor: Intellezy Trainers

Learn the basics of building a well-designed Access database.

  • Understand Databases and Database Terminology
  • Work with Data
  • Create Databases and Objects

Duration: 2h 55m

Course 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. Instructor: Ed McCrae

What am I going to get from this course?

  • Understand Databases and Database Terminology
  • Work with Data
  • Create Databases and Objects
  • Work with Queries
  • Work with Reports
  • Work with Forms

Prerequisites and Target Audience

What will students need to know or do before starting this course?

Basic computer skills. Knowledge of basic database concepts is helpful but not required.

Who should take this course? Who should not?

Students who want to learn database concepts and build basic databases.

Curriculum

Module 1: Introduction

00:58
Lecture 1 Introduction
00:58
Resource 1 Student Data Files

Module 2: Getting Started

35:47
Lecture 2 What is a Database?
01:56
Lecture 3 Understanding Database Terminology
05:18
Lecture 4 Navigating the Access Interface
06:11
Lecture 5 What is a Flat File Database?
04:26
Lecture 6 What is a Relational Database?
08:49
Lecture 7 Relating Tables
05:31
Lecture 8 Reviewing the Access Ribbon
03:36

Module 3: Working with Data

13:17
Lecture 9 Working with Tables
03:29
Lecture 10 Navigating Tables
01:44
Lecture 11 Editing Data
03:00
Lecture 12 Adding New Records
02:12
Lecture 13 Using Subdatasheets
02:52

Module 4: Creating Databases and Objects

43:16
Lecture 14 Understanding Database and Table Design Principles
10:26
Lecture 15 Using Table Data Sheet View
04:06
Lecture 16 Working with Field Data Types
03:59
Lecture 17 Using Table Design View
03:31
Lecture 18 Using Calculated Fields
03:51
Lecture 19 Calculating Numbers
03:20
Lecture 20 Calculating Dates
01:27
Lecture 21 Calculating Strings
02:09
Lecture 22 Using the Lookup Wizard
04:36
Lecture 23 Editing Lookups
04:05
Lecture 24 Using Indexes
01:46

Module 5: Working with Queries

30:01
Lecture 25 What are Queries?
03:03
Lecture 26 Creating Simple Queries
04:31
Lecture 27 Understanding the Dynaset
02:03
Lecture 28 Entering Criteria: Exact Match and Range Operators
04:06
Lecture 29 Understanding AND versus OR
03:19
Lecture 30 Using Wild Cards
02:20
Lecture 31 Using Keywords
02:32
Lecture 32 Sorting and Hiding Fields
01:49
Lecture 33 Creating Multi-Table Queries
03:19
Lecture 34 Additional Tips
02:59

Module 6: Working with Reports

25:33
Lecture 35 What are Reports?
02:39
Lecture 36 Understanding Report Types
02:45
Lecture 37 Building Effective Reports
01:53
Lecture 38 Using AutoReport
03:41
Lecture 39 Understanding the Report Wizard
03:51
Lecture 40 Using the Report Design View
08:15
Lecture 41 Creating Labels
02:29

Module 7: Working with Forms

25:11
Lecture 42 What are Forms?
04:03
Lecture 43 Understanding Form Types
01:46
Lecture 44 Creating Forms
02:02
Lecture 45 Navigating Forms
01:39
Lecture 46 Editing Data in Forms
03:06
Lecture 47 Understanding the Form Wizard
02:55
Lecture 48 Using the Form Design View
02:10
Lecture 49 Working with Controls
02:52
Lecture 50 Using Form Layout View
02:10
Lecture 51 Additional Tips
02:28

Module 8: Conclusion

01:06
Lecture 52 Course Recap
01:06
350