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.
or
Get all courses for only £492000+ Globally Recognised Premium Courses
This course includes:
