Are you sure you want to cancel your subscription?

If you cancel, your subscription will remain active through the paid term. You will be able to reactivate the subscription until that date.

Sorry to see you go

Your subscription will remain active until . If you change your mind, you may rectivate your subscription anytime before that date.

Are you sure you want to reactivate?
Welcome Back!

Your subscription has been reactivated and you will continue to be charged on .

Reactivate Subscription

Thank you for choosing to reactivate your subscription. In order to lock in your previous subscription rate, you owe: .

Your Subscription term is from - .

Questions? Call Sales.

Payment Due:

Auto-Renew Subscription

To auto-renew your subscription you need to select or enter your payment method in "Your Account" under Manage Payments.

Click continue to set up your payments.

CBT Nuggets License Agreement

Unless otherwise stated all references to “training videos” or to “videos” includes both individual videos within a series, entire series, series packages, and streaming subscription access to CBT Nuggets content. All references to CBT or CBT Nuggets shall mean CBT Nuggets LLC, a Delaware limited liability company located at 44 Country Club Road, Ste. 150, Eugene, Oregon.

A CBT Nuggets license is defined as a single user license. Accounts may purchase multiple users, and each user is assigned a single license.

  • GRANT OF LICENSE. CBT Nuggets grants you a non-transferable, non-exclusive license to use the training videos contained in this package or streaming subscription access to CBT content (the “Products”), solely for internal use by your business or for your own personal use. You may not copy, reproduce, reverse engineer, translate, port, modify or make derivative works of the Products without the express consent of CBT. You may not rent, disclose, publish, sell, assign, lease, sublicense, market, or transfer the Products or use them in any manner not expressly authorized by this Agreement without the express consent of CBT. You shall not derive or attempt to derive the source code, source files or structure of all or any portion of the Products by reverse engineering, disassembly, decompilation or any other means. You do not receive any, and CBT Nuggets retains all, ownership rights in the Products. The Products are copyrighted and may not be copied, distributed or reproduced in any form, in whole or in part even if modified or merged with other Products. You shall not alter or remove any copyright notice or proprietary legend contained in or on the Products.
  • TERMINATION OF LICENSE. Once any applicable subscription period has concluded, the license granted by this Agreement shall immediately terminate and you shall have no further right to access, review or use in any manner any CBT Nuggets content. CBT reserves the right to terminate your subscription if, at its sole discretion, CBT believes you are in violation of this Agreement. CBT reserves the right to terminate your subscription if, at its sole discretion, CBT believes you have exceeded reasonable usage. In these events no refund will be made of any amounts previously paid to CBT.
  • DISCLAIMER OF WARRANTY AND LIABILITY. The products are provided to you on an “as is” and “with all faults” basis. You assume the entire risk of loss in using the products. The products are complex and may contain some nonconformities, defects or errors. CBT Nuggets does not warrant that the products will meet your needs, “expectations or intended use,” that operations of the products will be error-free or uninterrupted, or that all nonconformities can or will be corrected. CBT Nuggets makes and user receives no warranty, whether express or implied, and all warranties of merchantability, title, and fitness for any particular purpose are expressly excluded. In no event shall CBT Nuggets be liable to you or any third party for any damages, claim or loss incurred (including, without limitation, compensatory, incidental, indirect, special, consequential or exemplary damages, lost profits, lost sales or business, expenditures, investments, or commitments in connection with any business, loss of any goodwill, or damages resulting from lost data or inability to use data) irrespective of whether CBT Nuggets has been informed of, knew of, or should have known of the likelihood of such damages. This limitation applies to all causes of action in the aggregate including without limitation breach of contract, breach of warranty, negligence, strict liability, misrepresentation, and other torts. In no event shall CBT Nuggets’ liability to you or any third party exceed $100.00.
  • REMEDIES. In the event of any breach of the terms of the Agreement CBT reserves the right to seek and recover damages for such breach, including but not limited to damages for copyright infringement and for unauthorized use of CBT content. CBT also reserves the right to seek and obtain injunctive relief in addition to all other remedies at law or in equity.
  • MISCELLANEOUS. This is the exclusive Agreement between CBT Nuggets and you regarding its subject matter. You may not assign any part of this Agreement without CBT Nuggets’ prior written consent. This Agreement shall be governed by the laws of the State of Oregon and venue of any legal proceeding shall be in Lane County, Oregon. In any proceeding to enforce or interpret this Agreement, the prevailing party shall be entitled to recover from the losing party reasonable attorney fees, costs and expenses incurred by the prevailing party before and at any trial, arbitration, bankruptcy or other proceeding and in any appeal or review. You shall pay any sales tax, use tax, excise, duty or any other form of tax relating to the Products or transactions. If any provision of this Agreement is declared invalid or unenforceable, the remaining provisions of this Agreement shall remain in effect. Any notice to CBT under this Agreement shall be delivered by U.S. certified mail, return receipt requested, or by overnight courier to CBT Nuggets at the following address: 44 Club Rd Suite 150, Eugene, OR 97401 or such other address as CBT may designate.

