Access 2019 Level 1 – Planning, Tables & Views (Introduction)

Course: 9040

This introduction course provides the basic concepts and skills to start using Microsoft Access 2019: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

Download PDF
  • Duration: 1 days
  • Price: $795.00
Get This Course $795.00
8-Aug

9:00 AM – 4:00 PM CST

12-Sep

9:00 AM – 4:00 PM CST

10-Oct

9:00 AM – 4:00 PM CST

14-Nov

9:00 AM – 4:00 PM CST

12-Dec

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

Course Overview

This introduction course provides the basic concepts and skills to start using Microsoft Access 2019: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports. The course assumes you know how to use a computer and that you’re familiar with Microsoft Windows. It does not assume that you’ve used a different version of Access or another database system before.

Is this the right course for me?

Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.

Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.

Course Outline

Module 1: Database fundamentals

  • Understanding general database terms
  • Relational databases
  • Access interface and objects

Module 2: Tables

  • Creating tables
  • Creating fields
  • Data Validation
  • Relationships and keys

Module 3: Queries

  • Creating basic queries
  • Modifying queries
  • Using calculated fields

Module 4: Forms 

  • Creating simple forms
  • Form design
  • Form controls

Module 5: Reports

  • Creating Reports
  • Report controls
  • Formatting reports

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961