Take this
course

Office Productivity / Microsoft

Access 2013 Introduction

An introduction to Access 2013. Get started with creating databases and becoming familiar with the Access environment.

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.


Instructor: Jason Christie

Full details

Curriculum

  • Introduction
    Introduction
    1:05
    Course Exercise Files
  • Getting Started with Access
    What is a Database?
    1:30
    Understanding Database Terminology
    2:27
    Working with the Access Interface
    4:30
    Understanding Flat File Databases
    4:27
    Understanding Relational Databases
    8:58
    Joining Tables
    9:45
    Using the Access Ribbon
    2:43
  • Creating Databases and Objects
    Learning Table Design Rules
    7:44
    Working with Field Data Types
    11:03
    Understanding Table Design View
    5:29
    Understanding Table Datasheet View
    3:53
    Calculating Fields
    4:30
    Calculating Numbers
    5:25
    Calculating Dates
    9:01
    Calculating Strings
    6:20
    Using the Lookup Wizard
    5:24
    Linking Tables
    7:30
    Indexing
    5:29
  • Advanced Customization and Working with Data Files
    Working with Tables
    9:14
    Navigating a Table
    4:04
    Editing Data in a Table
    5:03
    Adding a New Record
    3:16
    Performing Advanced Filtering
    7:31
    Using Subdatasheets
    4:35
    Using Additional Filter and Sort Techniques
    2:29
  • Queries
    What are Queries?
    5:10
    Creating a Simple Query
    7:43
    Understanding the Dynaset
    2:59
    Entering Criteria
    7:20
    Using Wild Cards
    10:39
    Using Keywords
    6:21
    Sorting and Hiding Fields
    7:14
    Performing Multi-Table Queries
    9:36
    Querying Tips and Tricks
    7:27
  • Reports
    What are Reports?
    6:42
    Understanding Different Types of Reports
    9:47
    Designing Reports
    4:19
    Using AutoReport
    9:06
    Using the Report Wizard
    9:15
    Report Design View
    10:25
    Creating Labels
    5:58
    Reports Additional Tips and Gotchas
    10:08
  • Forms
    What are Forms?
    4:41
    Understanding Form Types
    4:48
    Creating Forms
    4:48
    Navigating in the form
    3:43
    Editing Data in a Form
    4:14
    Using the Form Wizard
    6:46
    Using the Form Design View
    9:37
    Working with Bound and Unbound Controls
    4:32
    Selecting Moving and Resizing Controls
    6:53
    Deleting Controls and Adding Fields
    5:18
    Using the Form Layout View
    5:09
    Working with Forms Tips and Tricks
    9:31
  • Conclusion
    Course Recap
    1:31

Skills

  • Microsoft Access

Similar Courses

More Courses by this Instructor