O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Access 2007: Essentials

Video Description

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.

Table of Contents

  1. CHAPTER 1: INTRODUCING ACCESS 2007
    1. Head 00:01:00
    2. Defining a Database 00:03:28
    3. Knowing When to Use Access™ 00:02:41
    4. Working with Database Objects 00:03:11
    5. Converting Older Databases 00:07:10
  2. CHAPTER 2: EXPLORING THE NEW USER INTERFACE
    1. Head 00:00:25
    2. Exploring the Getting Started Screen 00:05:18
    3. Opening a Microsoft Template 00:03:55
    4. Using the Navigation Pane 00:03:26
    5. Using the Home Tab, Part 1 00:08:04
    6. Using the Home Tab, Part 2 00:05:20
    7. Using the Create Tab 00:02:58
    8. Using the External Data Tab 00:05:43
    9. Using the Database Tools Tab 00:03:58
    10. Using the Office Menu 00:05:45
    11. Explaining the Access Options 00:08:28
    12. Using the Quick Access Toolbar 00:05:10
    13. Adding Custom Commands to the Quick Access Toolbar 00:06:02
    14. Using the Help Menu 00:05:59
    15. Understanding the Message Bar 00:02:46
    16. Creating Trusted Locations 00:04:18
    17. Working in the Object Window 00:06:09
  3. CHAPTER 3: WORKING IN THE NAVIGATION PANE
    1. Head 00:00:24
    2. Displaying Categories 00:07:20
    3. Showing Views 00:03:13
    4. Sorting the Objects 00:04:51
    5. Searching for Objects 00:03:21
    6. Collapsing Groups 00:02:37
    7. Creating Custom Groups 00:07:28
    8. Adding Object Shortcuts 00:06:17
    9. Hiding Custom Groups 00:05:02
    10. Changing the Interface Mode 00:03:18
    11. Final Comments & Credits 00:01:47
  4. CHAPTER 4: CREATING TABLES
    1. Head 00:00:36
    2. Explaining the Datasheet Tab 00:04:02
    3. Entering Data in a New Table 00:07:19
    4. Using a Table Template 00:06:10
    5. Identifying the Entities 00:05:13
    6. Working with Design View 00:05:44
    7. Creating DataTypes 00:05:20
    8. Using Field Validation Rules 00:05:17
    9. Defining Primary Keys 00:07:19
    10. Adding Indexes 00:06:34
    11. Working with Table Relationships 00:04:26
    12. Creating Table Relationships 00:04:16
    13. Defining Multi-Value Field Lookups 00:05:16
  5. CHAPTER 5: CREATING QUERIES
    1. Head 00:00:23
    2. Creating a Select Query 00:08:58
    3. Using Expressions in a Query 00:06:47
    4. Sorting Data 00:04:02
    5. Searching for Data 00:04:51
    6. Selecting Data from Many Tables 00:02:40
    7. Working in Layout View 00:03:26
    8. Working in SQL View 00:03:41
    9. Creating a Crosstab Query 00:04:28
    10. Running Action Queries 00:04:10
    11. Running Update Queries 00:03:43
    12. Using the Query Wizard 00:03:28
  6. CHAPTER 6: CREATING FORMS
    1. Head 00:00:24
    2. Using Quick Create Commands 00:03:36
    3. Exploring Form Types 00:02:41
    4. Navigating within Forms 00:03:50
    5. Using the Form Wizard 00:05:04
    6. Creating a Form from Scratch 00:05:13
    7. Working in Layout View 00:03:58
    8. Working in Design View 00:03:05
    9. Setting Form Properties 00:03:14
    10. Using Form Controls 00:05:16
    11. Using Control Layouts 00:05:07
    12. Applying AutoFormats 00:03:26
    13. Understanding Subforms 00:03:26
  7. CHAPTER 7: CREATING REPORTS
    1. Head 00:00:20
    2. Using the Report Command 00:03:10
    3. Running the Report Wizard 00:08:55
    4. Exploring Report Views 00:03:49
    5. Creating a Report from Scratch 00:05:22
    6. Using Conditional Formatting 00:05:10
    7. Grouping & Sorting 00:06:57
    8. Setting Report Properties 00:03:07
    9. Detailing Your Report 00:04:25
    10. Applying AutoFormats 00:02:34
    11. Adding Subreports 00:04:03
    12. Alternating Record Colors 00:01:45
    13. Filtering in Report View 00:03:24
    14. Creating Labels 00:04:42
  8. CHAPTER 8: CREATING MACROS
    1. Head 00:00:25
    2. Working in Macro Design Mode 00:03:56
    3. Assigning Macro Actions 00:02:39
    4. Setting Macro Arguments 00:04:25
    5. Running an AutoExec Macro 00:06:45
    6. Creating Embedded Macros 00:06:02
    7. Final Comments & Credits 00:02:01