Note: You need to have the QuickTime player on your computer to view them.
Access 2007 Essential Training
Instructor David Rivers shows how to utilize this powerful software for creating reports and charts, as well as for business record keeping and analysis.
 |
Video: Modifying a form's design Learn how to change the design of an existing form. Explore Design view and learn how to use the formatting tools to change the form's look and feel, including swapping an image or logo, editing form labels, resizing fields, and formatting the form's colors and fonts.
|
|
Video: Creating subforms Forms in Microsoft Access are like windows into the tables in your database. Nesting forms gives you even more insight into the data by allowing you to look at data from more than one table in a single view. Learn how to nest a subform in an existing form, how to create a new form containing subforms with the Access Form Wizard and how to add data to your tables through forms and subforms.
|
|
Video: Adding command buttons to a form Button commands are a type of form control that allows users to automatically navigate, save, delete and even print records in your database. Learn how to insert assorted form controls from the Access ribbon, such as command buttons, lists, and combo boxes, and walk through the Command Button Wizard, which automates the process of adding a print action to a button.
|
|
Video: Sorting and filtering with forms The same sorting and filtering options available in Table view in Microsoft Access are also available when you're working with forms. Learn how to sort records in ascending and descending order using any field, how to filter your records and setup more specialized sorts and filters using selection operators.
|
Excel 2007 Essential Training
Instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, and then moves on to more advanced features, such as working with functions and macros.
|
Video: Preparing to print When you print in Microsoft Excel, you are printing exactly what appears on screen. Learn how to preview how your data will print and adjust your column widths so that no data is left behind.
|
|
Video: Print Preview Learn how to use all of the tools available in Print Preview mode, including Zoom, the Next/Previous Page navigation buttons and the Show Margins feature, which allows you to adjust margins on the fly. This video also includes a quick tip on adding the Print Preview button to your Quick Access toolbar.
|
|
Video: The Page Layout tab The Page Layout tab in Microsoft Excel 2007 contains all of the print layout options in one easy-to-access location. In this movie, you'll review all the tab's features, including how to change the page orientation, define the print area, and change the print size of your documents.
|
|
Video: Adding Page Breaks Learn how to add a page breaks to your spreadsheets to force tables to print onto multiple pages. Also included in this video is a quick lesson on forcing header rows or columns to repeat at the top of left of each printed page.
|
|
Video: The Page Layout View The Page Layout view gives you an opportunity to fine-tune the look and feel of your document before you print it out. Learn how to change the view options, such as headings and gridlines, and scale your documents.
|
|
Video: Adding Headers and Footers Learn how to add headers and footers to your spreadsheets , which in Excel 2007 can now be inserted directly in Page Layout view using the Header & Footer tools. Also learn how to insert automatic header and foot elements, such as current date, current time, file path, and more.
|
Watch more Microsoft Office 2007 training from lynda.com
United Kingdom
Printer-Friendly Version
