Home > Store > Data > Access

Access 2013 LiveLessons (Video Training)

Access 2013 LiveLessons (Video Training)

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

Downloadable Video

  • Your Price: $39.99
  • List Price: $49.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

Part 1: Why Use Access? Downloadable Version

Welcome to Lesson 1, Why Use Microsoft Access. In this lesson you’ll learn about relational databases and why they are important. Take a whirlwind tour of the database components including tables, relationships, queries, forms, reports, macros, and modules. Finally, explore the types of things you can do with Microsoft Access.

Duration: 00:12:25  File Size: 34 MB

Lesson 2

Part 2: Get Started with Microsoft Access, Downloadable Version

Welcome to Lesson 2, Getting Started with Microsoft Access. In this lesson you’ll learn how to create your own databases. You’ll also learn how to open existing databases, and how to close your databases and exit Access.

Duration: 00:12:17  File Size: 32 MB

Lesson 3

Part 3: Tables - The Repository for Your Data, Downloadable Version

Welcome to Lesson 3, Tables: The Repository for Your Data. In this lesson you’ll learn how to add, edit, and delete table data. You’ll also learn how to search and replace data, and how to filter your data to view just the data that you need. Let’s get started!

Duration: 00:19:57  File Size: 73 MB

Lesson 4

Part 4: Use Queries to Retrieve the Data You Need, Downloadable Version

Most queries are stored questions about the data in your database. In Lesson 4 you learn all of the basics of working with queries. You learn how to work with queries in both Design view and Datasheet view. You will also learn how to select fields, order the query result, and how to use criteria to refine the queries that you build.

Duration: 00:20:42  File Size: 62 MB

Lesson 5

Part 5: Use Forms to Display and Modify Information, Downloadable Version, Access 2013 LiveLessons (Video Training)

Welcome to Lesson 5, Use Forms to Display and Modify Information. This lesson covers all of the basics of working with forms. You learn how to work with data from within a form. You also learn how to view the design of the form.

Duration: 00:20:00  File Size: 72 MB

Lesson 6

Part 6: Create Your Own Forms, Downloadable Version

Welcome to Lesson 6, Create Your Own Forms. In this exciting lesson, you learn how to create basic forms with the Form wizard. You also learn how to build split forms, multiple item forms, and navigation form. Finally you learn how to enhance your forms with conditional formatting.

Duration: 00:24:28  File Size: 84 MB

Lesson 7

Part 7: Use Reports to Print Information, Downloadable Version

Now that you have forms under your belt, Lesson 7 covers the basics of working with reports. You will learn how to open and view an existing report. You’ll become comfortable with moving from page to page, zooming in and out, viewing multiple pages, and printing.

Duration: 00:24:27  File Size: 28 MB

Lesson 8

Part 8: Build Your Own Reports, Downloadable Version

In lesson 8 you will learn how to build your own reports. You learn how to create a report with the Report wizard. You will also explore the exciting world of mailing labels. Finally, you learn how to view a report in Design view.

Duration: 00:11:55  File Size: 32 MB

Lesson 9

Part 9: Create Your Own Tables, Downloadable Version

In lesson 9 you learn how to create your own tables. Important techniques covered in the lesson include selecting the appropriate field type, working with field properties, creating indexes, and adding a primary key field.

Duration: 00:23:11  File Size: 58 MB

Lesson 10

Part 10: Relate the Information in Your Database, Downloadable Version

Now that you know how to create tables, it’s important that you learn how to relate them. After introducing you to relational database design, Lesson 10 shows you how to establish both relationships, and referential integrity between the tables in your database.

Duration: 00:23:58  File Size: 48 MB

Lesson 11

Part 11: Enhance the Queries that You Build, Downloadable Version

Lesson 11 moves you to the next dimension by teaching you how to base queries on multiple tables. You learn more about query basics, and we explore advanced criteria techniques.

Duration: 00:24:20  File Size: 92 MB

Lesson 12

Part 12: Advanced Query Techniques, Downloadable Version

Lesson 12, Advanced Query Techniques, takes your querying abilities to a whole new level. In the lesson you learn how to create calculated fields. We also explore action queries that allow you to insert, update, and delete table data. You will probably find Parameter queries to be the most exciting. Parameter queries prompt you at runtime for criteria necessary for the query to run. This allows you to create flexible and powerful queries.

