Overview
Syllabus
Start
Introduction
How Databases Operate
Accessing Databases
Exploring Relational Databases
Examining Database Objects
How Data is Related Between Tables
Understanding the Access Interface
Planning Steps and Naming Conventions for New Databases
Planning Tables
Creating Tables in Design View
Importing Data from Excel into New Tables
Modifying New Table Imports
Importing to Existing Tables
Importing to Existing Tables by Yourself
Manually Entering Data in a Table
Sorting and Filtering Data
Creating Table Relationships
Using the Simple Query Wizard
Creating Queries in Design View
Customizing Queries with Criteria
Conclusion
Taught by
Learnit Training