Microsoft Access 2010 Level 1 (Basic)

Switch version: 2019/2016/2013
Course Length: 12 hours (2 days)
Access is a relational database program which enables you to design and create tables to form a logical database. With Access, you can build simple queries, create forms and design basic reports from your tables. Access makes data easy to use, find and display.

Learning Objectives:
In this course, you will design and create tables, queries, forms and reports. You will:
  • Gain understanding on the concept of a relational database
  • Use design properties to create tables
  • Use tables to create queries
  • Use tables and queries to generate forms and reports
  • Print tables, forms and reports
Target Student:
This course is for individuals who are new to the concept of database design and use. Students should have basic computer skills (typing). Previous use of data arrangement, i.e. tables in Word or columns and rows in Excel is useful but not required.

Course Outline:
Section 1: Getting Started
Lesson 1.1: Starting Out
Lesson 1.2: Interface Basics
Lesson 1.3: Database Security
Lesson 1.4: Getting Help

Section 2: The New Interface
Lesson 2.1: The Quick Access Toolbar
Lesson 2.2: Basics of Tabs
Lesson 2.3: The Home Tab
Lesson 2.4: The Create Tab
Lesson 2.5: The External Data Tab
Lesson 2.6: The Database Tools Tab

Section 3: Creating a Database
Lesson 3.1: First Steps
Lesson 3.2: About Records
Lesson 3.3: Creating a Table
Lesson 3.4: Formatting Text

Section 4: Doing More with Your Database
Lesson 4.1: Creating and Using Forms
Lesson 4.2: Creating and Using Queries
Lesson 4.3: Creating and Using Reports
Lesson 4.4: Sorting and Filtering Data
Lesson 4.5: Viewing Data
Lesson 4.6: Printing a Database Object

Section 1: Advanced File Tasks
Lesson 1.1: Using Windows Explorer within Access
Lesson 1.2: Database Management
Lesson 1.3: Saving Your Files
Lesson 1.4: Exporting Files
Lesson 1.5: Linking Files

Section 2: Working with Tables
Lesson 2.1: Customizing Tables
Lesson 2.2: Formatting Tables
Lesson 2.3: Controlling Table Data Entry
Lesson 2.4: Managing Table Data Entry

Section 3: Working with Forms
Lesson 3.1: Basic Form Controls
Lesson 3.2: Advanced Form Controls
Lesson 3.3: Formatting Your Form
Lesson 3.4: Formatting Controls
Lesson 3.5: Using Themes

Section 4: Working with Reports
Lesson 4.1: Organizing Report Data
Lesson 4.2: Formatting Reports
Lesson 4.3: Common Report Tasks

Section 5: Working with Queries
Lesson 5.1: Basic Queries
Lesson 5.2: Doing More with Queries
Lesson 5.3: Creating Advanced Queries
Lesson 5.4: Creating Management (Action) Queries

This Course Comes With

PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Level 1 (Basic)
Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes
Date(s) Price Qty
October 5 & 6, 2020 9am to 4pm EDT $705.00 (CAD)*  
January 5 & 6, 2021 9am to 4pm EST $705.00 (CAD)*  

* 13% HST will be applied on checkout

Online registration closes two business days before the start of the class.
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here