Skip to search results
PRODUCT
Office.com results
Datasheets III: Make data easier to read by formatting columns and rows
Training Overview Make your data easier to read and understand by reorganizing the columns, and by formatting the rows, text, and colors in your Access 2007 datasheets...
Access 2007
Build relationships for a new Access 2007 database
Training Overview Learn how to create relationships among your database tables. Relationships bring the data in your tables together. That enables you to find informati...
Access 2007
Queries VIII: Dealing with ambiguous joins
Training Overview Learn how to resolve ambiguous outer joins . When you build a multi-source query, you sometimes get an error message that says you have an "ambiguous o...
Access 2007
Queries I: Get started with queries
Training Overview Learn how to create queries . Queries retrieve information from your database, and they can also do some heavy lifting, such as calculating the sales f...
Access 2007
Choose between Access and Excel
Training Overview Confused about whether to use Access or Excel? Learn how to choose the right program for your needs. After completing this course you will be able t...
Access 2007, Excel 2007
Queries III: Use expressions and other criteria
Training Overview Learn to use formulas and expressions in your queries . Formulas can give you critical business information with a single click, and expressions can he...
Access 2007
Create forms for a new Access 2007 database
Training Overview Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accu...
Access 2007
Queries II: Create basic select queries
Training Overview Learn how to create basic select queries . Select queries retrieve data from your database, and they're one of the most frequently used and versatile ...
Access 2007
Take charge of your database with the Navigation Pane
Training Overview Learn how to use the Navigation Pane , a powerful tool that helps you make sense of and run your database. After completing this course you will be abl...
Access 2007
Keyboard shortcuts in the 2007 Office system
Training Overview Many of the programs in the 2007 Microsoft Office system have a brand-new look. Most menus and toolbars have gone away, and along with the new look co...
Access 2007, Excel 2007...
Up to speed with the 2007 Office system
Training Overview Get an introduction to the new look in familiar programs of the 2007 Microsoft Office system. Then try out the changes with a hands-on test drive. Aft...
Access 2007, Excel 2007...
Security I: How the 2007 Office system helps you to stay safer
Training Overview Find out about security risks to your computer and ways to help to protect it, as well as how the 2007 Microsoft Office system new file formats help t...
Access 2007, Excel 2007...
Easy Access with Templates II: Modify a database
Training Overview You've just created an Access 2007 database by using a template. But you need to make a few changes to the datab ase. This course shows you how. After...
Access 2007
Access 2007 training courses
Article A roadmap to Access 2007 training: 1. Get familiar with Access Course What you'll learn Choose between Access and Excel When to use Access and when to use Excel...
Access 2007
Easy Access with templates I: Create a database
Training Overview Do you want to create a database but don’t know how? Not a problem, use an Access 2007 template. After completing this course you will be able to: F...
Access 2007
Design tables for a new Access 2007 database
Training Overview Learn how to design the tables for a database that meets your organization's data needs and is easier to use and maintain. You start with a plan becau...
Access 2007
Security III: Sign your own macros for stronger security
Training Overview Learn why signing your own macros will reduce the number of security warnings you see while still maintaining a high security level, and find out how ...
Access 2007, Excel 2007...
Security II: Turn off the Message Bar and run code safely
Training Overview Learn how to turn off the Message Bar and its security warnings . This course explains how to turn off the Message Bar by "trusting" digital certificat...
Access 2007, Excel 2007...
Import data from Excel to a new table in Access 2007
Training Learn how to import data from Excel into a new table in Access. Importing is a faster way to put Access to work for you.
Access 2007, Excel 2007
Queries VI: Use wildcards in queries and parameters
Training Overview Learn how to use wildcards in your queries . Wildcards can make your queries more flexible and powerful, and help you find data in less time. After com...
Access 2007
Datasheets II: Sum, sort, filter, and find your data
Training Overview Perform calculations on your data quickly and easily. In Access, your data resides in tables. Most of the time, you work with your information in D...
Access 2007
Datasheets I: Create a table by entering data
Training Overview Learn how to enter data in Access quickly and easily — just a few mouse clicks — with the new design features in Datasheet view. Go on, explore! Aft...
Access 2007
Queries VII: Query multiple sources for data
Training Overview Learn how to create a query that takes data from two or more sources — tables or queries . You'll probably need to query multiple sources more than you...
Access 2007
Learn the structure of an Access database
Article Show All Hide All Becoming familiar with the tables, forms, queries, and other objects in a database can make it easier to perform a wide variety of tasks, such...
Access 2007
Queries IV: Use functions and calculated fields in your queries
Training Overview Learn how to use functions and calculated fields in your queries . Access 2007 provides built-in functions that sum, count, and average data. You can a...
Access 2007
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com