Access 2016 - Part 1

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.

In this course, you will create and manage an Access 2016 database. You will:  

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.
 
Course Outline
1 - GETTING STARTED WITH ACCESS
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access
2 - WORKING WITH TABLE DATA
  • Modify Table Data
  • Sort and Filter Records
3 - QUERYING A DATABASE
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
4 - USING FORMS
  • Create Basic Access Forms
  • Work with Data on Access Forms
5 - GENERATING REPORTS
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports
6 - DESIGNING A RELATIONAL DATABASE
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
7 - JOINING TABLES
  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets
8 - USING DATA VALIDATION
  • Use Field Validation
  • Use Form and Record Validation
9 - CREATING ADVANCED QUERIES
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
10 - ORGANIZING A DATABASE FOR EFFICIENCY
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
11 - USING ADVANCED REPORTING TECHNIQUES
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Contact Us For Price

Course Length: 2 Days

1. Choose a Date | 2. Click Enroll Now
Need Help Picking the Right Course? Give us a call! 781-388-0026
Awaiting product image

Description

In this course, you will create and manage an Access 2016 database. You will:

 

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

 

© Copyright - Network Technology Academy
Architecting on AWS AWS Solutions Architect Certification – Associate