Embark on a comprehensive 2-hour 17-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 and learn to plan, design, and create database tables. Import data from Excel, manually enter table data, and explore sorting and filtering techniques. Dive into table relationships, the cornerstone of successful relational databases. Create queries, forms, and reports, and understand how table relationships affect queries. Explore advanced report and form design techniques, create switchboards, write macros, and use Access Visual Basic for Applications (VBA) for complex automation. Cover database security and customization options to round out your skillset. Gain practical experience through hands-on exercises and comprehensive explanations of key concepts, ensuring you can efficiently organize and store data while leveraging Access's powerful reporting capabilities.
Overview
Syllabus
Start
Introduction
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
