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

Access 2013 LiveLessons (Video Training)

Video Description

Explore the most popular and some of the lesser known features of Access 2013 –Tables, Queries, Forms, Reports, Macros, and much more with Alison Balter as your guide!

  • Start-to-finish personal training on Access 2013: just watch and learn!
  • Simple, quick video walkthroughs of the tasks you perform most often!
  • Great personalized training at a fraction of the cost...for everyone who doesn't have time to read a book!
These video lessons will ensure that you can harness the power of Access faster and more easily than ever before! In 13 thorough parts, Access 2013 LiveLessons shows you how to increase add finesse and polish to your presentations so they look like the pros. Expert Alison Balter simplifies powerful features and tools including Tables, Forms, reports, Queries, Macros, and much more! Truly harness the power built into Access! Just watch: You’ll master high-powered skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Access 2013 fast!

About the Author:

Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 27 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, University of Southern California, Massachusetts Institute of Technology, and others.

Alison specializes in teaching others how to develop Windows and Web applications. She is a leading author of 15 Microsoft Access books and SQL Server books, including Alison Balter’s Mastering Access 2003 Development, Alison Balter’s Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours, Using Access 2010, and Access 2013 Absolute Beginners Guide. Alison is also featured in several training videos for both SAMS and Experts Exchange.

Most recently, Alison was given the honor of Microsoft Access MVP 2012, an honor bestowed on a select few individuals who have donated their time to bettering the development community. She was also selected as 2012/2013 Ventura County Woman Business Owner of the Year. Alison can be reached at alison@techismything.com.

