Home > Store > Data > Access

Microsoft Access 2010 LiveLessons, Downloadable Version

Microsoft Access 2010 LiveLessons, Downloadable Version

Your browser doesn't support playback of this video. Please download the file to view it.

Downloadable Video

  • Your Price: $31.99
  • List Price: $39.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Register your product to gain access to bonus material or receive a coupon.

Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

Lesson 1

Microsoft Access 2010 LiveLessons: Part 1: Office Access 2010 Introduced, Downloadable Version

Office Access 2010 Introduced
Lesson 1.         Starting Microsoft Access
Lesson 2.         Opening an Existing Database
Lesson 3.         The Access Desktop
Lesson 4.         The Navigation Pane
Lesson 5.         A Preview of the Database Components
Lesson 6.         Closing an Access Database

Duration: 00:21:09  File Size: 40 MB

Lesson 2

Microsoft Access 2010 LiveLessons: Part 2: Tables Introduced, Downloadable Version

Tables Introduced
Lesson 7.      Viewing and Navigating Table Data
Lesson 8.      Editing Table Data
Lesson 9.      Adding Records to a Table
Lesson 10.     Selecting and Deleting Records
Lesson 11.     Finding and Replacing Records
Lesson 12.     Filtering Table Data

Duration: 00:17:39  File Size: 35 MB

Lesson 3

Microsoft Access 2010 LiveLessons: Part 3: Queries Introduced, Downloadable Version

Queries Introduced
Lesson 13.     Opening a Query in Datasheet View
Lesson 14.     Opening a Query in Design View
Lesson 15.     Selecting Fields
Lesson 16.     Ordering the Query Result
Lesson 17.     Refining Queries with Criteria
Lesson 18.     Modifying the Datasheet View
Lesson 19.     Saving and Closing a Query

Duration: 00:22:54  File Size: 42 MB

Lesson 4

Microsoft Access 2010 LiveLessons: Part 4: Forms Introduced, Downloadable Version

Forms Introduced
Lesson 20.     Opening a Form
Lesson 21.     Working with Data in a Form
Lesson 22.     Sorting Form Data
Lesson 23.     Filtering the Data Underlying a Form
Lesson 24.     Viewing the Design of a Form
Lesson 25.     Using the AutoForm Feature
Lesson 26.     Using a Form Wizard
Lesson 27.     Taking Advantage of Conditional Formatting

Duration: 00:26:12  File Size: 43 MB

Lesson 5

Microsoft Access 2010 LiveLessons: Part 5: Reports Introduced, Downloadable Version

Reports Introduced
Lesson 28.     Opening and Viewing a Report
Lesson 29.     Printing Report Data
Lesson 30.     AutoReports and the Report Wizard
Lesson 31.     Viewing the Design of a Report

Duration: 00:13:01  File Size: 23 MB

Lesson 6

Microsoft Access 2010 LiveLessons: Part 6: Creating Your Own Databases and Tables, Downloadable Version

Creating Your Own Databases and Tables
Lesson 32.     Creating a New Database
Lesson 33.     Building a New Table
Lesson 34.     Selecting the Appropriate Field Type
Lesson 35.     Creating Indexes
Lesson 36.     The All-Important Primary Key

Duration: 00:17:21  File Size: 25 MB

Lesson 7

Microsoft Access 2010 LiveLessons: Part 7: Creating Relationships, Downloadable Version

Creating Relationships
Lesson 37.     Introduction to Relational Database Design
Lesson 38.     Establishing Relationships in Access
Lesson 39.     Establishing Referential Integrity

Duration: 00:15:49  File Size: 19 MB

Lesson 8

Microsoft Access 2010 LiveLessons: Part 8: Creating Queries, Downloadable Version

Creating Queries
Lesson 40.     Advanced Criteria Techniques
Lesson 41.     Updating Query Results
Lesson 42.     Building Queries Based on Multiple Tables
Lesson 43.     Creating Calculated Fields with the Expression Builder
Lesson 44.     Creating Parameter Queries

Duration: 00:18:03  File Size: 32 MB

Lesson 9

Microsoft Access 2010 LiveLessons: Part 9: Creating Forms, Downloadable Version

