Access 2019 - Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task.

In this course, you will create and manage an Access 2019 database.

  • You will:
  • Navigate within the 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 2019
  • 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
6 - PROMOTING QUALITY DATA INPUT
  • Topic A: Restrict Data Input Through Field Validation
  • Topic B: Restrict Data Input Through Forms and Record Validation
7 - IMPROVING EFFICIENCY AND DATA INTEGRITY
  • Topic A: Data Normalization
  • Topic B: Associate Unrelated Tables
  • Topic C: Enforce Referential Integrity

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 2019 database.

  • You will:
  • Navigate within the 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.

Reviews

There are no reviews yet.

Be the first to review “Access 2019 – Part 1”

Your email address will not be published. Required fields are marked *

Related products

© Copyright - Network Technology Academy
Donation Adobe Acrobat Pro DC – Advanced