This course is designed for beginners through experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Access. The course aims to teach students how to navigate a completed database, understand relational databases, design and create database tables, import and enter table data, create queries, forms, and reports, explore table relationships, and automate queries using Access Visual Basic for Applications (VBA). The teaching method includes hands-on exercises, demonstrations, and step-by-step instructions.
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
