What you'll learn in this access class:
You will improve and customize tables, queries, forms and reports, and share Access data with other applications.This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft Access.Students will receive a Certificate of Completion at the end of this course and may retake the same course as many times as they want.Upon successful completion of this course, students will be able to:streamline data entry and maintain data integrityjoin tables to retrieve data from unrelated tablescreate flexible queries to display specified records, allow for user-determined query criteriamodify data using queries and improve formscustomize reports to organize the displayed information and produce specific print layoutsshare data between Access and other applicationsPrerequisites:Students are recommended to take the following course or possess equivalent knowledge:Microsoft Access Level 1 2010The Course Curriculum for Microsoft Access 2010 Level 2:Lesson 1: Controlling Data EntryTopic 1A: Constrain Data Entry Using Field PropertiesTopic 1B: Establish Data Entry Formats for Entering Field ValuesTopic 1C: Create a List of Values for a FieldLesson 2: Joining TablesTopic 2A: Create Query JoinsTopic 2B: Join Tables with No Common FieldsTopic 2C: Relate Data Within a TableLesson 3: Creating Flexible QueriesTopic 3A: Set the Select Query PropertiesTopic 3B: Retrieve Records Based on Input CriteriaTopic 3C: Create Action QueriesLesson 4: Improving FormsTopic 4A: Create a PivotTable ReportTopic 4B: Filter Data Using SlicersTopic 4C: Analyze Data Using PivotChartsLesson 5: Customizing ReportsTopic 5A: Organize Report InformationTopic 5B: Format ReportsTopic 5C: Control Report PaginationTopic 5D: Summarize Report InformationTopic 5E: Add a Subreport to an Existing ReportTopic 5F: Create a Mailing Label ReportLesson 6: Sharing Data Across ApplicationsTopic 6A: Import Data into AccessTopic 6B: Export Data to Text File FormatsTopic 6C: Export Access Data to ExcelTopic 6D: Create a Mail Merge
Positive : 
Negative : 
Reviews of School (4)
Tricia Douglas
Posted on
06/09/2013
SQL Level 1
This was a very well organized and appropriately paced class. The instructor encouraged questions and provided very detailed responses whenever possible. The greatest bonus about taking courses at The Career Center is that you can retake them at any time. Huge plus for technical skills that can easily be forgotten if not implemented right away. I am very satisfied and plan to sign up for more classes.
Sofiia Strykova
Posted on
05/20/2013
Customer Service Via Phone and Email
Guys, this class was great! I would recommend it to a friend. I especially liked the work book; it was so so helpful, I'm sure I will use it a couple times or even more. Lots of really good examples there. Lots of advice on how to deal with problems as a customer service representative. Also the teacher - Liz - is such a good person. She has a lot of experience and you can discuss all you need with her.
Garth Miles
Posted on
01/28/2013
Javascript
Greg was great! Very patient and extremely knowledgeable. It was clear that he enjoys teaching this topic.
Morgan
Posted on
05/11/2012
Adobe Photoshop CS5 Level 1
I really enjoyed the class yesterday and I thought that Jesper was such an amazing teacher. He really made the class and the other two women who were with me thought the same! He was so thorough in explaining EVERYTHING and gave each one of us lots of individual time to answer our questions. He made it fun and interesting as well. I learned so much and could not be more pleased!