Access Introduction – Standard – Full Day

$ 285.00

Class Duration: 7 Hours

Class Agenda

Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Other Breaks Prescribed by Instructor

In our Access training courses, students will learn how to take control of their data. This course will teach the basic features of Access.

  • Introduction into How Databases Operate 
  • Learning the Access Interface 
  • Creating A New Database 
  • Designing and Creating New Tables 
  • Entering Data into Tables 
  • Sorting and Filtering Data 
  • Introduction into Relating Table Data 
  • Create Commonly Used Queries 
  • Customizing Queries with Criteria 
  • Using Forms for Data Entry 
  • Create Reports for Data Output
  • Exploring a Relational Database
  • Examining Database Objects 
  • How Data Is Related Between Tables 
  • Examining Access Menu Tabs 
  • Using the Access Navigation Pane 
  • Using the Data View and Design View of an Object
  • Planning Steps to Create a New Database
  • Create Tables in Design View
  • Import Data from Excel
  • Data Entry Techniques and Shortcuts
  • Re-arranging Records by Sorting 
  • Hiding Records Using Filtering 
  • Using the Relationships Window 
  • Using the Simple Query Wizard 
  • Creating Queries in Design View
  • Adding Criteria for Text, Number, And Date Fields
  • Introduction into Using Wildcards in Criteria 
  • Creating Forms
  • Exploring Different Form Layouts
  • Perform Data Entry in Forms
  • Basing Reports on Queries 
  • Previewing and Printing Reports 
  • Understanding the Report Design Interface 
  • Formatting Reports for Professional-Looking Output 
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top