Creating Forms
Lesson 45.     Working with Controls
Lesson 46.     Form Properties
Lesson 47.     Working with Combo Boxes
Lesson 48.     The Command Button Wizard: Programming without Typing
Lesson 49.     Creating One-To-Many Forms Using the Form Wizard
Lesson 50.     Creating One-To-Many Forms Using the SubForm Wizard

Duration: 00:34:58  File Size: 85 MB

Lesson 10

Microsoft Access 2010 LiveLessons: Part 10: Creating Reports, Downloadable Version

Creating Reports
Lesson 51.     Working with Report Bands
Lesson 52.     Working with Controls
Lesson 53.     Basing Reports on Multiple Tables
Lesson 54.     Adding Sorting and Grouping
Lesson 55.     Working with Report Properties
Lesson 56.     Working with Subreports
Lesson 57.     Basing Reports on Stored Queries

Duration: 00:32:39  File Size: 64 MB

Lesson 11

Microsoft Access 2010 LiveLessons: Part 11: Creating Macros, Downloadable Version

Creating Macros
Lesson 58.     The Basics of Creating a Macro
Lesson 59.     Running an Access Macro
Lesson 60.     Modifying an Existing Macro
Lesson 61.     Creating an Embedded Macro
Lesson 62.     Creating Data Macros
Lesson 63.     Creating a Drillthrough Macro
Lesson 64.     Debugging a Macro
Lesson 65.     Converting a Macro to VBA Code
Lesson 66.     Creating an AutoExec Macro

Duration: 00:39:52  File Size: 68 MB

Lesson 12

Microsoft Access 2010 LiveLessons: Part 12: Power Techniques, Downloadable Version

Power Techniques
Lesson 67.     Working with Field Properties
Lesson 68.     Working with Table Properties
Lesson 69.     Creating and Running Action Queries
Lesson 70.     Using Aggregate Functions to Summarize Numeric Data
Lesson 71.     Working with Outer Joins and Self Joins
Lesson 72.     Refining Queries with Field, Field List, and Query Properties
Lesson 73.     Control Properties and Why to Use Them
Lesson 74.     Bound, Unbound, and Calculated Controls
Lesson 75.     Control Properties and Why to Use Them
Lesson 76.     Inserting Page Breaks
Lesson 77.     Bound, Unbound, and Calculated Controls

Duration: 00:51:30  File Size: 94 MB

Lesson 13

Microsoft Access 2010 LiveLessons: Part 13: Sharing Data With Other Applications, Downloadable Version

Sharing Data With Other Applications
Lesson 78.     Exporting to Another Access Database
Lesson 79.     Exporting to an Excel Spreadsheet
Lesson 80.     Exporting to Text
Lesson 81.     Importing from Another Access Database
Lesson 82.     Importing Spreadsheet Data
Lesson 83.     Importing Text Data
Lesson 84.     Linking to Tables in Another Access Database
Lesson 85.     Linking to Another Type of Database
Lesson 86.     Linking to SQL Server Databases
Lesson 87.     The Linked Table Manager

Duration: 00:31:12  File Size: 52 MB

Lesson 14

Microsoft Access 2010 LiveLessons:Part 14: Access and the Internet, Downloadable Version

Access and the Internet
Lesson 88.     Creating Web Databases
Lesson 89.     Using Application Parts
Lesson 90.     Creating Publishable Objects
Lesson 91.     Publishing Your Database to Access Services
Lesson 92.     Saving Database Objects as HTML
Lesson 93.     Linking to HTML Files
Lesson 94.     Importing HTML Files
Lesson 95.     Exporting Data to XML
Lesson 96.     Importing XML Data into Access

Duration: 00:27:02  File Size: 47 MB

Lesson 15

Microsoft Access 2010 LiveLessons: Part 15: Database Administration, Downloadable Version

Database Administration
Lesson 97.     Compacting and Repairing a Database
Lesson 98.     Encrypting and Decrypting a Database
Lesson 99.     Converting a Database to Another Version
Lesson 100.   Creating an MDE File
Lesson 101.   Using the Database Splitter

Duration: 00:13:46  File Size: 22 MB

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.

Description

  • Copyright 2011
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-264040-6
  • ISBN-13: 978-0-13-264040-4

OVER SIX HOURS OF VIDEO INSTRUCTION

In 100+ quick video lessons, expert Alison Balter shows how to create high-performance Microsoft Access 2010 tables, queries, forms, reports, and macros… use innovative new features… share data on the web and with other applications… and much more! Master high-powered skills at your pace, and get specific solutions whenever you need them!

