Microsoft Access Training | Los Angeles & Chicago
Fast Facts
Duration
1 day
1 day
Class Size
Max 8 students
Max 8 students
Times
9.00am to 4.30pm
9.00am to 4.30pm
Computer
One per student
One per student
Training Manual
Included
Included
Price
295.00
295.00
Access 2007 - Level 2
Course Description
On this 1 day Access class you will learn how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
Target Audience
This Access course is primarily aimed at people who need to know how to work with data in existing databases. Students should have completed the Access Level 1 course or have a basic knowledge of Microsoft Access, especially building a database file and data tables.
Access Training deals
Found out more about our Microsoft Access Training deals and our 100% Money Back Guarantee.
Learning Objectives
Upon successful completion of this Access training course students will be able to:
- Modify the Design and Field properties of a Table to Streamline Data Entry and Maintain Data Integrity.
- Retrieve Data from Tables using Joins.
- Create Flexible Queries to Display Specified Records, allow for User-Determined Query Criteria, and modify Data using Queries.
- Enhance the Capabilities of a Form.
- Customize Reports to Organize the Displayed Information and Produce Specific Print Layouts.
Upcoming Classes
Chicago |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2007 - Level 2 | Mar 10 ! | Apr 20 ! | May 18 ! | Jun 15 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Access 2007 - Level 2 | Mar 30 | Apr 27 | Jun 2 Jun 29 |
* Class almost full ! Class guaranteed to run † Class is full
Course Outline
Controlling Data Entry
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
Joining Tables
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
Improving Forms
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
Customizing Reports
- Organize Report Information
- Format the Report
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
Sharing Data Across Applications
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
Meet the Instructors
Rich
Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"
"I really enjoyed the instructor, Rich. His hands-on teaching style is very efficient to helping understand the concepts. He was very friendly with the audience and encourage class participation. He was open to your questions and was very helpful to applying what we learn in class to our daily work experience."
Stacy Chears - BMO Capital Markets
"First off Rich had a great attitude and was an all around cool guy. It made the course much more comfortable and a lot more fun. I was very impressed with his take on the whole two day course. The impromptu discussions we had were enjoyable and informative. I appreciated that he was positive about talking off subject. I'd definitely enjoy taking other courses taught by him. A would buy from again, ha."
Eric Miner - Robinson Steel
"It was very helpful that I was able to provide personal examples and the instructor used those examples to help me better understand Access. Relating to current work situations is always more effective learning that textbook, and by being able to use these examples, I think, really helped my understanding."
Carl Saxton - Feeding America
... view bioRich
Access Training Testimonial
"George is an unique teacher whose knowledge in Access is unfathomable. He is very patient and his teaching technique is great. I learned a whole lot in this class and will be able to use it at work. I sincerely thank George, and also the training center for having a great teacher. I look forward to taking some more classes!"
Anonymous -
Access Training Testimonial
"I really enjoyed the instructor, Rich. His hands-on teaching style is very efficient to helping understand the concepts. He was very friendly with the audience and encourage class participation. He was open to your questions and was very helpful to applying what we learn in class to our daily work experience."
Stacy Chears - BMO Capital Markets
Access Training Testimonial
"The instructor, George, went to great lengths to personalize the class for me and my classmate. I was able to ask specific questions about my troubleshooting and got the answers to my questions, as well as an explanation to the larger, overall picture. This class helped me understand Access language as well as how to tackle specific problems. I enjoyed the class very much and would like to come back!"
Rose Reid - Individual
Access Training Testimonial
"First off Rich had a great attitude and was an all around cool guy. It made the course much more comfortable and a lot more fun. I was very impressed with his take on the whole two day course. The impromptu discussions we had were enjoyable and informative. I appreciated that he was positive about talking off subject. I'd definitely enjoy taking other courses taught by him. A would buy from again, ha."
Eric Miner - Robinson Steel
