Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Microsoft Access 2007: Essentials

    Subscriber Reviews • Browse Similar Topics

    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.75 out of 5 rating Based on 4 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