Training Overview Learn how to create relationships among your database tables. Relationships bring the data in your tables together. That enables you to find information...
Training This training course will show you how to use the spelling and grammar checker in a Word 2007 document that has text in four different languages.
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...
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...
Training Overview Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports. ...
Training Overview Learn how to create reports . In Access, reports help others understand your data and answer critical business questions. After completing this...
Training Overview Learn how to build the tables for a new database . Tables are the backbone of a database, so building them well is a critical step. This course...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Training Overview Learn to use formulas and expressions in your queries . Formulas can give you critical business information with a single click, and expressions...
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...
Training Overview Learn how to use conditions with the "And", "Or", and "In" operators in queries . These operators can help you find data that matches multiple...
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...
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...
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...
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...
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...
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...
