We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today!

Access 2013

Beginner
Subscribe Now

Course Overview

Instructor: Jason Christie
Subject: Access 2013
Duration: 05 Hour 44 Minutes
Level: Beginner
Pre-requisites: Basic computer skills. Knowledge of basic database concepts is helpful but not required.
CC Languages: Arabic, Chinese (Simplified) , English, French, German, Hindi, Japanese, Portuguese (Brazil), Russian, Spanish

Description

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 Lessons

Introduction
Introduction1min 04sec
Getting Started with Access
What is a Database?1min 29sec Understanding Database Terminology2min 26sec Working with the Access Interface4min 29sec Understanding Flat File Databases4min 26sec Understanding Relational Databases8min 57sec Joining Tables9min 44sec Using the Access Ribbon2min 42sec
Creating Databases and Objects
Learning Table Design Rules7min 43sec Working with Field Data Types11min 02sec Understanding Table Design View5min 28sec Understanding Table Datasheet View3min 52sec Calculating Fields4min 29sec Calculating Numbers5min 24sec Calculating Dates9min 00sec Calculating Strings6min 19sec Using the Lookup Wizard5min 23sec Linking Tables7min 29sec Indexing5min 28sec
Advanced Customization and Working with Data Files
Working with Tables9min 13sec Navigating a Table4min 02sec Editing Data in a Table5min 02sec Adding a New Record3min 15sec Performing Advanced Filtering7min 30sec Using Subdatasheets4min 34sec Using Additional Filter and Sort Techniques2min 28sec
Queries
What are Queries?5min 08sec Creating a Simple Query7min 42sec Understanding the Dynaset2min 58sec Entering Criteria7min 19sec Using Wild Cards10min 38sec Using Keywords6min 20sec Sorting and Hiding Fields7min 13sec Performing Multi-Table Queries9min 34sec Querying Tips and Tricks7min 26sec
Reports
What are Reports?6min 41sec Understanding Different Types of Reports9min 45sec Designing Reports4min 18sec Using AutoReport9min 05sec Using the Report Wizard9min 14sec Using the Report Design View10min 23sec Creating Labels5min 57sec Additional Reporting Tips and Gotchas10min 07sec
Forms
What are Forms?4min 40sec Understanding Form Types4min 47sec Creating Forms4min 47sec Navigating in the Form3min 42sec Editing Data in a Form4min 12sec Using the Form Wizard6min 45sec Using the Form Design View9min 36sec Working with Bound and Unbound Controls4min 31sec Selecting, Moving, and Resizing Controls6min 52sec Deleting Controls and Adding Fields5min 17sec Using the Form Layout View5min 08sec Working with Forms Tips and Tricks9min 30sec
Conclusion
Course Recap1min 30sec

Jason Christie

Instructor

Jason began his career teaching in the public schools. Since transitioning to IT training and consulting, he has helped individuals and companies hone their IT skills to be more productive by getting the most out of their software applications and systems. He has consulted with small and global companies with new software and system installs, helping to ensure proper usage as well as adherence to recommended best practices and governance rules.

Learn More About Jason Christie

© 2020 Intellezy, LLC. All rights reserved | Terms of Use | Privacy