Programming & Development

Access - Part 1


Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Course Objectives
In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports.

Course Outline:

Topic A: Launch Access and Open a Database
Topic B: Use Tables to Store Data
Topic C: Use Queries to Combine, Find, Filter, and Sort Data
Topic D: Use Forms to View, Add, and Update Data
Topic E: Use Reports to Present Data
Topic F: Get Help and Configure Options in Microsoft Access
Topic A: Plan an Access Database
Topic B: Start a New Access Database
Topic C: Create a New Table
Topic D: Establish Table Relationships
Topic A: Create Basic Queries
Topic B: Perform Calculations in a Query
Topic C: Sort and Filter Data in a Query
Topic A: Start a New Form
Topic B: Enhance a Form
Topic A: Start a New Report
Topic B: Enhance Report Layout
Topic A: Restrict Data Input Through Field Validation
Topic B: Restrict Data Input Through Forms and Record Validation
Topic A: Data Normalization
Topic B: Associate Unrelated Tables
Topic C: Enforce Referential Integrity

Enroll in this course


Need Help Finding The Right Training Solution?

Our training advisors are here for you.