Introduction to Access
Database concepts
Access user interface
Creating and managing databases
Understanding tables, queries, forms, and reports

Tables & Data Types
Creating tables
Field properties
Primary keys
Data types and validation rules

Relationships & Keys
One-to-one, one-to-many relationships
Referential integrity
Cascade update and delete rules

Queries
Select queries
Criteria and filters
Calculated fields
Action queries (append, delete, update, make-table)
Parameter queries
Cross-tab and SQL view

Forms
Creating forms
Form layout and design
Controls: text boxes, combo boxes, buttons
Subforms
Form properties and events

Reports
Creating reports
Grouping and sorting
Calculated fields in reports
Layouts and design views
Printing and exporting reports

Macros & Automation
Creating macros
Macro actions and triggers
Automating repetitive tasks
Using macros in forms and reports

Importing & Exporting Data
Importing data from Excel, CSV, and text files
Exporting data
Linking external data sources

Advanced Access
Split database design
User-level security basics
Navigation forms
Using Access with SQL Server
Performance optimization