Duration: 00:28:11  File Size: 90 MB

Lesson 13

Part 13: Build Powerful Forms, Downloadable Version

In Lesson 13, Build Powerful Forms, you learn how to work with controls. You then learn how you can use form and control properties to build the forms that you need.

Duration: 00:21:26  File Size: 89 MB

Lesson 14

Part 14: Advanced Form Techniques, Downloadable Version

In Lesson 14, Advanced Form Techniques, we begin by working with combo boxes. We then delve into the Command Button wizard which helps you to program without typing! Finally, you learn how to create one-to-many forms.

Duration: 00:18:36  File Size: 68 MB

Lesson 15

Part 15: Build Powerful Reports, Downloadable Version

In Lesson 15 you delve into reports. You learn how to work with report bands, and how to work with controls. You also learn how to base reports on multiple tables. Finally, we explore the powerful world of subreports. Let’s dive in.

Duration: 00:21:29  File Size: 79 MB

Lesson 16

Part 16: Advanced Report Techniques, Downloadable Version

In Lesson 16 you learn Advanced Report Techniques. One of the most exciting report topics is Sorting and Grouping. This is where you learn how to sort and group your report data, and how to create subtotals and grand totals. You also learn how to work with Header, Footer, and Report properties. Let’s explore what’s possible!

Duration: 00:15:53  File Size: 57 MB

Lesson 17

Part 17: Automate Your Database with Macros, Downloadable Version

Many people will find Lesson 17 to be the most fun and exciting lesson yet. In Lesson 17 you learn how to create and work with macros. Using macros you can automate your applications. You’ll be surprised at how easy it is to accomplish common tasks using macros.

Duration: 00:23:48  File Size: 77 MB

Lesson 18

Part 18: Advanced Macro Techniques, Downloadable Version

In Lesson 18 we learn advanced macro techniques. We start with the very powerful data macros that allow you to take action when someone inserts, updates, or deletes table data. We then explore Drill-through macros that allow you to open one form from another, displaying specified data. Finally, we learn how to debug macros, and how to build a macro that executes when you open a database.

Duration: 00:27:18  File Size: 84 MB

Lesson 19

Part 19: Share Data with Other Applications, Downloadable Version

One of the most exciting aspects of Access 2013 is its ability to interface with data in other applications. Lesson 19 shows you how to seamlessly interact with Excel, text files, and even SQL Server databases. This lesson is certain to be eye-opening!

Duration: 00:23:00  File Size: 67 MB

Lesson 20

Part 20: Put it All Together - A Complete Application, Downloadable Version

Lesson 20, Put it All Together, a Complete Application does just that. In the lesson you learn how to put everything that you learned together to build a polished application. In the lesson we build all the tables, relationships, forms, queries, reports, and macros needed for our database. Let’s put it all together and build a complete database.

Duration: 00:34:05  File Size: 103 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.

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 2013
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-4872-X
  • ISBN-13: 978-0-7897-4872-0

6+ Hours of Video Instruction

                                                                                                         

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!

  

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 and Office Technologies, Business and Management, and more. 

View all LiveLessons on InformIT at http://www.informit.com/imprint/series_detail.aspx?ser=2185116

Que:

http://www.quepublishing.com/imprint/series_detail.aspx?st=87397

Sample Content

Table of Contents

Lesson 1 – Why use Microsoft Access?

1.1          Learn About Relational Databases

1.2          Preview Database Components

1.3          Explore the Types of Things You Can Do With Microsoft Access

Lesson 2 – Get Started with Microsoft Access

2.1          Create a Database from a Template

2.2          View Database Objects

2.3          Create a Database from Scratch

2.4          Open an Existing Database

2.5          Close a Database

2.6          Exit Access

Lesson 3 – Tables: The Repository for Your Data

3.1          View and Navigate Table Data

3.2          Edit Table Data

3.3          Search for and Replace Table Data

3.4          Use Filters to View the Data You Need

Lesson 4 –Use Queries to Retrieve the Data You Need

4.1          Create a Simple Query

4.2          Order the Query Result

4.3          Refine your Queries with Criteria

4.4          Close a Query

4.5          Open an Existing Query

