Access 2007

Understanding Database Concepts

• 1

  Why Do I Need a Database?

  

  • Introduction

  • Why do I need a database?

  • Excel example: Customer list and order tracking

  • Access example: Customers and orders tracking

  • Challenge!

  

  • Why Do I Need a Database

    A quick look at what databases do in Access 2007

    06:134,470 views
• 2

  Exploring an Access Database

  

  • Introduction

  • Exploring databases

  • Getting started with Access

  • Opening a database

  • The Access window

  • Parts of a database

  • Parts of a database

  • Challenge!

  

  • Exploring an Access Database part 1

    Explore Access 2007 in this easy tutorial

    05:263,255 views

  • Exploring an Access Database part 2

    Part two of the exploring Access 2007 tutorial

    03:362,381 views
• 3

  Thinking about Database Design

  

  • Introduction

  • Designing a Database

  • Challenge!

  

  • Thinking about Database Design

    Learn the steps of database design in Access 2007

    04:324,793 views

Building the Database

• 4

  Setting up Tables and Fields

  

  • Introduction

  • Setting Up Tables and Fields

  • Setting up tables

  • Adding more tables to the database

  • Adding fields to a table

  • Setting the data type for a field

  • Challenge!

  

  • Setting up Tables and Fields

    Walkthrough how to setup databases in this Access 2007 tutorial

    09:334,188 views
• 5

  Building Table Relationships

  

  • Introduction

  • Building Table Relationships

  • Understanding the relationship map

  • Relating tables

  • Challenge!

  

  • Building Table Relationships

    This tutorial explains how to establish relationships between tables in Access 2007

    06:2210,232 views
• 6

  Entering and Editing Data in Tables

  

  • Introduction

  • Adding and editing data in tables

  • Data validation

  • Challenge!

  

  • Entering and Editing Data in Tables

    A brief lesson on how to add and adjust records in Access 2007

    09:3818,626 views
• 7

  Creating and Using Forms

  

  • Introduction

  • Creating and using forms

  • Creating a form

  • Using forms to enter data

  • Creating a drop-down list

  • Challenge!

  

  • Creating and Using Forms Pt. 1

    In this Access 2007 tutorial, discover how to use form properties

    03:3011,813 views

  • Creating and Using Forms Pt. 2

    Learn how to create and edit a basic form, and how to add a drop-down list.

    06:501,323 views
• 8

  Making Forms More Usable with Controls

  

  • Introduction

  • Making Forms More Usable

  • Challenge!

  

  • Making Forms with Controls

    An easy tutorial on how to modify forms in Access 2007

    
• 9

  Making Forms Attractive

  

  • Introduction

  • Making forms more attractive

  • Adding a logo

  • Applying a style with AutoFormat

  • Working with titles

  • Working with objects on a form

  • Challenge!

  

  • Making Forms Attractive

    Learn how to modify a form layout in Access 2007

    03:463,990 views

Analyzing and Reporting Data

• 10

  Sorting Records

  

  • Introduction

  • Sorting Records

  • Sorting on Text Values

  • Sorting on numerical values

  • Challenge!

  

  • Sorting Records

    A quick look at how to sort text based and numeric data in this Access 2007 tutorial

    03:442,060 views
• 11

  Filtering Records

  

  • Introduction

  • Filtering records

  • Filter by Field

  • Filter by Selection

  • Advanced filters

  • Challenge!

  

  • Filtering Records

    Explore easy ways to filter data in databases in this Access 2007 tutorial

    07:223,397 views
• 12

  Using Queries to Make Data Meaningful - Part 1

  

  • Introduction

  • Using Queries - Part 1

  • Planning a query

  • Using the Query Design command

  • Hiding fields or other information in the results

  • Saving the query

  • Challenge!

  

  • Using Queries Part 1

    Discover how to use query design and more in this Access 2007 tutorial

    05:362,301 views
• 13

  Using Queries to Make Data Meaningful - Part 2

  

  • Introduction

  • Using Queries - Part 2

  • Using Count and Group By in a query

  • Sorting and filtering query results

  • Challenge!

  

  • Using Queries Part 2

    Get help with how to run queries that include totals in this Access 2007 tutorial

    04:561,989 views
• 14

  Using Reports to Make Data Meaningful to Others

  

  • Introduction

  • Using reports to make data meaningful to others

  • Creating a report based on a table

  • Creating a report based on a query

  • Grouping items on a report

  • Formatting a report in Layout View

  • Saving a report

  • Challenge!

  

  • Using Reports

    Learn how to create reports in this Access 2007 tutorial

    07:122,068 views

Extras

• Quiz

Learn More

• Access 2013

• OneDrive and Office Online

• Tech Savvy Tips and Tricks

• Access 2010