Acquire the skills to design and construct fundamental database architectures, manage data entry and revisions, apply filtering and sorting processes, generate database tables, construct interactive forms, perform database searches and analysis, and compile comprehensive data reports.
Comprehensive Course Structure
Lesson 1: Using Access Database Applications
- Topic A: Open Access Program and Navigate Database Files
- Topic B: Use Table Structures for Information Storage
- Topic C: Use Query Functions to Merge, Search, Filter, and Sort Information
- Topic D: Apply Form Tools to Display, Create, and Edit Information
- Topic E: Apply Report Functions to Organize and Display Information
- Topic F: Use Microsoft Access Help and Customize Configuration Settings
Lesson 2: Designing Database Tables
- Topic A: Prepare a Database Design Strategy
- Topic B: Create a New Database
- Topic C: Design and Build Table Structures
- Topic D: Link Tables Together
Lesson 3: Constructing Database Queries
- Topic A: Develop Simple Query Requests
- Topic B: Add Formula-Based Fields to Query Results
- Topic C: Organize and Filter Data in Query Results
Lesson 4: Building Database Forms
- Topic A: Create a New Form
- Topic B: Modify and Improve Form Features
Lesson 5: Designing Database Reports
- Topic A: Generate a Report
- Topic B: Customize Report Structure and Organization