Lesson 5 – Use Forms to Display and Modify Information

5.1          Open an Existing For

5.2          Delete Field Contents Within a Form

5.3          Use a Form to Add New Records to a Table

5.4          Use a Form to Delete Records from a Table

5.5          Copy Records Within a Form

5.6          Work with Data

5.7          Replace Data in the Table Underlying a Form

5.8          Sort Form Data

5.9          Filter Form Data

5.10        View the Design of a Form

Lesson 6 - Create Your Own Forms

6.1          Create a Form by Using the AutoForm Feature

6.2          Use the Form Wizard to Build a Form

6.3          Create Split Forms

6.4          Create Multiple Item Forms

6.5          Create Navigation Forms

6.6          Take Advantage of Conditional Formatting

Lesson 7 –Use Reports to Print Information

7.1          Open and View a Report

7.2          Move from Page to Page

7.3          Zoom In and Out

7.4          View Multiple Pages

7.5          Print a Report

Lesson 8 - Build Your Own Reports

8.1          Use the AutoReport Feature

8.2          Create a Report by Using the Report Wizard

8.3          Create Mailing Labels

8.4          View the Design of a Report

Lesson 9 - Create Your Own Tables

9.1          Build a New Table

9.2          Select the Appropriate Field Type for Your Data

9.3          Work with Indexes

9.4          Explore the All-Important Primary Key

9.5          Work with Field Properties

Lesson 10 – Relate the Information in Your Database

10.1        Learn about Relational Database Design

10.2        Examine the Types of Relationships

10.3        Establish Relationships

10.4        Establish Referential Integrity

Lesson 11 – Enhance the Queries That You Build

11.1        Design a Query Based on Multiple Tables

11.2        Modify the Datasheet View of a Query

11.3        Print Query Results

11.4        Learn about the Updatability of Query Results

11.5        Explore Everything You Ever Needed to Know About Query Basics

11.6        Refine Your Query with Criteria

Lesson 12 – Advanced Query Techniques

12.1        Create Calculated Fields

12.2        Get Help from the Expression Builder

12.3        Create and Run Parameter Queries

12.4        Create and Run Action Queries

12.5        Use Aggregate Functions to Summarize Numeric Data

12.6        Work with Outer Joins

Lesson 13: Build Powerful Forms

13.1        Work with Controls

13.2        Take Advantage of Form Properties

13.3        Learn about Control Properties and Why to Use Them

Lesson 14: Advanced Form Techniques

14.1        Work with Combo Boxes

14.2        Work with List Boxes

14.3        Explore the Command Button Wizards: Programming without Typing

14.4        Build Forms Based on More Than One Table

14.5        Work with Subforms

Lesson 15: Build Powerful Reports

15.1        Understand Report Bands

15.2        Work with Controls

15.3        Build a One-to-Many Report Using the Report Wizard

15.4        Enhancing a One-to-Many Report

15.5        Build a One-to-Many Report with the SubReport Wizard

15.6        Use Subreports

Lesson 16: Advanced Report Techniques

16.1        Add Sorting and Grouping

16.2        Work with Group Header and Footer Properties

16.3        Take Advantage of Report Properties

Lesson 17: Automate Your Database with Macros

17.1        Learn the Basics of Creating and Running a Macro

17.2        Harness the Power of Submacros

17.3        Control your Macros Using Program Flow

17.4        Run an Access Macro

17.5        Modify an Existing Macro

17.6        Create an Embedded Macro

Lesson 18: Advanced Macro Techniques

18.1        Create Data Macros

18.2        Create a Drillthrough Macro

18.3        Learn What Other New Features Are Available in Macros

18.4        Debug a Macro

18.5        Convert a Macro to VBA Code

18.6        Create an AutoExec Macro

Lesson 19: Share Data With Other Applications

19.1        Export Access Data

19.2        Import Data Into Access

19.3        Link to Data in Other Databases

19.4        The Linked Table Manager

Lesson 20 – Put it All Together – A Complete Application

20.1        Design the Tables to Store Your Data

20.2        Build the Forms to Edit Your Data

20.3        Build the Queries to Extract the Data You Need

20.4        Design the Reports to Display Your Data

20.5        Build the Macros Necessary to Automate Your Application

Summary

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership