Booking options
£25
£25
On-Demand course
4 hours 42 minutes
All levels
Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion
Basic computer skills. Knowledge of basic database concepts is helpful but not required.
This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course.
Access 2019 Beginner | |||
Module 1: Introduction to the course | 00:01:00 | ||
Module 2: What is Database | 00:03:00 | ||
Module 3: Understanding Database terminology | 00:04:00 | ||
Module 4: Navigating the Access Interface | 00:09:00 | ||
Module 5: What is Flat file Database | 00:03:00 | ||
Module 6: What is Relational Database | 00:10:00 | ||
Module 7: Relating Tables | 00:08:00 | ||
Module 8: Reviewing the Access Ribbon | 00:02:00 | ||
Module 9: Working with Tables | 00:07:00 | ||
Module 10: Navigating Tables | 00:03:00 | ||
Module 11: Editing Data | 00:03:00 | ||
Module 12: Adding New Records | 00:03:00 | ||
Module 13: Using Subdatasheets | 00:04:00 | ||
Module 14: Understanding Database and Table Design Principles | 00:09:00 | ||
Module 15: Using Table Data Sheet View | 00:04:00 | ||
Module 16: Working with Field Data Types | 00:07:00 | ||
Module 17: Using Table Design View | 00:04:00 | ||
Module 18: Using Calculated Fields | 00:08:00 | ||
Module 19: Calculating Dates | 00:04:00 | ||
Module 20: Calculating Strings | 00:04:00 | ||
Module 21: Using the Lookup Wizard | 00:11:00 | ||
Module 22: Lookup Wizard Linking Tables | 00:06:00 | ||
Module 23: Using Indexes | 00:05:00 | ||
Module 24: What are Queries | 00:06:00 | ||
Module 25: Creating Simple Queries | 00:05:00 | ||
Module 27: Entering Criteria-Exact Match and Ranger Operators | 00:06:00 | ||
Module 28: Understanding And VS Or | 00:06:00 | ||
Module 29: Using Wild Cards | 00:04:00 | ||
Module 30: Using Key Words | 00:04:00 | ||
Module 31: Sorting and Hiding Fields | 00:03:00 | ||
Module 32: Creating Multi-Table Queries | 00:03:00 | ||
Module 33: Creating a Calculated Field in Query | 00:05:00 | ||
Module 34: Additional Tips | 00:05:00 | ||
Module 35: What are Reports | 00:04:00 | ||
Module 36: Understanding Report Types | 00:03:00 | ||
Module 37: Building Good Reports | 00:02:00 | ||
Module 38: Using Autoreport | 00:06:00 | ||
Module 39: The Report Wizard | 00:12:00 | ||
Module 40: Using the Report Design View | 00:07:00 | ||
Module 41: Printing Reports | 00:04:00 | ||
Module 42: Creating Labels | 00:05:00 | ||
Module 43: Additional Tips | 00:09:00 | ||
Module 44: What are Forms | 00:03:00 | ||
Module 45: Understanding Form Types | 00:03:00 | ||
Module 46: Creating Forms | 00:02:00 | ||
Module 47: Navigating Forms | 00:02:00 | ||
Module 48: Editing Data in Forms | 00:05:00 | ||
Module 49: Understanding the Form Wizard | 00:05:00 | ||
Module 50: Using the Form Design View | 00:04:00 | ||
Module 51: Working with Controls | 00:07:00 | ||
Module 52: Using the Form Layout View | 00:03:00 | ||
Module 53: Additional Tips | 00:07:00 | ||
Downloadable Resources | |||
Resources - Access 2019 Beginner | 00:00:00 | ||
Final Exam | |||
Final Exam - Access 2019 Beginner | 00:20:00 |
We understand more than anyone how important it is for yo...