United States Microsoft Access 2013 Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Access 2013 are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Access 2013 freely available. Click on any of the linked lesson listings below to preview FREE!
Microsoft Access 2013 is the latest version of the number one database application in the world, and this is a big release. Access 2013 brings quite a few changes, all designed to make database applications easier to design and implement. The ability to quickly create Web Applications that run in the user's browser, regardless of which device they use, is one of the major changes in the latest release. In this VTC course, author Mark Long takes you step by step through Access 2013 to quickly get you up to speed on these changes. Access is everywhere, from small one-person businesses up to the largest corporations in the world. It's where most data first gets stored before progressing to SQL Server, cloud delivery, and enterprise data services. Understanding Access is vital to real world database creation/maintenance/design and this course will show you what you need to get there. To begin learning today, simply click on the movie links.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Welcome
|
||
| Introduction | (01:31) | |
| Course Overview | (03:53) | |
| What Access Is | (04:49) | |
| New in 2013 | (03:58) | |
| Access Grows Up | (05:54) | |
| The Future of Access | (05:40) | |
| Access Alternatives | (05:52) | |
|
Database 101
|
||
| What a Database Is | (03:58) | |
| Database Types | (05:11) | |
| Database Organization | (04:31) | |
| Understanding Tables | (04:13) | |
| Understanding Data Types pt. 1 | (04:32) | |
| Understanding Data Types pt. 2 | (06:14) | |
| Primary Key Basics | (04:30) | |
| Understanding Indexes pt. 1 | (05:07) | |
| Understanding Indexes pt. 2 | (05:23) | |
|
Database Design 101
|
||
| Database Design Options | (04:28) | |
| Understanding Normalization | (04:42) | |
| Understanding Relationships | (03:53) | |
| Relationship Types pt. 1 | (04:32) | |
| Relationship Types pt. 2 | (04:45) | |
| Understanding Integrity | (04:08) | |
|
Getting Started with Access 2013
|
||
| Where to Start | (04:39) | |
| Introducing Office 365 | (04:03) | |
| Access Database Objects | (04:58) | |
| Installing Access 2013 pt. 1 | (04:29) | |
| Installing Access 2013 pt. 2 | (04:20) | |
| Creating a Database | (05:24) | |
| Access Interface Tour | (07:09) | |
| Database Backups | (02:15) | |
|
Working with Tables
|
||
| Creating Our Database | (05:02) | |
| Datasheet or Design | (05:21) | |
| Creating Tables pt. 1 | (05:54) | |
| Creating Tables pt. 2 | (05:48) | |
| Data Types pt. 1 | (06:18) | |
| Data Types pt. 2 | (04:07) | |
| Editing Table Structures | (04:30) | |
| Date/Time Formats pt. 1 | (04:09) | |
| Date/Time Formats pt. 2 | (05:04) | |
| Using Input Masks | (04:54) | |
| Deleting Rows | (03:00) | |
| Required Fields | (04:06) | |
| Adding a Primary Key | (06:26) | |
| Creating an Index | (05:16) | |
| Deleting a Table | (04:08) | |
|
Access Relationships
|
||
| Identifying Relationships | (02:18) | |
| Design Meets Relationships | (03:56) | |
| Creating a Relationship pt. 1 | (07:19) | |
| Creating a Relationship pt. 2 | (06:39) | |
| Creating a Relationship pt. 3 | (05:48) | |
| Managing Relationships | (04:07) | |
| Viewing Object Dependencies | (04:17) | |
|
Data Retrieval
|
||
| Understanding Queries | (04:47) | |
| Access and SQL | (06:30) | |
| Query Types | (04:10) | |
| Creating Queries pt. 1 | (06:37) | |
| Creating Queries pt. 2 | (06:19) | |
| Make Table Queries | (06:23) | |
| Understanding Join Queries | (04:43) | |
| Union Queries | (04:05) | |
| Top Queries | (04:39) | |
| Distinct Queries | (04:00) | |
| Query Filters | (03:13) | |
| Append Queries | (03:33) | |
| Delete Queries | (03:16) | |
| Data Management Options | (02:21) | |
|
Data Forms and Reports
|
||
| Understanding Forms | (03:44) | |
| Why Use Forms | (05:47) | |
| Using AutoForm | (03:55) | |
| Using the Form Wizard | (06:22) | |
| Forms from Scratch | (05:25) | |
| Design or Layout | (04:20) | |
| Working with Controls | (03:11) | |
| Setting the Tab Order | (03:12) | |
|
Using External Data
|
||
| Data Here and There | (04:19) | |
| Exporting Data | (04:24) | |
| Importing Data | (03:21) | |
| Data Linking | (04:03) | |
| Data Linking Example | (03:21) | |
|
Access Gets Friendly
|
||
| What SharePoint Is | (05:54) | |
| A Budding Relationship | (06:25) | |
| Goodbye ADP | (04:16) | |
|
Access and the Web
|
||
| Understanding Web Apps | (06:03) | |
| SharePoint Foundation 2013 | (04:26) | |
| SharePoint System Requirements | (03:08) | |
| Getting Setup for Web Apps | (05:22) | |
| Creating a Web App | (04:44) | |
|
Conclusion
|
||
| Course Wrap Up | (05:21) | |
|
Credits
|
||
| About the Author | (02:39) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft Access 2013 |
| Author: | Mark Long |
| SKU: | 34405 |
| ISBN: | 978-1-61866-090-9 |
| Release Date: | 2013-02-01 |
| Price: | |
| Duration: | 7 hrs / 89 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
I love LOVE your service and I have recommended it to everyone I see in the web department of bookstores. I have a new life because of your...
Jennifer Gooden