Alison Balter is President of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, CA. She has spent 25 years training and consulting on Microsoft Access and related applications with top organizations such as Cisco, Shell, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential, Transamerica, Fox Broadcasting, and the U.S. Navy. She travels throughout North America delivering seminars on Microsoft Access, and has authored 13 books, including Alison Balter’s Mastering Access 2007 Development.

TABLE OF CONTENTS:

Office Access 2010 Introduced
1. Starting Microsoft Access
2. Opening an Existing Database
3. The Access Desktop
4. The Navigation Pane
5. A Preview of the Database Components
6. Closing an Access Database
Tables Introduced
7. Viewing and Navigating Table Data
8. Editing Table Data
9. Adding Records to a Table
10. Selecting and Deleting Records
11. Finding and Replacing Records
12. Filtering Table Data
Queries Introduced
13. Opening a Query in Datasheet View
14. Opening a Query in Design View
15. Selecting Fields
16. Ordering the Query Result
17. Refining Queries with Criteria
18. Modifying the Datasheet View
19. Saving and Closing a Query
Forms Introduced
20. Opening a Form
21. Working with Data in a Form
22. Sorting Form Data
23. Filtering the Data Underlying a Form
24. Viewing the Design of a Form
25. Using the AutoForm Feature
26. Using a Form Wizard
27. Taking Advantage of Conditional Formatting
Reports Introduced
28. Opening and Viewing a Report
29. Printing Report Data
30. AutoReports and the Report Wizard
31. Viewing the Design of a Report
Creating Your Own Databases and Tables
32. Creating a New Database
33. Building a New Table
34. Selecting the Appropriate Field Type
35. Creating Indexes
36. The All-Important Primary Key
Creating Relationships
37. Introduction to Relational Database Design
38. Establishing Relationships in Access
39. Establishing Referential Integrity
Creating Queries
40. Advanced Criteria Techniques
41. Updating Query Results
42. Building Queries Based on Multiple Tables
43. Creating Calculated Fields with the Expression Builder
44. Creating Parameter Queries
Creating Forms
45. Working with Controls
46. Form Properties
47. Working with Combo Boxes
48. The Command Button Wizard: Programming without Typing
49. Creating One-To-Many Forms Using the Form Wizard
50. Creating One-To-Many Forms Using the SubForm Wizard
Creating Reports
51. Working with Report Bands
52. Working with Controls
53. Basing Reports on Multiple Tables
54. Adding Sorting and Grouping
55. Working with Report Properties
56. Working with Subreports
57. Basing Reports on Stored Queries
Creating Macros
58. The Basics of Creating a Macro
59. Running an Access Macro
60. Modifying an Existing Macro
61. Creating an Embedded Macro
62. Creating Data Macros
63. Creating a Drillthrough Macro
64. Debugging a Macro
65. Converting a Macro to VBA Code
66. Creating an AutoExec Macro
Power Techniques
67. Working with Field Properties
68. Working with Table Properties
69. Creating and Running Action Queries
70. Using Aggregate Functions to Summarize Numeric Data
71. Working with Outer Joins and Self Joins
72. Refining Queries with Field, Field List, and Query Properties
73. Control Properties and Why to Use Them
74. Bound, Unbound, and Calculated Controls
75. Control Properties and Why to Use Them
76. Inserting Page Breaks
77. Bound, Unbound, and Calculated Controls
Sharing Data With Other Applications
78. Exporting to Another Access Database
79. Exporting to an Excel Spreadsheet
80. Exporting to Text
81. Importing from Another Access Database
82. Importing Spreadsheet Data
83. Importing Text Data
84. Linking to Tables in Another Access Database
85. Linking to Another Type of Database
86. Linking to SQL Server Databases
87. The Linked Table Manager
Access and the Internet
88. Creating Web Databases
89. Using Application Parts
90. Creating Publishable Objects
91. Publishing Your Database to Access Services
92. Saving Database Objects as HTML
93. Linking to HTML Files
94. Importing HTML Files
95. Exporting Data to XML
96. Importing XML Data into Access
Database Administration
97. Compacting and Repairing a Database
98. Encrypting and Decrypting a Database
99. Converting a Database to Another Version
100. Creating an MDE File

