1 Day (6.5 instructional hours)
Course Number: 091045S
Upon successful completion of this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
This course is intended 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.
To ensure success, students will need to be familiar with using or have equivalent knowledge of: Using Microsoft Windows 10, and Microsoft Windows 10: Transition from Windows 7.
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help and Configure Options in Microsoft Access
Topic A: Modify Table Data
Topic B: Sort and Filter Records
Topic A: Create Basic Queries
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query
Topic A: Create Basic Access Forms
Topic B: Work with Data on Access Forms
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Topic E: Organize Report Information
Topic F: Format Reports