| Core Services |
| Course Agendas |
| Register/Schedule |
| Cancel/Reschedule |
| Quote Request |
| Assessments |
| Student Resources |
| Classroom Rentals |
| Software Tips |
| Directions |
| Feedback Form |
| Contact Us |
Microsoft Access Intermediate
1 Day
Versions 2007 and 2010 (View Version 2003 Agenda)
This instructor-led course, through lecture and hands-on exploration, will show you how to create more complex databases that link multiple tables; work with more advanced elements in tables, forms, queries, and reports; and import and export data to and from Access. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Access 2007 course or have equivalent knowledge. This course is geared for users who need to create more complex databases projects. You should feel comfortable creating basic tables, forms, queries, and reports.
Importing Information from Other Sources Understanding Data Sources Access Importing Excel Workbooks Importing Text Files Importing Access Tables Appending Records from One Table to Another Applying Field Properties to Creating Lookups Creating Input Masks Specifying Default Values Enhancing Data Entry Forms Updating Fields with Property Changes Shortcuts for Selecting Objects Automatically Aligning Objects Automatically Sizing Objects Automatically Spacing Objects Adjusting the Tab Order Adding Command Buttons to Forms Creating More Advanced Queries Using Parameters to Prompt for Criteria Writing Expressions or Calculations
|
Creating More Advanced Queries Creating Total Queries Working with Update Queries Running Queries to Archive Information Enhancing Reports Creating Reports Using the Report Tool Sorting and Grouping Data Inserting Graphic Lines Previewing Pages in Print Preview Keeping Records Together Repeating Group Headers on the Top of Every Page Writing Expressions and Calculations on Reports Exporting Information Out of Access Exporting Tables and Queries to Excel Exporting Reports to Word Using Access Tables or Queries in a |
Related Courses
Access - VBA Programming Agenda
Not Sure What Level to Take?
Before taking the Intermediate or Advanced level class for this application, we ask that you take our free assessment to determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.
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