Access 2013

Office Basics

• 1

  Buying Office

  

  • Introduction

  • Office 2013 purchasing options

  • Office for other devices

• 2

  Understanding Office 365

  

  • All about Office 365

  • Managing your Office 365 subscription

Access Basics

• 3

  Introduction to Databases

  

  • Introduction

  • Why use a database?

  • Taking the Access 2013 tutorial

  

  • Introduction to Databases

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

    03:45136,643 views
• 4

  Introduction to Objects

  

  • Introduction

  • 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,374 views
• 5

  Getting Started with Access

  

  • Introduction

  • Working with your Access environment

  • Backstage view

  • The Navigation pane

  • Databases with navigation forms

  • Challenge!

  

  • Getting Around in Access 2013

    Get to know Access 2013, including the Ribbon, Backstage View, Navigation Pane, and more.

    04:163,120 views
• 6

  Managing Databases and Objects

  

  • Introduction

  • Working with objects

  • Challenge!

  

  • Working with Databases

    Ways to open and manage databases and objects.

    02:412,460 views

Working with Data

• 7

  Working with Tables

  

  • Introduction

  • Adding records and entering data

  • Editing records

  • Modifying table appearance

  • Table formatting options

  • Challenge!

  

  • Working with Tables

    Learn the basics of opening and editing tables.

    04:252,448 views

  • Customizing Tables

    How to resize and hide fields in your table, and customize the colors.

    02:381,606 views
• 8

  Working with Forms

  

  • Introduction

  • Working with forms

  • Using form features

  • Challenge!

  

  • Working with Forms

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

    04:552,231 views
• 9

  Sorting and Filtering Records

  

  • Introduction

  • Filtering records

  • Creating a filter from a search term

  • Challenge!

  

  • Sorting and Filtering

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

    04:071,809 views

Running Queries and Reports

• 10

  Designing a Simple Query

  

  • Introduction

  • One-table queries

  • Challenge!

  

  • Designing a Simple Query

    Learn how to create a simple query using a single table.

    05:082,095 views
• 11

  Designing a Multi-Table Query

  

  • Introduction

  • Planning our query

  • Joining tables in queries

  • Creating a multi-table query

  • Challenge!

  

  • Multi-Table Queries (Part 1)

    Learn how to design a query that uses multiple tables.

    05:321,564 views

  • Multi-Table Queries (Part 2)

    Learn more about multi-table queries, including the types of joins that you can use.

    03:42743 views
• 12

  More Query Design Options

  

  • Introduction

  • Sorting queries

  • Hiding fields within queries

  • More types of queries

  • More query options

  • Challenge!

  

  • Modifying Queries

    Learn how to customize your queries by sorting and filtering by different criteria.

    02:361,384 views

  • Creating a Totals Query

    Use SUM and other functions to combine similar results in your queries.

    02:371,956 views
• 13

  Creating Reports

  

  • Introduction

  • Printing and saving reports in Print Preview

  • Challenge!

  

  • Creating Reports

    Make your data easier to read by turning it into a report.

    02:541,740 views

  • Printing Reports

    Learn how to adjust the layout of your reports to prepare them for printing.

    02:511,210 views
• 14

  Advanced Report Options

  

  • Introduction

  • Formatting reports

  • Modifying your report's appearance

  • Challenge!

  

  • Using the Report Wizard

    Learn how to use the Report Wizard to create reports from multiple tables or queries.

    03:381,168 views

  • Formatting Reports

    Learn how to customize your reports by adding headers and footers, changing the colors, and more.

    04:20750 views

Database Design Tips

• 15

  Modifying Tables

  

  • Introduction

  • Advanced field options

  • More table options

  • Challenge!

• 16

  Creating Forms

  

  • Introduction

  • Adding additional fields to a form

  • Adding design controls

  • Customizing form settings with the Property Sheet

  • Challenge!

  

  • Creating Forms

    Learn how to create and modify forms to make your database easier to use.

    04:09952 views

  • Customizing Form Settings

    Learn how to use the Property Sheet to change how your form works.

    03:331,741 views
• 17

  Formatting Forms

  

  • Introduction

  • Modifying form layout

  • More formatting options

  • Challenge!

  

  • Formatting Forms

    Change the appearance of your forms by adding buttons, images, and more.

    04:241,584 views
• 18

  Designing Your Own Database

  

  • Introduction

  • More resources on database design

More Access Tasks

• 19

  Creating Calculated Fields and Totals Rows

• 20

  Creating a Parameter Query

• 21

  Creating a Find Duplicates Query

Extras

• Query Criteria Quick Reference Guide

• Quiz

Learn More

• Access 2010

• OneDrive and Office Online

• Tech Savvy Tips and Tricks

• Access 2007