101. Using the Database Splitter

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more.  View All LiveLessons at http://www.quepublishing.com/imprint/series_detail.aspx?st=87397

Sample Content

Table of Contents

Office Access 2010 Introduced
1.         Starting Microsoft Access
2.         Opening an Existing Database
3.         The Access Desktop
4.         The Navigation Pane
5.         A Preview of the Database Components
6.         Closing an Access Database
Tables Introduced
7.         Viewing and Navigating Table Data
8.         Editing Table Data
9.         Adding Records to a Table
10.     Selecting and Deleting Records
11.     Finding and Replacing Records
12.     Filtering Table Data
Queries Introduced
13.     Opening a Query in Datasheet View
14.     Opening a Query in Design View
15.     Selecting Fields
16.     Ordering the Query Result
17.     Refining Queries with Criteria
18.     Modifying the Datasheet View
19.     Saving and Closing a Query
Forms Introduced
20.     Opening a Form
21.     Working with Data in a Form
22.     Sorting Form Data
23.     Filtering the Data Underlying a Form
24.     Viewing the Design of a Form
25.     Using the AutoForm Feature
26.     Using a Form Wizard
27.     Taking Advantage of Conditional Formatting
Reports Introduced
28.     Opening and Viewing a Report
29.     Printing Report Data
30.     AutoReports and the Report Wizard
31.     Viewing the Design of a Report
Creating Your Own Databases and Tables
32.     Creating a New Database
33.     Building a New Table
34.     Selecting the Appropriate Field Type
35.     Creating Indexes
36.     The All-Important Primary Key
Creating Relationships
37.     Introduction to Relational Database Design
38.     Establishing Relationships in Access
39.     Establishing Referential Integrity
Creating Queries
40.     Advanced Criteria Techniques
41.     Updating Query Results
42.     Building Queries Based on Multiple Tables
43.     Creating Calculated Fields with the Expression Builder
44.     Creating Parameter Queries
Creating Forms
45.     Working with Controls
46.     Form Properties
47.     Working with Combo Boxes
48.     The Command Button Wizard: Programming without Typing
49.     Creating One-To-Many Forms Using the Form Wizard
50.     Creating One-To-Many Forms Using the SubForm Wizard
Creating Reports
51.     Working with Report Bands
52.     Working with Controls
53.     Basing Reports on Multiple Tables
54.     Adding Sorting and Grouping
55.     Working with Report Properties
56.     Working with Subreports
57.     Basing Reports on Stored Queries
Creating Macros
58.     The Basics of Creating a Macro
59.     Running an Access Macro
60.     Modifying an Existing Macro
61.     Creating an Embedded Macro
62.     Creating Data Macros
63.     Creating a Drillthrough Macro
64.     Debugging a Macro
65.     Converting a Macro to VBA Code
66.     Creating an AutoExec Macro
Power Techniques
67.     Working with Field Properties
68.     Working with Table Properties
69.     Creating and Running Action Queries
70.     Using Aggregate Functions to Summarize Numeric Data
71.     Working with Outer Joins and Self Joins
72.     Refining Queries with Field, Field List, and Query Properties
73.     Control Properties and Why to Use Them
74.     Bound, Unbound, and Calculated Controls
75.     Control Properties and Why to Use Them
76.     Inserting Page Breaks
77.     Bound, Unbound, and Calculated Controls
Sharing Data With Other Applications
78.     Exporting to Another Access Database
79.     Exporting to an Excel Spreadsheet
80.     Exporting to Text
81.     Importing from Another Access Database
82.     Importing Spreadsheet Data
83.     Importing Text Data
84.     Linking to Tables in Another Access Database
85.     Linking to Another Type of Database
86.     Linking to SQL Server Databases
87.     The Linked Table Manager
Access and the Internet
88.     Creating Web Databases
89.     Using Application Parts
90.     Creating Publishable Objects
91.     Publishing Your Database to Access Services
92.     Saving Database Objects as HTML
93.     Linking to HTML Files
94.     Importing HTML Files
95.     Exporting Data to XML
96.     Importing XML Data into Access
Database Administration
97.     Compacting and Repairing a Database
98.     Encrypting and Decrypting a Database
99.     Converting a Database to Another Version
100.   Creating an MDE File
101.   Using the Database Splitter

Updates

Submit Errata

More Information

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months.