| Core Services |
| Course Agendas |
| Register/Schedule |
| Cancel/Reschedule |
| Quote Request |
| Assessments |
| Student Resources |
| Classroom Rentals |
| Software Tips |
| Directions |
| Feedback Form |
| Contact Us |
Microsoft Access Advanced
1 Day
Versions 2007 and 2010 (View Version 2003 Agenda)
This instructor-led course, through lecture and hands-on exploration, will teach you the skills needed to create complex queries to validate and analyze data, add advanced elements to existing forms and reports, and work with features that automate the database and allow for multi-user access. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Access and Intermediate Access courses or have equivalent knowledge. You should feel comfortable creating basic queries, forms and reports in Access.
Creating Queries to Validate and Creating Crosstab Queries Editing Crosstab Queries Creating Crosstabs Using Dates Finding Duplicate Records Finding Matches and Non-Matches Creating Union Queries Adding Advanced Form Elements Changing the View of Subforms Working with Tab Controls Saving Forms as Reports Adding Advanced Report Elements Changing the Record Source of Objects Including Parameters in Report Titles Creating Basic Macros Creating Macros to Preview Reports Attaching Macros to Command Buttons Running Macros
|
Creating a Switchboard or Main Menu Creating Main Menu Switchboards Adding Items to Switchboards Opening Switchboards Creating Additional Switchboards Navigating Between Switchboards Viewing Switchboard Items Displaying Switchboards on Startup Sharing and Maintaining a Database Sharing Databases on a Network Opening Databases in Exclusive Mode Setting Database Passwords Linking Tables between Databases Compacting and Repairing Databases Using the Back Up Database Feature Printing Database Object Information
|
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