Table of Contents

  1. Introduction
    1. Introduction to Access 2013 LiveLessons 00:03:45
  2. Lesson 1: Why use Microsoft Access?
    1. Learning objectives 00:00:32
    2. 1.1 Learn About Relational Databases 00:00:56
    3. 1.2 Preview Database Components 00:05:31
    4. 1.3 Explore the Types of Things You Can Do With Microsoft Access 00:04:16
  3. Lesson 2: Get Started with Microsoft Access
    1. Learning objectives 00:00:23
    2. 2.1 Create a Database from a Template 00:02:50
    3. 2.2 View Database Objects 00:04:25
    4. 2.3 Create a Database from Scratch 00:01:29
    5. 2.4 Open an Existing Database 00:00:46
    6. 2.5 Close a Database 00:00:30
    7. 2.6 Exit Access 00:00:44
  4. Lesson 3: Tables: The Repository for Your Data
    1. Learning objectives 00:00:26
    2. 3.1 View and Navigate Table Data 00:02:22
    3. 3.2 Edit Table Data 00:04:52
    4. 3.3 Search for and Replace Table Data 00:03:21
    5. 3.4 Use Filters to View the Data You Need 00:07:46
  5. Lesson 4: Use Queries to Retrieve the Data You Need
    1. Learning objectives 00:00:29
    2. 4.1 Create a Simple Query 00:04:29
    3. 4.2 Order the Query Result 00:03:45
    4. 4.3 Refine your Queries with Criteria 00:07:32
    5. 4.4 Close a Query 00:01:44
    6. 4.5 Open an Existing Query 00:01:33
  6. Lesson 5: Use Forms to Display and Modify Information
    1. Learning objectives 00:00:24
    2. 5.1 Open an Existing Form 00:00:49
    3. 5.2 Delete Field Contents Within a Form 00:01:18
    4. 5.3 Use a Form to Add New Records to a Table 00:01:30
    5. 5.4 Use a Form to Delete Records from a Table 00:01:11
    6. 5.5 Copy Records Within a Form 00:01:23
    7. 5.6 Work with Data 00:01:59
    8. 5.7 Replace Data in the Table Underlying a Form 00:02:05
    9. 5.8 Sort Form Data 00:01:47
    10. 5.9 Filter Form Data 00:04:16
    11. 5.10 View the Design of a Form 00:02:08
  7. Lesson 6: Create Your Own Forms
    1. Learning objectives 00:00:26
    2. 6.1 Create a Form by Using the AutoForm Feature 00:02:10
    3. 6.2 Use the Form Wizard to Build a Form 00:03:21
    4. 6.3 Create Split Forms 00:04:43
    5. 6.4 Create Multiple Item Forms 00:01:46
    6. 6.5 Create Navigation Forms 00:05:32
    7. 6.6 Take Advantage of Conditional Formatting 00:05:20
  8. Lesson 7: Use Reports to Print Information
    1. Learning objectives 00:00:25
    2. 7.1 Open and View a Report 00:01:52
    3. 7.2 Move from Page to Page 00:00:55
    4. 7.3 Zoom In and Out 00:01:26
    5. 7.4 View Multiple Pages 00:00:57
    6. 7.5 Print a Report 00:02:34
  9. Lesson 8: Build Your Own Reports
    1. Learning objectives 00:00:22
    2. 8.1 Use the AutoReport Feature 00:01:41
    3. 8.2 Create a Report by Using the Report Wizard 00:02:47
    4. 8.3 Create Mailing Labels 00:04:35
    5. 8.4 View the Design of a Report 00:01:20
  10. Lesson 9: Create Your Own Tables
    1. Learning objectives 00:00:25
    2. 9.1 Build a New Table 00:04:39
    3. 9.2 Select the Appropriate Field Type for Your Data 00:03:37
    4. 9.3 Work with Indexes 00:03:20
    5. 9.4 Explore the All-Important Primary Key 00:02:55
    6. 9.5 Work with Field Properties 00:07:04
  11. Lesson 10: Relate the Information in Your Database
    1. Learning objectives 00:00:25
    2. 10.1 Learn about Relational Database Design 00:07:41
    3. 10.2 Examine the Types of Relationships 00:03:41
    4. 10.3 Establish Relationships 00:05:57
    5. 10.4 Establish Referential Integrity 00:05:03
  12. Lesson 11: Enhance the Queries That You Build
    1. Learning objectives 00:00:23
    2. 11.1 Design a Query Based on Multiple Tables 00:03:33
    3. 11.2 Modify the Datasheet View of a Query 00:05:09
    4. 11.3 Print Query Results 00:01:43
    5. 11.4 Learn about the Updatability of Query Results 00:03:54
    6. 11.5 Explore Everything You Ever Needed to Know About Query Basics 00:02:10
    7. 11.6 Refine Your Query with Criteria 00:06:18
  13. Lesson 12: Advanced Query Techniques
    1. Learning objectives 00:00:38
    2. 12.1 Create Calculated Fields 00:03:53
    3. 12.2 Get Help from the Expression Builder 00:02:34
    4. 12.3 Create and Run Parameter Queries 00:03:40
    5. 12.4 Create and Run Action Queries 00:08:16
    6. 12.5 Use Aggregate Functions to Summarize Numeric Data 00:02:49
    7. 12.6 Work with Outer Joins 00:05:11
  14. Lesson 13: Build Powerful Forms
    1. Learning objectives 00:00:19
    2. 13.1 Work with Controls 00:08:01
    3. 13.2 Take Advantage of Form Properties 00:06:19
    4. 13.3 Learn about Control Properties and Why to Use Them 00:05:37
  15. Lesson 14: Advanced Form Techniques
    1. Learning objectives 00:00:22
    2. 14.1 Work with Combo Boxes 00:05:17
    3. 14.2 Work with List Boxes 00:03:57
    4. 14.3 Explore the Command Button Wizards: Programming without Typing 00:03:05
    5. 14.4 Build Forms Based on More Than One Table 00:04:45
  16. Lesson 15: Build Powerful Reports
    1. Learning objectives 00:00:25
    2. 15.1 Understand Report Bands 00:04:01
    3. 15.2 Work with Controls 00:02:06
    4. 15.3 Build a One-to-Many Report Using the Report Wizard 00:04:25
    5. 15.4 Enhancing a One-to-Many Report 00:04:55
    6. 15.5 Build a One-to-Many Report with the SubReport Wizard 00:02:48
    7. 15.6 Use Subreports 00:01:39
  17. Lesson 16: Advanced Report Techniques
    1. Learning objectives 00:00:30
    2. 16.1 Add Sorting and Grouping 00:06:27
    3. 16.2 Work with Group Header and Footer Properties 00:04:53
    4. 16.3 Take Advantage of Report Properties 00:02:52
  18. Lesson 17: Automate Your Database with Macros
    1. Learning objectives 00:00:30
    2. 17.1 Learn the Basics of Creating and Running a Macro 00:04:30
    3. 17.2 Harness the Power of Submacros 00:03:04
    4. 17.3 Control your Macros Using Program Flow 00:04:45
    5. 17.4 Run an Access Macro 00:03:52
    6. 17.5 Modify an Existing Macro 00:02:53
    7. 17.6 Create an Embedded Macro 00:03:04
  19. Lesson 18: Advanced Macro Techniques
    1. Learning objectives 00:00:36
    2. 18.1 Create Data Macros 00:07:03
    3. 18.2 Create a Drillthrough Macro 00:05:52
    4. 18.3 Learn What Other New Features Are Available in Macros 00:05:04
    5. 18.4 Test a Macro 00:02:33
    6. 18.5 Convert a Macro to VBA Code 00:02:29
    7. 18.6 Create an AutoExec Macro 00:02:31
  20. Lesson 19: Share Data With Other Applications
    1. Learning objectives 00:00:27
    2. 19.1 Export Access Data 00:07:18
    3. 19.2 Import Data Into Access 00:05:57
    4. 19.3 Link to Data in Other Databases 00:06:26
    5. 19.4 The Linked Table Manager 00:01:41
  21. Lesson 20: Put it All Together – A Complete Application
    1. Learning objectives 00:00:33
    2. 20.1 Design the Tables to Store Your Data 00:05:25
    3. 20.2 Build the Forms to Edit Your Data 00:10:00
    4. 20.3 Build the Queries to Extract the Data You Need 00:04:38
    5. 20.4 Design the Reports to Display Your Data 00:06:48
    6. 20.5 Build the Macros Necessary to Automate Your Application 00:05:31
  22. Summary
    1. Summary of Access 2013 LiveLessons 00:01:16