CBT Nuggets reserves the right, in its sole discretion, to change, modify, add, or remove all or part of the License Agreement at any time, with or without notice.

Billing Agreement

  • By entering into a Billing Agreement with CBT Nuggets, you authorize CBT Nuggets to use automatic billing and to charge your credit card on a recurring basis.
  • You agree to pay subscription charges on a monthly basis, under the following terms and conditions:
    • CBT Nuggets will periodically charge your credit card each monthly billing cycle as your subscription charges become due;
    • All payments are non-refundable and charges made to the credit card under this agreement will constitute in effect a "sales receipt" and confirmation that services were rendered and received;
    • To terminate the recurring billing process and/or arrange for an alternative method of payment, you must notify CBT Nuggets at least 24 hours prior to the end of the monthly billing cycle;
    • You will not dispute CBT Nugget’s recurring billing charges with your credit card issuer so long as the amount in question was for periods prior to the receipt and acknowledgement of a written request to cancel your account or cancel individual licenses on your account.
  • You guarantee and warrant that you are the legal cardholder for the credit card associated with the account, and that you are legally authorized to enter into this recurring billing agreement.
  • You agree to indemnify, defend and hold CBT Nuggets harmless, against any liability pursuant to this authorization.
  • You agree that CBT Nuggets is not obligated to verify or confirm the amount for the purpose of processing these types of payments. You acknowledge and agree that Recurring Payments may be variable and scheduled to occur at certain times.
  • If your payment requires a currency conversion by us, the amount of the currency conversion fee will be determined at the time of your payment. You acknowledge that the exchange rate determined at the time of each payment transaction will differ and you agree to the future execution of payments being based on fluctuating exchange rates.

CBT Nuggets reserves the right, in its sole discretion, to change, modify, add, or remove all or part of the Billing Agreement at any time, with or without notice.

Microsoft Office 2007 Access 77-605

Specialist training for Microsoft Office Access 2007: 77-605 MOS

Course Duration: 07:58:53
Introduction to Access 2007
Welcome to Microsoft Office Access 2007! Things are a little different than you're used to, so here's a quick tour. This video walks through the Access 2007 interface including the Navigation Bar, the Office 2007 Ribbon and the Office button. The new Access templates are also covered. Plus you'll jump right in and create a new database.
Introduction to Tables
Tables are the core of everything in Access. This video begins your journey into Access by showing how to create tables. You'll learn what to consider when you design tables, how to create primary keys, and finally how to add, edit, and delete records from your tables.
Table Properties
Tables are taken to the next level in this video. If you want your tables to work well and retain their integrity as they grow, there's a few things you must know. So in this video you learn how to work with data types, field size, validation rules, required fields and indexes -- the secrets to keeping your data clean and scalable.
Normalizing Data
Creating normalized tables and setting the appropriate relationships is the foundation of good database design -- this video shows you how!
Simple Queries
In this video you'll learn how to write a basic query. 'Select' queries are a necessary tool for viewing and reporting data from underlying tables. Knowing how to create solid, powerful queries will be your key to becoming an Access expert -- and this video is your start.
Simple Forms
An important piece of utilizing any database is adding, deleting and editing information. Forms allow people to do these things without knowing how to use the Access back-end -- so if users access your database, you better learn how to make forms. So first in this video you learn form basics. You may be familiar with Design view from previous versions of Access, but with 2007 you get something new... Layout view. This makes it quick and easy to add finishing touches to your form's design. Plus you'll learn how Sorting and Filtering information helps users locate specific records.
Form Design
Sure... in the last video you learned how you can create a form with the click of a button. But to create a form that does exactly what you want -- something you can be proud of -- you need to master the Form Design view. That's what you'll learn in this video. You'll use form controls, formatting options, and properties -- add these up and you can create your data input masterpiece!
Query Design
It may sound backwards until you really wrap your head around it -- but in a well-designed database your data is stored separately, in inter-related tables... not all together. But once you have all your data in these separate tables, how do you link table to table to table to bring all your data back together for processing and output? Advanced queries! You'll learn the beginnings of advanced queries, including how to get data out of your database, and how to clean up duplicate information. Be careful though, not all records are displayed unless you know how to work with query joins -- which you'll also learn in this video.
Advanced Queries
Access is jam packed with action queries that can make data maintenance much easier. Now you get to learn how to use them. You can make new tables, append data to existing tables, update values and even delete records based on specific criteria.
Simple Reports
Reports are the tool by which your audience will see and interpret your information. Whether you create a simple report or design it from scratch, you will have many tools at your disposal to make your output look clean, clear, and professional. You can even base reports on queries so that only targeted information will be displayed to your audience -- think about creating separate reports for your sales manager, accounting, marketing... it's possible and easier than you think.
Report Design
This nugget takes reports to the next level. Once you've mastered simple reports you may want to group data to make your information more easily understood -- here you'll learn how. Plus, adding calculated fields can improve the information you are trying to get across to your audience -- so you'll learn how to calculate fields and adjust how the result is displayed.
Advanced Forms
For this nugget you go back into forms and learn how to add advanced form features in just a few easy steps. Learn to embed sub forms, add tabs to increase the real estate you have to work with, or even add buttons and combo boxes for extra useful functionalities.
Simple Macros
You can improve the performance of your database using macros to automate actions. Macros in Access are very easy to create -- in this video you'll learn how.
Calculate with Queries
There's no doubt that your tables contain information that can be useful for decision making. By harnessing the calculations provided in queries you can sum, count and average information. You can also compare various pieces of data in a crosstab query or simply view the top 25% of the records with a click of a button. You'll learn how to do all of this in this nugget.
Advanced Reports
Being able to store and easily retrieve and display information is why you create a database. Learn to do this more effectively by taking advantage of pivot charts, sub reports, and by adding graphics that add to your ability to share your data.
Database Tools
While a lot of the focus in Access is on storing and retrieving information, there's still some database administration that needs to happen to keep Access running well. Doing this proactively will ensure your databases are optimized and always up. In this nugget you'll learn how to optimize database performance, split files, and do maintenance including backing up and repairing your databases.
Many databases hold confidential information. That's why assigning users and passwords, plus digitally signing and encrypting databases is important -- these are tools you can use to secure your database and make sure confidential information stays confidential. You'll learn how to do these important security tasks -- including using the Office Trust Center that's new to Office 2007.
External Data
Not all of your tables need to be created from scratch. If the data resides in another application you can import it right into Access and this nugget shows you how. Information can also be part of a larger collaboration on a SharePoint server or be the source for a mail merge in Word. You can even update tables automatically based on results from an Outlook email. Reports can be exported to a PDF or an Office 2007 XPS file. In this video you'll learn all these techniques for importing and exporting your data.
Create an Application
The coolest thing about this nugget is that it teaches you how to let users tap the power of your Access 2007 databases without ever launching Access. You'll learn how to create an application that gives users access to the forms and reports they need without them accidentally going too deep into Access and causing you headaches by clicking on the wrong things.
Exam Preparation
If you are planning on taking the MCAS Access 2007 exam, this nugget is the one for you. All of the exam objectives including the nuggets that map to the objective are listed and key points are reviewed. This is your final step in using this nugget series to help prepare for the exam.

No Bookmarks

This video training with Emily Barry covers Microsoft Access 2007, including topics such as table properties, simple macros, and security. Recommended skills:
  • Familiarity with Microsoft Access 2007
  • Experience working with databases

Recommended equipment:
  • Microsoft Access 2007

Related certifications:
  • Microsoft Office Specialist: Microsoft Office Access 2007

Related job functions:
  • Information workers

In this series, you'll learn all about core functionalities of Access 2007 and prep for 77-605 MOS. You'll soon be creating custom databases that run from your desktop.

Once you watch these videos, you'll know what it takes to get Access up and running, and to use the features you need to input, output, process, and delete data in your Access database. Plus you'll be able to create simple interfaces for your users so even if they're not as skilled as you, you can still give them access to the information stored in your databases.

All trademarks and copyrights are the property of their respective holders.

This forum is for community use – trainers will not participate in conversations. Share your thoughts on training content and engage with other members of the CBT Nuggets community. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
Community Standards

We encourage you to share your wisdom, opinions, and questions with the CBT Nuggets community. To keep things civil, we have established the following policy.

We reserve the right not to post comments that:
contain obscene, indecent, or profane language; contain threats or defamatory statements; contain personal attacks; contain hate speech directed at race, color, sex, sexual orientation, national origin, ethnicity, age, religion, or disability; contributes to a hostile atmosphere; or promotes or endorses services or products. Non-commercial links, if relevant to the topic, are acceptable. Comments are not moderated, however, all comments will automatically be filtered for content that might violate our comment policies. If your comment is flagged by our filter, it will not be published.

We will be continually monitoring published comments and any content that violates our policies will be removed. Users who repeatedly violate our comments policy may be prohibited from commenting.

Course Features

Speed Control

Play videos at a faster or slower pace.


Pick up where you left off watching a video.


Jot down information to refer back to at a later time.

MP3 Downloads

Listen to videos anytime, anywhere
Your browser cannot access Virtual Labs
Add training to a playlist
or create a new list
Add to current playlist
or add to an existing list
Add to new playlist