Course Catalog > Microsoft Office Training > Intermediate Microsoft Access 2007
Intermediate Microsoft Access 2007
Intermediate Microsoft Access 2007 (1 Day)
Our Access 2003 relational database training courses will help you learn how to build, maintain, and implement relational databases.
Whether you are new to Microsoft Access or an advanced user, Current Technologie's Microsoft Certified Trainers will make you a Microsoft Access guru.
Intermediate Microsoft Access 2007 is for those who have the basic skills using Access and want to learn how to enhance database designs by using the principals of table relationships & referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters & queries, customize forms & reports, and create data access pages .
Come Experience the Current Technologies Computer Learning Center Way of training. We take great care of all of our students.
The CTCLC Difference
Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Intended Audience
Microsoft Office Intermediate Access 2007 course is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. - The Intermediate Access 2007 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications.
- This course is also a prerequisite to taking more advanced courses in Access 2007.
- Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
Course Objectives
Upon successful completion of this 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 by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.
- Customize reports to organize the displayed information and produce specific print layouts.
- Share data across different applications.
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Intermediate Microsoft Access 2007 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Intermediate Microsoft Access 2007 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Intermediate Microsoft Access 2007
Lesson 1: Controlling Data Entry
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Crate a List of Values for a Field
Lesson 2: Joining Tables
- Create Query Joins
Join Unrelated Tables- Relate Data within a Table
Lesson 3: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
Lesson 4: 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
Lesson 5: Customizing Reports
- Organize Report Information
- Modify the Report Layout
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
- Import Data into Access
- Export Data to a Word Document
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Certified Application Specialist (MCAS) - Access | ||
For More Information About Intermediate Microsoft Access 2007 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800