Microsoft Office 365 - Access 2019

Hours: 30 / Access Length: 12 Months / Delivery: Online, Self-Paced

Course Overview:

** Students need a copy of Microsoft Office 365 in order to complete course work in this course **

 

In this course, we will learn the many facets of Microsoft Access 2019. We will learn basic functions, such as database objects, querying a database, and creating reports. We will learn advanced reporting techniques, using Macros, and database design.

Students will:

  • Create a Microsoft Access database.
  • Create a report from a database.
  • Create queries in a database.
  • Maintain a database by using action queries, formatting a datasheet, and sorting records.
  • Create reports and forms.
  • Perform advanced report and form techniques.
  • Create and modify Macros in a database.
  • Demonstrate the use of SQL language.
  • Design a database.

This course prepares a student to take the Microsoft Access 2019 national certification exam.

Course Outline:

Lesson 1: Database Basics

In this first lesson, we will start by learning database basics, including the features of Microsoft Access, opening a database, and properties of databases. This lesson also includes querying a database in order to gather information and exporting data.

Lesson 2: Maintaining a Database and Creating Reports

In this lesson, we will learn maintenance tasks in a database. This includes adding, modifying, and removing data as well as restructuring the database. This lesson will also cover reporting, and how to create reports and forms using the Wizard.

Lesson 3: Advanced Reporting

In this lesson, we will explore more advanced functions, such as using multiple tables to run a query and advanced reporting. Subreports and aggregate functions are topics covered in this lesson.

Lesson 4: Advanced Form Techniques and Macros

In this lesson, we will insert and modify charts, and use more advanced form techniques. We will also work with Macros and how it can assist with reporting and forms.

Lesson 5: Administering Access and Using SQL

In this lesson, we will explore Microsoft Access administrative functions, such as creating custom data types and indexes, and creating templates. We will also learn SQL language, and how it works with Access.

Lesson 6: Database Design

In this last lesson, we will explore how to design a custom database. We will determine the tables and fields needed to fit your purpose, and how to represent the database design with a diagram.

All necessary course materials are included.

Certification(s):

 


System Requirements:

Internet Connectivity Requirements:

  • Cable, Fiber, DSL, or LEO Satellite (i.e. Starlink) internet with speeds of at least 10mb/sec download and 5mb/sec upload are recommended for the best experience.

NOTE: While cellular hotspots may allow access to our courses, users may experience connectivity issues by trying to access our learning management system.  This is due to the potential high download and upload latency of cellular connections.   Therefore, it is not recommended that students use a cellular hotspot as their primary way of accessing their courses.

Hardware Requirements:

  • CPU: 1 GHz or higher
  • RAM: 4 GB or higher
  • Resolution: 1280 x 720 or higher.  1920x1080 resolution is recommended for the best experience.
  • Speakers / Headphones
  • Microphone for Webinar or Live Online sessions.

Operating System Requirements:

  • Windows 7 or higher.
  • Mac OSX 10 or higher.
  • Latest Chrome OS
  • Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

Web Browser Requirements:

  • Latest Google Chrome is recommended for the best experience.
  • Latest Mozilla FireFox
  • Latest Microsoft Edge
  • Latest Apple Safari

Basic Software Requirements (These are recommendations of software to use):

  • Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
  • PDF reader program (Adobe Reader, FoxIt)
  • Courses may require other software that is described in the above course outline.


** The course outlines displayed on this website are subject to change at any time without prior notice. **