Course Description
Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. This Access 2016 Introduction is designed for beginners so that even if you’ve never so much as opened the program before, you can learn how to use it like a pro.
This course covers all the important features of Access 2016 and demonstrates how to use them. Here you’ll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records. This course will help you master Access and put it to creative, confident use. You’ll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you’ve finished the course, you’ll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.
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
Requirements
- Basic computer skills. Knowledge of basic database concepts is helpful but not required.
Who is the target audience?
- Students who want to learn database concepts and build basic databases.
-
Intro
00:01:00
-
What is a database
00:02:00 -
Understanding Database terminology
00:05:00 -
Navigating the Access Interface
00:06:00 -
What is a flat file database
00:04:00 -
What is a relational database
00:09:00 -
Relating Tables
00:06:00 -
Reviewing the Access Ribbon
00:04:00
-
Working with Tables
00:04:00 -
Navigating Tables
00:02:00 -
Editing Data
00:03:00 -
Adding New Records
00:02:00 -
Using Subdata Sheets
00:03:00
-
Understanding Database and Table Design Principles
00:10:00 -
Using Table Data Sheet View
00:04:00 -
Working with Field Data Types
00:04:00 -
Using Table Design View
00:03:00 -
Using Calculated Fields
00:04:00 -
Calculating Numbers
00:03:00 -
Calculating Dates
00:01:00 -
Calculating Strings
00:02:00 -
Using the Lookup Wizard
00:05:00 -
Editing Lookups
00:04:00 -
Using Indexes
00:02:00
-
What are Queries
00:03:00 -
Creating Simple Queries
00:04:00 -
Understanding the Dynaset
00:02:00 -
Entering Criteria- Exact Match and Range Operators
00:04:00 -
Understanding AND v. OR
00:03:00 -
Using Wild Cards
00:02:00 -
Using Key Words
00:03:00 -
Sorting and Hiding Fields
00:02:00 -
Creating Multi-Table Queries
00:03:00 -
Additional Tips
00:03:00
-
What are Reports
00:03:00 -
Understanding Report Types
00:03:00 -
Building Effective Reports
00:02:00 -
Using AutoReport
00:04:00 -
Understanding the Report Wizard
00:04:00 -
Using the Report Design View
00:08:00 -
Creating Labels
00:02:00
-
What are Forms
00:04:00 -
Understanding Form Types
00:02:00 -
Creating Forms
00:02:00 -
Navigating Forms
00:02:00 -
Editing Data in Forms
00:03:00 -
Understanding the Form Wizard
00:03:00 -
Using the Form Design View
00:04:00 -
Working with Controls
00:03:00 -
Using Form Layout View
00:02:00 -
Additional Tips (2)
00:02:00
-
Course Recap
00:01:00
-
Resources – Access 2016 Introduction
Course Reviews
No Reviews found for this course.