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 2010

Video Description

As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entrylevel database application software. Don't let the words 'entrylevel' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entrylevel database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010. Click the movie links below to get started now!

Table of Contents

  1. Introduction
    1. Welcome 00:01:31
    2. Course Objectives 00:02:20
    3. Course Structure 00:03:21
    4. What is Access? 00:05:37
    5. New in 2010 00:03:36
  2. Database Basics
    1. What is a Database? 00:03:24
    2. Database Types 00:03:22
    3. Database Objects 00:03:46
    4. Tables 00:04:07
    5. Data Types 00:03:55
    6. Primary Key 00:04:18
    7. Indexes 00:04:27
  3. Database Design Basics
    1. What is Normalization? 00:05:26
    2. Normalization Benefits 00:02:27
    3. Understanding Relationships 00:03:28
    4. Relationship Types pt. 1 00:03:22
    5. Relationship Types pt. 2 00:02:29
    6. Relationship Types pt. 3 00:04:35
    7. Understanding Integrity 00:03:23
  4. Access 2010 Basics
    1. What Can I Do with Access? 00:04:59
    2. Access Database Objects 00:05:04
    3. Opening Access 2010 00:04:35
    4. Creating a Database 00:03:34
    5. Getting Around in Access 00:06:16
    6. Where to Really Start 00:06:24
  5. Working with Tables
    1. Creating Our Database 00:03:48
    2. Quick Access Toolbar Shortcut 00:02:03
    3. Datasheet or Design? 00:03:44
    4. Access Data Types 00:03:25
    5. Field Size Settings 00:05:25
    6. Date/Time Formats 00:02:58
    7. Custom Date/Time Formats 00:04:32
    8. Creating Our Tables 00:05:57
    9. Required Fields 00:03:05
    10. Deleting Rows 00:01:37
    11. Input Masks 00:03:30
    12. Setting the Field Size 00:03:21
    13. Default Values 00:03:45
    14. Allow Zero Length 00:05:38
    15. Renaming Fields and Tables 00:03:42
    16. Editing a Table 00:05:15
    17. Data Validation 00:05:57
    18. Adding an Index 00:05:36
    19. Deleting a Table 00:03:22
    20. Using Caption 00:02:38
    21. Using the Data Documenter 00:05:32
  6. Relationships
    1. Determining Relationships 00:04:38
    2. Creating a Relationship 00:05:12
    3. Relationship Options 00:05:57
    4. Relationship Reports 00:02:58
  7. Working with Datasheet View
    1. Using Auto Numbering 00:04:50
    2. Adding Data to the Table 00:04:13
    3. Using Data Lookups 00:06:34
    4. Datasheet View Basics 00:05:28
    5. Replacing Values 00:04:04
    6. Datasheet Formatting 00:02:43
    7. Filter By Form 00:03:23
    8. Freezing and Thawing 00:02:27
  8. Accessing Your Data
    1. Query Basics 00:05:24
    2. Access and SQL 00:04:44
    3. Access 2010 Query Types 00:05:33
    4. Using the Query Wizard 00:04:28
    5. Using the Query Design View 00:05:03
    6. Writing Queries in SQL 00:05:09
    7. Total Queries 00:05:37
    8. Make Table Queries 00:05:18
    9. Action Queries 00:05:12
    10. Crosstab Queries 00:05:56
    11. Union Queries 00:04:48
    12. Top Queries 00:04:10
    13. Multi-Table Queries 00:06:40
    14. Understanding Query Joins 00:05:45
    15. Distinct Queries 00:03:20
  9. Data Forms
    1. Access 2010 Forms 00:03:21
    2. Why Use Forms? 00:03:59
    3. Using AutoForm 00:03:21
    4. Using the Form Wizard 00:04:32
    5. Starting from Scratch 00:06:44
    6. Layout or Design View? 00:05:07
    7. Form Controls 00:03:00
    8. Adding Controls 00:06:27
    9. Using the Control Wizard 00:06:30
    10. Control Properties 00:04:22
    11. Using Combo Boxes pt. 1 00:05:48
    12. Using Combo Boxes pt. 2 00:04:37
    13. Navigation Form 00:03:55
    14. Setting the Tab Order 00:03:34
    15. Creating a Pop-up Form pt. 1 00:03:25
    16. Creating a Pop-up Form pt. 2 00:04:21
  10. Access 2010 Reports
    1. Report Basics 00:05:04
    2. Report Types 00:03:11
    3. Reports the Easy Way 00:03:12
    4. Reports the Wizard Way 00:05:57
    5. Reports the Real Way 00:04:34
    6. Finding the Data 00:04:20
    7. Basic Report Design 00:04:36
    8. Sorting and Grouping Data 00:04:36
    9. Report Headers 00:05:15
    10. Group and Sum Totals 00:06:00
    11. Using Expressions 00:04:21
    12. Report Cosmetics pt. 1 00:06:38
    13. Report Cosmetics pt. 2 00:07:00
    14. Report Cosmetics pt. 3 00:04:48
  11. External Data
    1. You Need It Where? 00:03:29
    2. Exporting Data 00:06:41
    3. Importing Data 00:06:14
    4. Linking to Data 00:04:52
    5. Linking Issues 00:04:19
  12. Multi-user Access Applications
    1. Multi-User Application Basics 00:04:37
    2. Network Performance Issues 00:04:04
    3. Splitting the Database 00:03:23
    4. Pass-Through Queries 00:03:51
    5. Database Locking 00:06:35
  13. More Cool Access Stuff
    1. Copying Tables 00:02:53
    2. Access Analyzer Tools 00:04:23
    3. Database Backups 00:01:30
    4. Pivot Tables and Charts 00:05:34
    5. Intro to Macros and Events 00:05:48
    6. Intro to VBA 00:06:22
  14. Conclusion
    1. Course Wrap Up 00:04:27
  15. Credits
    1. About the Author 00:01:59