Embark on a comprehensive 2-hour 16-minute tutorial designed for beginners and experienced users alike to master Microsoft Access 2021. Navigate through a completed database while exploring relational database concepts and objects. Familiarize yourself with the Access interface before diving into planning, designing, and creating database tables. Learn to import data from Excel, manually enter table data, and apply sorting and filtering techniques. Explore table relationships, the cornerstone of successful relational databases, and create queries, forms, and reports. Discover how table relationships affect queries, automate them, and create action queries. Advance your skills with report and form design techniques, create switchboards, write macros, and utilize Access Visual Basic for Applications (VBA) for complex automation. Conclude by covering database security and customization options. Access exercise files, ad-free training, exams, certificates, and exclusive content through the provided links.
Overview
Syllabus
Start
Database Basics
Introduction to Database Objects and the Access Interface
Accessing the Northwind Template
Exploring the Login and Homes Forms
Navigation Pane Default View and Datasheet and Design Views for Tables
Exploring Datasheet View, Design View, and SQL View for Query Objects
Exploring Form View, Layout View, and Design View for Form Objects
Exploring Report View, Layout View, Design View, and Print Preview for Report Objects
Running Macros and Exploring Design View
Examining VBA Code
Access Ribbon and Status Bar
Exploring the Relationships Window and Closing the Database
Introduction to Creating New Databases
Creating Blank Databases
Switching Default Table to Design View and Renaming the Primary Key Field
Adding Remaining Fields to the Customers Table
Field Descriptions, Format and Text Limit, and Input Mask
Using the Caption Field Property
Creating New Tables in Design View
Introduction to Entering Data into Tables
Manually Entering Table Data
Importing from Excel - Appending to Existing Table - Employees
Importing from Excel - Appending with Different Data Types Error - Customers
Importing from Excel - Adding Data into A New Table - Categories
Importing from Excel - Adding Data into New Tables
Reviewing Data Types and Field Properties for Imported Tables - Products
Reviewing Data Types and Field Properties for Imported Tables - Orders
Order Details Table - Discussing Composite Key Fields
Setting a Composite Key - Order Details
Sorting Table Data
Inclusive Filtering, Exclusive Filtering, and Filtering by Form
Introduction to Relationships
Adding Tables to the Relationships Window and Organizing Them
Common Fields Between Tables
Creating a One-To-Many Relationship Between Customers and Employees Tables
Creating Relationship Errors
Resolving Data Type Errors and Repopulating Table Fields
Manually Repopulating Table Fields
Creating Lookup Fields in a Table
Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error
Resolving a Data Type Error and Repopulating Table Fields
Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship
Database Basics Recap
Conclusion
Taught by
Learnit Training
