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
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
