Free Trial

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

Overview

Explore the endless capabilities of Access 2007. These lessons, hosted by Jeff Conrad begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases. Once you're up to speed on the intricacies of Access, Jeff walks you through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.

Subscriber Reviews

Average Rating: 2.6 out of 5 rating Based on 5 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

CHAPTER 1: INTRODUCING ACCESS 2007

Head

Play Video

00:00:59

Defining a Database

Play Video

00:03:27

Knowing When to Use Access™

Preview

00:02:40

Working with Database Objects

Preview

00:03:10

Converting Older Databases

Preview

00:07:09

CHAPTER 2: EXPLORING THE NEW USER INTERFACE

Head

Preview

00:00:24

Exploring the Getting Started Screen

Preview

00:05:17

Opening a Microsoft Template

Preview

00:03:55

Using the Navigation Pane

Preview

00:03:25

Using the Home Tab, Part 1

Preview

00:08:04

Using the Home Tab, Part 2

Preview

00:05:19

Using the Create Tab

Preview

00:02:57

Using the External Data Tab

Preview

00:05:42

Using the Database Tools Tab

Preview

00:03:57

Using the Office Menu

Preview

00:05:44

Explaining the Access Options

Preview

00:08:27

Using the Quick Access Toolbar

Preview

00:05:09

Adding Custom Commands to the Quick Access Toolbar

Preview

00:06:01

Using the Help Menu

Preview

00:05:58

Understanding the Message Bar

Preview

00:02:45

Creating Trusted Locations

Preview

00:04:18

Working in the Object Window

Preview

00:06:08

CHAPTER 3: WORKING IN THE NAVIGATION PANE

Head

Preview

00:00:23

Displaying Categories

Preview

00:07:19

Showing Views

Preview

00:03:13

Sorting the Objects

Preview

00:04:50

Searching for Objects

Preview

00:03:20

Collapsing Groups

Preview

00:02:37

Creating Custom Groups

Preview

00:07:27

Adding Object Shortcuts

Preview

00:06:17

Hiding Custom Groups

Preview

00:05:02

Changing the Interface Mode

Preview

00:03:18

Final Comments & Credits

Preview

00:01:46

CHAPTER 4: CREATING TABLES

Head

Preview

00:00:36

Explaining the Datasheet Tab

Preview

00:04:01

Entering Data in a New Table

Preview

00:07:18

Using a Table Template

Preview

00:06:09

Identifying the Entities

Preview

00:05:12

Working with Design View

Preview

00:05:43

Creating DataTypes

Preview

00:05:19

Using Field Validation Rules

Preview

00:05:16

Defining Primary Keys

Preview

00:07:19

Adding Indexes

Preview

00:06:33

Working with Table Relationships

Preview

00:04:26

Creating Table Relationships

Preview

00:04:15

Defining Multi-Value Field Lookups

Preview

00:05:15

CHAPTER 5: CREATING QUERIES

Head

Preview

00:00:22

Creating a Select Query

Preview

00:08:58

Using Expressions in a Query

Preview

00:06:46

Sorting Data

Preview

00:04:01

Searching for Data

Preview

00:04:50

Selecting Data from Many Tables

Preview

00:02:40

Working in Layout View

Preview

00:03:26

Working in SQL View

Preview

00:03:40

Creating a Crosstab Query

Preview

00:04:28

Running Action Queries

Preview

00:04:10

Running Update Queries

Preview

00:03:43

Using the Query Wizard

Preview

00:03:27

CHAPTER 6: CREATING FORMS

Head

Preview

00:00:24

Using Quick Create Commands

Preview

00:03:35

Exploring Form Types

Preview

00:02:40

Navigating within Forms

Preview

00:03:50

Using the Form Wizard

Preview

00:05:03

Creating a Form from Scratch

Preview

00:05:12

Working in Layout View

Preview

00:03:57

Working in Design View

Preview

00:03:04

Setting Form Properties

Preview

00:03:14

Using Form Controls

Preview

00:05:15

Using Control Layouts

Preview

00:05:07

Applying AutoFormats

Preview

00:03:25

Understanding Subforms

Preview

00:03:25

CHAPTER 7: CREATING REPORTS

Head

Preview

00:00:19

Using the Report Command

Preview

00:03:10

Running the Report Wizard

Preview

00:08:54

Exploring Report Views

Preview

00:03:48

Creating a Report from Scratch

Preview

00:05:21

Using Conditional Formatting

Preview

00:05:10

Grouping & Sorting

Preview

00:06:56

Setting Report Properties

Preview

00:03:06

Detailing Your Report

Preview

00:04:24

Applying AutoFormats

Preview

00:02:34

Adding Subreports

Preview

00:04:03

Alternating Record Colors

Preview

00:01:45

Filtering in Report View

Preview

00:03:23

Creating Labels

Preview

00:04:41

CHAPTER 8: CREATING MACROS

Head

Preview

00:00:24

Working in Macro Design Mode

Preview

00:03:55

Assigning Macro Actions

Preview

00:02:38

Setting Macro Arguments

Preview

00:04:25

Running an AutoExec Macro

Preview

00:06:44

Creating Embedded Macros

Preview

00:06:01

Final Comments & Credits

Preview

00:02:00

Extras

The publisher has provided additional content related to this title.


Description
Content

Exercise file

  • TAX07ES_P01_PF.zip

Exercise file

  • TAX07ES_P01_PF.sit