Essentials of Access: Creating Queries and Reports
3 Hours
Versions 2003 or 2007
Below is a pre-designed course for Creating Queries and Reports in Microsoft Access.
This 3-hour course introduces users to Microsoft Access and demonstrates how to locate records using filters and sorts, create and edit queries to extract data, and design and run reports to print.
Finding, Sorting, and Filtering Records Navigating Through Tables Searching Records Sorting Records Filtering Records Filtering By Selection Filtering By Form Creating Queries to Extract Information Building Queries Specifying Query Fields Reviewing Data Types and Criteria Examples Writing Criteria in Yes/No Fields Viewing or Running the Query Saving and Closing Queries Opening or Modifying Queries Sorting Query Results Performing a Single Field Sort Performing a Multiple Field Sort Deleting Query Fields Printing Query Results Specifying Criteria in Text Fields Using Wildcards When Specifying Criteria Writing Criteria in Numeric Fields Writing Criteria in Date/Time Fields Using “AND” Criteria Using “OR” Criteria
|
Creating Basic Reports Creating Reports Using the Wizard Closing Reports Opening Reports Customizing Reports Understanding Report Sections Editing Report Titles Working with Layouts – 2007 Only Inserting Additional Fields Saving Reports Previewing and Printing Reports Changing Page Setup Options Printing Reports Creating Mailing Labels |
Find us
Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.
Or, are you intersted in scheduling a private group class at your office or at Softek? Learn more about our private group training.
©2008 Softek Services, Inc. All Rights Reserved. - 1156 15th Street, NW Suite 100, Washington, DC 20005 - (202) 747-5000