custom code gtranslate code

Microsoft Access 1

Learn the fundamentals of the MS Office Access in this Level 1 class. In the era of automation and algorithms, data storage and processing is very important. Be familiar with the Access interface and learn how to create tables, enter data and input validation formulas.

Course Outlines

  • Getting Started with Access
  • Working with Table Data
  • Querying a Database
  • Using Forms
  • Generating Reports

What you'll learn

  • Identify the components of a database, and work with those components.
  • Open a table, find information stored there, and enter data.
  • Create and customize a table design.
  • Enter data into tables and ensure its accuracy by using input masks and input validation formulas.
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity.
  • Create forms for entering data into tables and change the design elements that have been placed on those forms.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports and print preview reports.
  • Import and export data to and from various sources, including text files and Excel.
  • Preview and print database objects and change the page setup options.

Course Content

  • Identify the components of a database, and work with those components.
  • Open a table, find information stored there, and enter data.
  • Create and customize a table design.
  • Enter data into tables and ensure its accuracy by using input masks and input validation formulas.
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity.
  • Create forms for entering data into tables and change the design elements that have been placed on those forms.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports and print preview reports.
  • Import and export data to and from various sources, including text files and Excel.
  • Preview and print database objects and change the page setup options.

Customize a Course

We will be happy to assist you for inquiries about a customized scheduled or program:

Rachael McPherson, Director of Sales

☎(250)882-9549

📧rachael@qacademy.ca

Caroline Santos, Corporate and Custom Sales Manager- Eastern Canada

☎(514)771-3206

📧caroline.santos@qacademy.ca

Student Ratings & Reviews

Course Info

Prerequisites
This course does not require any prerequisites. Just your eagerness to learn!
Duration
12 Hours

Enroll Now

1:1 Price
$525.00
For Group Class Options

Enroll Now

For Corporate and Funding Agencies
popup and lms tutor hidden code
X
Customize A Course
We will be happy to assist you for inquiries about a customized scheduled or program:
Rachael McPherson
Director of Sales
 
Caroline Santos
Corporate and Custom Sales Manager
(Eastern Canada)
Phone Number
0(0)

Microsoft Access 1

  • Course level: Intermediate

Description

Learn the fundamentals of the MS Office Access in this Level 1 class. In the era of automation and algorithms, data storage and processing is very important. Be familiar with the Access interface and learn how to create tables, enter data and input validation formulas.

About the instructor

5.00 (1 ratings)

67 Courses

5 students

Send your feedback

Phone Number

Request for Instructor Info

Phone Number

Become A Program Partner

Q Academy works with the most innovative, sustainable industries and we continue to review all the major skills gaps across the globe. We’re looking for industry leaders and academic partners to help us create courses for upgrading skills within growing sectors across globe. We’d love to work with you to build something great!

Phone Number

Become A Hiring Partner!

With so many companies looking for great talent why not look take your needs directly to Q Academy and ensure your candidates have all the most update skills they need. Hire Great Talent without the high costs of some job search platforms or services.

Phone Number

Become a Training Partner!

Q Academy works with thosands of business across the globe and we have become several business go to training partners for the past 5 years.

Phone Number

Inquire Now

Phone Number

Log in
Login / Signup