This course teaches you to design basic database structures, input and modify data records, organize information through filtering and sorting, construct database tables, build user interface forms, construct and execute database queries, and create data presentation reports.
Detailed Course Outline
Lesson 1: Navigating Access Database Systems
- Topic A: Start Access Application and Load Database Files
- Topic B: Apply Tables as Data Storage Solutions
- Topic C: Employ Queries to Integrate, Locate, Filter, and Organize Data
- Topic D: Utilize Forms to Display, Insert, and Modify Data
- Topic E: Implement Reports for Data Presentation and Analysis
- Topic F: Access Help Resources and Adjust Program Settings in Microsoft Access
Lesson 2: Building Database Tables
- Topic A: Design an Access Database Framework
- Topic B: Initialize a New Access Database Project
- Topic C: Build a Custom Table Structure
- Topic D: Define Connections Between Tables
Lesson 3: Building Database Queries
- Topic A: Construct Simple Query Structures
- Topic B: Incorporate Computed Fields in Queries
- Topic C: Apply Sorting and Filtering Operations in Queries
Lesson 4: Building Data Input Forms
- Topic A: Initialize a Form Document
- Topic B: Add Features and Polish Form Appearance
Lesson 5: Building Report Documents
- Topic A: Construct a Report Document
- Topic B: Refine Report Visual Organization and Design
