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.
Course Curriculum
Introduction | |||
Intro | FREE | 00:01:00 | |
Getting Started | |||
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 Data | |||
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 | ||
Creating Databases and Objects | |||
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 | ||
Working with Queries | |||
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 | ||
Working with Reports | |||
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 | ||
Working with Forms | |||
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 | ||
Conclusion | |||
Course Recap | 00:01:00 | ||
Resources | |||
Resources – Access 2016 Introduction | 00:00:00 | ||
Course Certification |