Error

Invalid column name 'Price'.

Access 365 - Beginner

 Jump to Course Request Form

Course Overview

This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course.

Course Objectives

Getting Started with Access, Working with Data, Creating Databases and Objects, Working with Queries, Working with Reports, Working with Forms

Course Outline

1 - Introduction

  • Introduction

2 - Getting Started with Access

  • What is a Database?
  • Database Terminology
  • The Access Interface
  • What is a Flat File Database?
  • What is a Relational Database?
  • Relating Tables
  • Reviewing the Access Ribbon

3 - Working with Data

  • Working with Tables
  • Navigating Tables
  • Editing Data
  • Adding New Records
  • Using Subdatasheets

4 - Creating Databases and Objects

  • Understanding Database and Table Design Principles
  • Using Table Data Sheet View
  • Working with Field Data Types
  • Using Table Design View
  • Using Calculated Fields
  • Calculating Numbers
  • Calculating Dates
  • Calculating Strings
  • Using the Lookup Wizard
  • Lookup Wizard Linking Tables
  • Using Indexes

5 - Working with Queries

  • What are Queries?
  • Creating Simple Queries
  • Understanding the Dynaset
  • Criteria-Exact Match and Range Operators
  • Understanding AND Versus OR
  • Using Wild Cards
  • Using Key Words
  • Sorting and Hiding Fields
  • Creating Multi-Table Queries
  • Additional Tips

6 - Working with Reports

  • What are Reports?
  • Understanding Report Types
  • Building Good Reports
  • Using AutoReport
  • Understanding the Report Wizard
  • Using the Report Design View
  • Printing Reports
  • Creating Labels
  • Additional Tips

7 - Working with Forms

  • What are Forms?
  • Understanding Form Types
  • Creating Forms
  • Navigating Forms
  • Editing Data in Forms
  • Understanding the Form Wizard
  • Using Form Design View
  • Working with Controls
  • Using Form Layout View
  • Additional Tips

8 - Conclusion

  • Course Recap