Using Microsoft Access 2010brings you over 80 media elements detailing everything from how to manipulate data and tables to working with web databases and sharing data with other applications. Watching these videos and listening to the audio sidebars is the fastest way to get comfortable with the newest version of Microsoft Access. Topics covered include using queries, forms, reports, creating your own databases and tables, working with cascade …
Using Microsoft Access 2010brings you over 80 media elements detailing everything from how to manipulate data and tables to working with web databases and sharing data with other applications. Watching these videos and listening to the audio sidebars is the fastest way to get comfortable with the newest version of Microsoft Access. Topics covered include using queries, forms, reports, creating your own databases and tables, working with cascade update and cascade delete, creating calculated fields with the expression builder, automating your database with macros, linking to SQL Server databases, publishing your database to Access Services, and much, much more!
Chapter 1: Manipulating Data with Databases and Table
SHOW ME Media 1.1—Viewing and Navigating Table Data 00:03:03
SHOW ME Media 1.2—Editing Existing Records 00:01:54
SHOW ME Media 1.3—Adding Records to a Table 00:01:18
SHOW ME Media 1.4—Selecting and Deleting Records 00:01:05
SHOW ME Media 1.5—Filtering by Selection 00:01:24
TELL ME MORE Media 1.6—What’s Stored in a Database 00:04:37
Chapter 2: Using Queries to Retrieve the Data You Need
SHOW ME Media 2.1—Selecting Fields 00:02:00
SHOW ME Media 2.2—Ordering the Query Result 00:02:06
SHOW ME Media 2.3—Refining Queries with Criteria 00:04:46
SHOW ME Media 2.4—Building a Query Based on Multiple Tables 00:04:11
TELL ME MORE Media 2.5—Updatability of Query Results 00:05:25
Chapter 3: Using Forms to Enter and Edit Table Data
SHOW ME Media 3.1—Working with Data 00:04:56
SHOW ME Media 3.2—Filtering Form Data 00:03:09
SHOW ME Media 3.3—Viewing the Design of a Form 00:02:14
SHOW ME Media 3.4—Using a Form Wizard 00:02:15
SHOW ME Media 3.5—Taking Advantage of Conditional Formatting 00:03:15
TELL ME MORE Media 3.6—Uses for Forms 00:03:26
Chapter 4: Using Reports to Print Information
SHOW ME Media 4.1—Opening and Viewing a Report 00:02:12
SHOW ME Media 4.2—Printing a Report 00:01:54
SHOW ME Media 4.3—AutoReports and the Report Wizard 00:02:57
SHOW ME Media 4.4—Viewing the Design of a Report 00:02:23
TELL ME MORE Media 4.5—Types of Reports Available 00:04:29
Chapter 5: Creating Your Own Databases and Tables
SHOW ME Media 5.1—Creating a Database 00:01:15
SHOW ME Media 5.2—Designing a Table from a Datasheet 00:05:08
SHOW ME Media 5.3—Designing a Table from Scratch 00:03:38
SHOW ME Media 5.4—Creating Indexes 00:02:15
SHOW ME Media 5.5—Working with Field Properties 00:03:20
TELL ME MORE Media 5.6—The All-Important Primary Key 00:04:03
Chapter 6: Relating the Information in Your Database
SHOW ME Media 6.1—Establishing a Relationship Between Two Tables 00:02:22
SHOW ME Media 6.2—Modifying Existing Relationships 00:00:36
SHOW ME Media 6.3—Working with Cascade Update and Cascade Delete 00:03:52
TELL ME MORE Media 6.4—The Importance of Relationships 00:03:50
Chapter 7: Enhancing the Queries That You Build
SHOW ME Media 7.1—Adding Fields to Queries 00:03:24
SHOW ME Media 7.2—Moving Fields on the Query Grid 00:01:31
SHOW ME Media 7.3—Ordering Query Results 00:01:56
SHOW ME Media 7.4—Refining a Query with Criteria 00:05:15
SHOW ME Media 7.5—Updating Query Results 00:01:13
SHOW ME Media 7.6—AutoLookup in Multitable Queries 00:01:36
SHOW ME Media 7.7—Creating Calculated Fields within the Expression Builder 00:03:29
SHOW ME Media 7.8—Creating and Running Parameter Queries 00:03:01
SHOW ME Media 7.9—Creating and Running Action Queries 00:06:11
SHOW ME Media 7.10—Using Aggregate Functions to Summarize Data 00:04:17
SHOW ME Media 7.11—Working with Outer Joins 00:03:04
TELL ME MORE Media 7.12—Building Queries Based on Multiple Tables 00:02:44
Chapter 8: Building Powerful Forms
SHOW ME Media 8.1—Working with Controls 00:07:47
SHOW ME Media 8.2—Conditional Formatting 00:03:05
SHOW ME Media 8.3—Working with Form Properties 00:05:35
SHOW ME Media 8.4—Working with Control Properties 00:05:38
SHOW ME Media 8.5—Working with Combo Boxes 00:04:43
SHOW ME Media 8.6—The Command Button Wizard 00:03:02
SHOW ME Media 8.7—Building a One-to-Many Form by Using the Form Wizard 00:02:54
SHOW ME Media 8.8—Building a One-to-Many Form by Using the Subform Wizard 00:03:23
SHOW ME Media 8.9—Working with Subforms 00:01:46
TELL ME MORE Media 8.10—The Command Button Wizard: Programming Without Typing 00:02:53
Chapter 9: Building Powerful Reports
SHOW ME Media 9.1—Working with Controls 00:06:41
SHOW ME Media 9.2—Basing Reports on Multiple Tables 00:06:12
SHOW ME Media 9.3—Working with Subreports 00:00:59
SHOW ME Media 9.4—Working with Sorting and Grouping 00:06:35
SHOW ME Media 9.5—Taking Advantage of Report Properties 00:02:34
TELL ME MORE Media 9.6—Improving Performance and Reusability by Basing Reports on Stored Queries 00:04:09
Chapter 10: Automating Your Database with Macros
SHOW ME Media 10.1—The Basics of Creating and Running a Macro 00:08:06
SHOW ME Media 10.2—Ways You Can Launch an Access Macro 00:05:50
SHOW ME Media 10.3—Modifying an Existing Macro 00:02:38
SHOW ME Media 10.4—Creating an Embedded Macro 00:02:42
SHOW ME Media 10.5—Creating a Data Macro 00:05:31
SHOW ME Media 10.6—Creating a Drillthrough Macro 00:02:49
SHOW ME Media 10.7—Testing a Macro 00:02:21
SHOW ME Media 10.8—Converting a Macro to VBA Code 00:02:58
SHOW ME Media 10.9—Creating an AutoExec Macro 00:01:40
TELL ME MORE Media 10.10—When Should You Use Macros and When Shouldn’t You 00:02:48
Chapter 11: Sharing Data with Other Applications
SHOW ME Media 11.1—Exporting to Another Access Database 00:01:54
SHOW ME Media 11.2—Exporting to an Excel Spreadsheet 00:02:38
SHOW ME Media 11.3—Importing from Another Access Database 00:01:20
SHOW ME Media 11.4—Importing Spreadsheet Data 00:02:40
SHOW ME Media 11.5—Linking to Tables in Another Access Database 00:01:39
SHOW ME Media 11.6—Linking to Another Type of Database 00:01:30
SHOW ME Media 11.7—Linking to SQL Server Databases 00:03:38
SHOW ME Media 11.8—The Linked Table Manager 00:01:50
TELL ME MORE Media 11.9—Practical Applications of Working with External Data 00:06:15
Chapter 12: Working with Web Databases
SHOW ME Media 12.1—Creating a Blank Web Database 00:01:50
SHOW ME Media 12.2—Creating Publishable Objects 00:06:09
SHOW ME Media 12.3—Publishing Your Database to Access Services 00:01:13
TELL ME MORE Media 12.4—The Pros and Cons of Using a Web Database 00:02:46