Access 2010

Access Basics

• 1

  Introduction to Databases

  

  • Introduction

  • What is a database?

  • Why use a database?

  • Taking the Access 2010 tutorial

  

  • Introduction to Databases

    What exactly is a database? Learn everything you need to know before diving into Access.

    03:45136,636 views
• 2

  Introduction to Objects

  

  • Introduction

  • The Access objects

  • Forms, queries, and reports

  • Putting it all together

  

  • Introduction to Objects

    Learn what makes up an Access database, and how these objects work together.

    04:5629,371 views
• 3

  Getting Started in Access

  

  • Introduction

  • Getting to know Access 2010

  • Working with your Access environment

  • Backstage view

  • The Navigation Pane

  • Databases with navigation forms

  • Challenge!

  

  • Getting Around in Access 2010

    Learn the basics of opening and editing tables.

    04:3725,011 views
• 4

  Managing Databases and Objects

  

  • Introduction

  • Opening and closing databases

  • Working with objects

  • Challenge!

  

  • Working with Databases in Access 2010

    Learn the basics of managing databases and objects.

    02:5514,946 views

Working With Data

• 5

  Working with Tables

  

  • Introduction

  • Table basics

  • Adding records and entering data

  • Editing records

  • Modifying table appearance

  • Table formatting options

  • Challenge!

  

  • Working with Tables in Access 2010

    Learn the basics of opening and editing tables.

    04:2123,613 views

  • Customizing Tables in Access 2010

    Resize and hide fields, and change the colors in your table.

    02:409,487 views
• 6

  Working with Forms

  

  • Introduction

  • Why use forms?

  • Working with forms

  • Using form features

  • Challenge!

  

  • Working with Forms in Access 2010

    Use forms to view and edit the information in one or more tables.

    04:4627,987 views
• 7

  Sorting and Filtering Records

  

  • Introduction

  • About sorting and filtering

  • Filtering records

  • Creating a filter from a search term

  • Challenge!

  

  • Sorting & Filtering in Access 2010

    Make your tables easier to read by sorting and filtering records.

    04:0717,288 views

Running Queries and Reports

• 8

  Designing a Query

  

  • Introduction

  • What are queries?

  • One-table queries

  • Designing a multi-table query

  • Planning our query

  • Joining tables in queries

  • Creating a multi-table query

  • Challenge!

  

  • Creating a Simple Query in Access 2010

    Learn how to create a simple query that uses a single table.

    05:0324,791 views

  • Multi-Table Queries in Access 2010, Part 1

    Learn how to create a query that uses multiple tables.

    05:2844,538 views

  • Multi-Table Queries in Access 2010, Part 2

    Learn about the types of joins and search criteria you can use in your queries.

    03:4627,541 views
• 9

  More Query Design Options

  

  • Introduction

  • Modifying queries

  • Sorting queries

  • Hiding fields within queries

  • More types of queries

  • More query options

  • Challenge!

  

  • Modifying Queries in Access 2010

    Create a multilevel sort, and hide fields that you don't need in your query results.

    02:3915,817 views

  • Creating a Totals Query in Access 2010

    Use a totals query to get more useful results from your query.

    02:4940,502 views
• 10

  Creating Reports

  

  • Introduction

  • Creating reports

  • Printing and saving reports in Print Preview

  • Challenge!

  

  • Creating Reports in Access 2010

    Turn a table or query into a professional-looking report.

    02:5636,209 views

  • Printing Reports in Access 2010

    Use the options in Print Preview to print or export your reports.

    02:5712,530 views
• 11

  Advanced Report Options

  

  • Introduction

  • The Report Wizard

  • Formatting Reports

  • Enhancing Report Appearance

  • Challenge!

  

  • Using the Report Wizard in Access 2010

    Learn how to use the Report Wizard to create a report with multiple tables.

    03:4013,097 views

  • Formatting Reports in Access 2010

    Change your report's fonts and themes, and add a header, footer, and logo.

    04:2418,473 views

Database Design Tips

• 12

  Modifying Tables

  

  • Introduction

  • Modifying tables

  • Advanced field options

  • More table options

  • Challenge!

  

  • Modifying Tables in Access 2010

    Choose a data type, character limit, and validation rule for the fields in your table.

    05:009,876 views
• 13

  Creating Forms

  

  • Introduction

  • Creating forms

  • Adding additional fields to a form

  • Adding Design Controls

  • Customizing form settings with the Property Sheet

  • Challenge!

  

  • Creating Forms in Access 2010

    Create a form from a table and add a combo box to make it easier to use.

    04:1458,836 views

  • Customizing Form Settings in Access 2010

    Learn how to use the Property Sheet to make detailed adjustments to your forms.

    03:3218,749 views
• 14

  Formatting Forms

  

  • Introduction

  • Formatting forms

  • Modifying form layout

  • More formatting options

  • Challenge!

  

  • Formatting Forms in Access 2010

    Make your forms look nicer by adding command buttons and adjusting the fonts and colors.

    04:2415,035 views
• 15

  Designing Your Own Database

  

  • Introduction

  • Creating a database from a template

  • More resources on database design

Extras

• Tables: How to Create Calculated Fields and Totals Rows

• Queries: How to Create a Parameter Query

• Queries: How to Create a Find Duplicates Query

• Query Criteria Quick Reference Guide

• Quiz

Learn More

• Access 2013

• OneDrive and Office Online

• Tech Savvy Tips and Tricks

• Access 2007