Access 2016 - Part 1
E-Learning
Description
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.
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.
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.
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
| Lesson Id | Title | Description |
|---|---|---|
| 1 | GETTING STARTED WITH ACCESS 2016 |
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 |
| 2 | CREATING TABLES |
Topic A: Plan an Access Database Topic B: Start a New Access Database Topic C: Create a New Table Topic D: Establish Table Relationships |
| 3 | CREATING QUERIES |
Topic A: Create Basic Queries Topic B: Perform Calculations in a Query Topic C: Sort and Filter Data in a Query |
| 4 | CREATING FORMS |
Topic A: Start a New Form Topic B: Enhance a Form |
| 5 | CREATING REPORTS |
Topic A: Start a New Report Topic B: Enhance Report Layout |
Self-Paced
Free
This course includes: :
Full lifetime access