Introduction to Database Objects and the Access Interface
5
Accessing the Northwind Template
6
Exploring the Login and Homes Forms
7
Navigation Pane Default View and Datasheet and Design Views for Tables
8
Exploring Datasheet View, Design View, and SQL View for Query Objects
9
Exploring Form View, Layout View, and Design View for Form Objects
10
Exploring Report View, Layout View, Design View, and Print Preview for Report Objects
11
Running Macros and Exploring Design View
12
Examining VBA Code
13
Access Ribbon and Status Bar
14
Exploring the Relationships Window and Closing the Database
15
Introduction to Creating New Databases
16
Creating Blank Databases
17
Switching Default Table to Design View and Renaming the Primary Key Field
18
Adding Remaining Fields to the Customers Table
19
Field Descriptions, Format and Text Limit, and Input Mask
20
Using the Caption Field Property
21
Creating New Tables in Design View
22
Introduction to Entering Data into Tables
23
Manually Entering Table Data
24
Importing from Excel - Appending to Existing Table - Employees
25
Importing from Excel - Appending with Different Data Types Error - Customers
26
Importing from Excel - Adding Data into A New Table - Categories
27
Importing from Excel - Adding Data into New Tables
28
Reviewing Data Types and Field Properties for Imported Tables - Products
29
Reviewing Data Types and Field Properties for Imported Tables - Orders
30
Order Details Table - Discussing Composite Key Fields
31
Setting a Composite Key - Order Details
32
Sorting Table Data
33
Inclusive Filtering, Exclusive Filtering, and Filtering by Form
34
Introduction to Relationships
35
Adding Tables to the Relationships Window and Organizing Them
36
Common Fields Between Tables
37
Creating a One-To-Many Relationship Between Customers and Employees Tables
38
Creating Relationship Errors
39
Resolving Data Type Errors and Repopulating Table Fields
40
Manually Repopulating Table Fields
41
Creating Lookup Fields in a Table
42
Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error
43
Resolving a Data Type Error and Repopulating Table Fields
44
Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship
45
Database Basics Recap
46
Conclusion
Description:
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.
Read more