O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Access 2010 Introduction

Video Description

This course covers the basics functions of Access 2010. After an introduction to database concepts and the Access environment and Help systems, you will learn how to open and use existing databases and design and create databases. Next, you will work with tables, fields, and records; sort, search and filter data; and set field properties and data entry rules. You also will learn to create queries, forms, and reports.

Table of Contents

  1. Introduction
    1. Introduction 00:01:40
  2. Introducing Access 2010
    1. Using the File tab 00:01:04
    2. Using Templates 00:05:26
    3. Reviewing the Ribbon 00:16:06
    4. Customizing the Quick Access Toolbar 00:03:17
    5. Understanding the Navigation Pane 00:04:59
  3. Opening an Existing Database
    1. Opening a Database 00:04:13
    2. Using the Navigation Pane 00:03:57
    3. Reviewing the Anatomy of a Table 00:07:12
    4. Adding a Record 00:04:46
    5. Using the Navigation Buttons 00:02:24
    6. Using the Search Text Box 00:01:22
    7. Using the Field Quick Filter button 00:08:03
    8. Reordering Columns 00:05:15
  4. Creating a New Database
    1. Creating a New Table in Design View 00:04:14
    2. Understanding the Table Design View 00:05:45
    3. Understanding the Different Data Types 00:10:00
    4. Adding Fields 00:06:40
    5. Adding Calculated Fields 00:05:29
    6. Adding and Validating Record Data 00:03:11
    7. Using the Data Sheet View 00:01:58
    8. Adding Pre-Defined Fields 00:02:17
    9. Modifying Fields 00:06:06
  5. Working With the Table
    1. Using the Find Dialog Box 00:07:51
    2. Searching With Wildcards 00:04:53
    3. Using the Replace 00:05:03
    4. Adding Totals 00:04:33
    5. Understanding Table Relationships 00:00:59
    6. Adding the Subdatasheet 00:04:57
  6. Creating a Select Query
    1. Using the Query Wizard 00:09:01
    2. Using the Query Design View 00:08:54
    3. Setting Query Criteria 00:10:40
    4. Creating a New Query 00:06:51
    5. Using Range Operators 00:12:54
  7. Creating Simple Forms
    1. Creating Simple Forms Using the Form Wizard 00:04:33
    2. Understanding the Form Design View 00:02:58
    3. Selecting, Moving and Resizing Controls 00:15:05
    4. Creating a Simple Form Using the Form Button 00:06:54
    5. Using Labels 00:04:02
    6. Formatting Controls 00:03:15
    7. Setting Tab Order 00:06:13
  8. Creating Simple Reports
    1. Creating Simple Reports Using the Report Wizard 00:07:08
    2. Selecting, Moving and Resizing Controls 00:04:23
    3. Using Report Bands 00:02:28
    4. Using Groups 00:01:28
    5. Using Controls 00:04:25
    6. Changing the Page Layout 00:12:35
  9. Conclusion
    1. Conclusion 00:02:45