| Core Services |
| Course Agendas |
| Register/Schedule |
| Cancel/Reschedule |
| Quote Request |
| Assessments |
| Student Resources |
| Classroom Rentals |
| Software Tips |
| Directions |
| Feedback Form |
| Contact Us |
Essentials of Access: Creating Queries and Reports
3 Hours
Versions 2007 and 2010
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 for Specific Records Sorting Records Filtering Records Creating Queries to Extract Information Creating Queries in Design View Adding Query Fields Reviewing Data Types and Criteria Examples Writing Criteria for Queries Running Queries Saving and Closing Queries Modifying Queries Sorting Query Results Performing a Single Field Sort Performing a Multiple Field Sort Deleting Query Fields Printing Query Results Using “AND” Criteria Using “OR” Criteria Creating Multi-Table Queries
|
Creating Basic Reports Creating Reports Using the Wizard Closing Reports Switching Between Report Views Opening Reports Customizing Reports Understanding Report Sections Editing Report Titles Working with Layouts Saving Reports Changing Page Setup Options Printing Reports Creating Mailing Labels |
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 interested 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