Access 2016 - Part 1
Duration
2 Days
Price
300,00 €
Course Type
Virtual / Physical
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.
Learning 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.
-
-
-
Course Outline
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
Target Audience
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.