Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

Not too long ago, databases were on mainframes and only skilled personnel were allowed to work with them. For most, that meant a lot of frustration both trying to communicate what was needed and then waiting to actually get it. Today, databases have come to the desktop so anyone with basic computing skills can organize, manage and retrieve their data. Doing so well and efficiently does require a basic understanding of what a relational database is and how to properly design and use one. In this series, we'll investigate those essentials skills for Microsoft Access 2010. We'll build a database from the ground up! We'll learn the basics of design and then get right to work making tables, queries, forms and reports. When we're done, you'll not only be able to enter data and open reports in Access you'll be able to design and structure it so it meets the needs of both you and your data, right from your desktop!

Subscriber Reviews

Average Rating: 4.75 out of 5 rating Based on 4 Ratings

"Outstanding & Exceptional!!" - by geekmee on 29-DEC-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
One of the best delivered training tutorials I have viewed as a 15 year plus end user trainer.

*Holds your attention
*Excellent delivery & energy
Carefully crafted delivery but conversational.
Delivery is well worded and carefully crafted around
concepts, as opposed to click here.

*Appropriate terminology.
*Explanation [framed] issues.
Understands her target audience, and framed issues
appropriately.

Report as Inappropriate

Table of Contents

Chapter/Selection

Time

GETTING TO KNOW ACCESS 2010

INTRODUCTION

Play Video

00:00:05

Relational Database Overview

Play Video

00:14:03

Access Components

Play Video

00:08:03

Planning a Database

Play Video

00:12:24

Creating Our Database Plan

Play Video

00:14:25

Naming Conventions

Play Video

00:06:05

Creating a Database File

Play Video

00:12:13

CREATING ACCESS TABLES

INTRODUCTION

Preview

00:00:05

Leveraging Application Parts

Preview

00:05:16

Building a Table in Design View & Data Types Explained

Preview

00:15:14

Applying Field Properties

Preview

00:13:35

Relationship Review

Preview

00:10:18

Establishing Relationships

Preview

00:10:46

Creating Lookup Fields

Preview

00:12:31

Entering Table Records

Preview

00:10:27

Using the Ribbon to Edit Records

Preview

00:06:50

Managing Subdatasheets

Preview

00:04:34

HARNESSING THE POWER OF QUERIES

INTRODUCTION

Preview

00:00:05

Creating a Basic Query

Preview

00:14:48

Filtering with Criteria

Preview

00:14:20

Working with Expressions

Preview

00:05:32

Working with Totals

Preview

00:09:16

Concatenating Text

Preview

00:10:29

Changing Joins in Queries

Preview

00:09:51

Creating a Price List Query

Preview

00:07:48

Creating a Class Schedule Query Using Expression Builder

Preview

00:10:22

Creating Action Queries

Preview

00:14:37

Creating Special Select Queries with Wizards

Preview

00:08:42

CREATING FUNCTIONAL FORMS & REPORTS

INTRODUCTION

Preview

00:00:05

Creating Forms Automatically & with the Forms Wizard

Preview

00:13:14

Creating Reports with the Report Wizard

Preview

00:10:34

The Design of Forms & Reports

Preview

00:16:04

Working with Data in Forms

Preview

00:10:11

Filtering & Sorting Records in Forms

Preview

00:13:54

Customizing Report Controls & Page Setup

Preview

00:20:00

Credits

Preview

00:00:12

Extras

The publisher has provided additional content related to this title.


Description
Content

Exercise file

  • TAX10ES_P01_PF.zip