Course Outline
Pre-Requisites
This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Students should also be comfortable navigating their computer in order to create and manage files and folders. No previous experience with other versions of Microsoft Access is necessary.
Lessons
By the end of this course, users should be comfortable with navigating the Microsoft Access interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.
Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This version of Access incorporates a few new features to better visualize data, support for new datatypes, as well as interface and workflow improvements.
Most of the features Microsoft incorporated in Office 2019 already exist in Office 365. Office 365 is a great solution for those looking for Office 2019 Training.
IS THIS THE RIGHT COURSE?
This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Students should also be comfortable navigating their computer in order to create and manage files and folders. No previous experience with other versions of Microsoft Access is necessary.
WHO SHOULD ATTEND?
This course is intended to help all novice computer users get up to speed quickly and, will also help more experienced users who have little to no experience with Microsoft Access and databases in general.
WHAT YOU'LL LEARN
- Getting Started with Access
- Working with Table Data
- Query a Database
- Create Advanced Queries
- Generate Reports
- Design a Relational Database
- Joining Tables
- Importing and Exporting Data
COURSE OUTLINE
Lesson 1: Getting Started with Access
- Topic A: What is Microsoft Access?
- Topic B: Components of a Database
- Topic C: Create a Simple Database
- Topic D: Creating a Simple Form
Lesson 2: Working with Table Data
- Topic A: Work with Table Data
- Topic B: Work with Records
- Topic C: Sort and Filter Records
- Topic D: Create Lookups and Relationships
Lesson 3: Query a Database
- Topic A: Use a Query to View Data from Multiple Tables
- Topic B: Sort and Filter Data in a Query
- Topic C: Perform Calculations in a Query
Lesson 4: Create Advanced Queries
- Topic A: Create Parameter Queries
- Topic B: Create Action Queries
- Topic C: Create Find Duplicate and Find Unmatched Queries
- Topic D: Summarize Data
Lesson 5: Generate Reports
- Topic A: Create a Report
- Topic B: Add Controls to a Report
- Topic C: Advanced Reporting
Lesson 6: Design a Relational Database
- Topic A: Relational Database Design
- Topic B: Working with Tables
- Topic C: Modify a Table and Fields
- Topic D: Create Table Relationships
Lesson 7: Joining Tables
- Topic A: Create Query Joins
- Topic B: Working with Subdatasheets and Subqueries
Lesson 8: Importing and Exporting Data
- Topic A: Import Data into Access
- Topic B: Export Data
- Topic C: Create a Mail Merge
FOLLOW-ON COURSES
- Microsoft Access 365: Part 2
Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Training Location
Online Classroom
your office
your city,
your province
your country
I would never take another course that starts at 11AM and goes to 9PM again. The way the course was laid out really took away from the capturing of what was presented as it was 5-6 hours of watching a screen before getting to the actual labs. There has to be a better way to lay out this particular course. In my previous course, the lectures were broken up by labs which worked out fantastic and kept you engaged in the course. There were days when in order to actually complete the labs, would go over the 9PM day end time frame. Was able to get the primary labs done, but if you want to get all the content completed, you cannot complete it in the window of this course, you will need to come back on your own time.