Microsoft Access 2007
Part Two
Hours: 8:30 AM - 4:30 PM
Learning Method: Instructor-Led
Upcoming Dates: 5/28/2010
Microsoft Access 2007
Part Two
Register NowRequest Information
Creating Access Forms, Part One
FORMS ARE USED TO COLLECT, VIEW, AND EDIT DATA IN AN EFFICIENT, ORGANIZED MANNER. LEARN TO CREATE THEM, EXPLORING A VARIETY OF FORMATTING TECHNIQUES TO ACHIEVE A PROFESSIONAL APPEARANCE.
Details:
- Use Design View to exert complete control over a new or existing form and include information that should appear at the top or bottom of each record and/or the form itself.
- Arrange elements on a form with ease and precision.
- Add elements to a form that collect data, inform the user, or perform functions. Explore the two types of elements and the three methods for adding them to your piece.
- Use one of Access’ built-in formats to give your form a professional appearance automatically, or create a format that you can save and reuse.
- Set the way in which a form element behaves, as well as the behavior of the form itself.
Enhancing Form Usability, Part Two
ADD POWER TO YOUR FORMS BY ADDING BUTTONS, CALENDARS, AND OTHER ELEMENTS THAT MAKE IT EASY FOR USERS TO RECOGNIZE, ACCESS, AND ENTER INFORMATION. CALL ATTENTION TO INFORMATION BY HAVING IT DISPLAY DIFFERENTLY UNDER CERTAIN CIRCUMSTANCES.
Details:
- Use conditional formatting to have information display a certain way according to set criteria (for example, when the Number in Inventory is fewer than 100, display the field in red).
- Add buttons to your form that make it easy for users to print, skip to a different part of the form, move to the next or previous record, and more.
- Make it easy to organize lengthy forms into manageable, attractive segments appearing as file folder or binder tabs.
- Place a calendar on your form to assist users in adding or managing time-sensitive data.
- Make it easy to view and manage all information related to the current record. For example, while viewing a customer’s information, have Access also display that customer’s orders simply and attractively.
- Add images and other visual elements that add clarity and impact to your form.
Working with Reports
REPORTS LET YOU PRESENT DATA ATTRACTIVELY ON THE PRINTED PAGE. LEARN TO CREATE THEM, EXPLORING A VARIETY OF FORMATTING TECHNIQUES TO ACHIEVE A PROFESSIONAL APPEARANCE. INCLUDE OTHER REPORTS WITHIN YOUR REPORT, DISPLAY SUBTOTALS AND GRAND TOTALS, AND SEND YOUR REPORT TO OTHER USERS.
Details:
- Use Design View to exert complete control over a new or existing report and include information that should appear at the top or bottom of each record, group, and/or the report itself. Arrange elements on a report with ease and precision.
- Add elements to report that collect data, inform the user, or perform functions. Explore the two types of elements and the three methods for adding them to your piece.
- Set the way in which a report element behaves, as well as the behavior of the report itself.
- Use functions to display figures on a report, calculating at detail, group, and/or report level to display subtotals, grand totals, and more.
- Contain other reports within the report you are currently creating, and adjust the layout as necessary to prevent blank pages from printing.
- Use the Snapshot feature to save a report to disk, attach it to an email, use it within other Microsoft applications, and/or share it with others who do not use Access.
Working with Other Microsoft Applications
EXPLORE THE WIDE RANGE OF OPTIONS THAT MAKE IT EXCEPTIONALLY EASY TO INCORPORATE, SHARE, DISPLAY, AND ANALYZE ACCESS DATA IN CONCERT WITH OTHER PROGRAMS.
Details:
- Bring data from a wide variety of other sources into your Access database, and choose whether or not to have data update automatically from either location. Send Access data to other applications for use in documents, spreadsheets, or other databases.
- Use the Office Links Options to integrate Access data with Word documents and to analyze them using Excel.
- Let Access make your data available for viewing and even editing via a Web browser, for use on your company’s Intranet or Wide site.
Working with Macros
RATHER THAN HAVING TO COMPLETE ROUTINE AND/OR COMPLEX TASKS REPEATEDLY, LET ACCESS REMEMBER THE PROCEDURES AND PERFORM THEM FOR YOU AT THE CLICK OF A BUTTON.
Details:
- Easily complete routine and/or complex tasks by storing them as a single command. Tell Access what to do, how to do it, and under what circumstances it should be done.
- Add power to your macros and have them assist users by validating entered data, displaying helpful messages, and running at the click of a command button.