-
Microsoft Access 2016: Level 1 - Beginner
-
Course length:
1.0 day
Course Objective:
You will create and modify new databases and their various objects.
Target Student:
This course is designed for students who wish to learn the basic
operations of the Microsoft Access database program to perform their
day-to-day responsibilities, and who want to use the application
to be more productive in their work. It provides the fundamental
knowledge and techniques needed to use more complex Access features
such as maintaining databases and using programming techniques that
enhance Access applications.
Certification:
This course is one of a series of courseware titles that addresses
Microsoft Office Specialist (MOS) certification skill sets. The
MOS and certification program is for individuals who use Microsoft's
business desktop software and who seek recognition for their expertise
with specific Microsoft Excel-Add-In.
Course Objectives:
Upon successful completion of this course, students will be able
to:
- identify the basic components of an Access database
- build the structure of a database
- manage data in tables
- query a database
- design forms
- generate reports.
-
Course Content
Lesson 1: Getting Started with Access Databases
- Identify the Elements of the Access 2013 Interface
- Identify the Components of a Database
- Examine the Relational Database Design Process
Lesson 2: Building the Structure of a Database
- Create a New Database
- Create a Table
- Manage Tables
- Establish Table Relationships
Lesson 3: Managing Data in a Table
- Modify Table Data
- Sort and Filter Records
- Work with Subdatasheets
Lesson 4: Querying a Database
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
Lesson 5: Designing Forms
- Create a Form
- Modify the Design of a Form
- View and Edit Data Using an Access Form
Lesson 6: Generating Reports
- Create a Report
- Add a Control to a Report
- Format the Controls in a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
Appendix A: Microsoft Office Access 2013 Exam 77–885