Access 2016 – Part 1
This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course.
Course Objectives
In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Agenda
- 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
FREE
Interested in course?
Course Type: Instructor Led