Access 2013 - Beginner

Duration
5 Hours, 44 Minutes

 

Delivery Method
Self-Paced

Educate 360 Pro from New Horizons

This class is part of a 12‑month Educate 360 Pro Subscription

Course Overview

This course is an introduction to Microsoft Access 2013. 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 2013 Intermediate course.

Course Objectives

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

Course Prerequisites

The recommended pre-requisite for this course is basic computer skills. Knowledge of basic database concepts is helpful but not required.

Agenda

1 - Introduction

  • Introduction

2 - Getting Started with Access

  • What is a Database?
  • Understanding Database Terminology
  • Working with the Access Interface
  • Understanding Flat File Databases
  • Understanding Relational Databases
  • Joining Tables
  • Using the Access Ribbon

3 - Creating Databases and Objects

  • Learning Table Design Rules
  • Working with Field Data Types
  • Understanding Table Design View
  • Understanding Table Datasheet View
  • Calculating Fields
  • Calculating Numbers
  • Calculating Dates
  • Calculating Strings
  • Using the Lookup Wizard
  • Linking Tables
  • Indexing

4 - Advanced Customization and Working with Data Files

  • Working with Tables
  • Navigating a Table
  • Editing Data in a Table
  • Adding a New Record
  • Performing Advanced Filtering
  • Using Subdatasheets
  • Using Additional Filter and Sort Techniques

5 - Queries

  • What are Queries?
  • Creating a Simple Query
  • Understanding the Dynaset
  • Entering Criteria
  • Using Wild Cards
  • Using Keywords
  • Sorting and Hiding Fields
  • Performing Multi-Table Queries
  • Querying Tips and Tricks

6 - Reports

  • What are Reports?
  • Understanding Different Types of Reports
  • Designing Reports
  • Using AutoReport
  • Using the Report Wizard
  • Using the Report Design View
  • Creating Labels
  • Additional Reporting Tips and Gotchas

7 - Forms

  • What are Forms?
  • Understanding Form Types
  • Creating Forms
  • Navigating in the Form
  • Editing Data in a Form
  • Using the Form Wizard
  • Using the Form Design View
  • Working with Bound and Unbound Controls
  • Selecting, Moving, and Resizing Controls
  • Deleting Controls and Adding Fields
  • Using the Form Layout View
  • Working with Forms Tips and Tricks

8 - Conclusion

  • Course Recap

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.