Access 2007 Intermediate
What you'll learn
- Understand relational database concepts
- Effectively design and create tables
- Perform calculations
- Create multi-table, action and parameter queries
- Work with advanced form functions and advanced report functions
Requirements
- Basic Microsoft Windows and Microsoft Access 2007 training or equivalent experience
Description
This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.
Who this course is for:
- Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features
Course content
- Preview01:30
Instructor
![Intellezy Trainers](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 46,735 Reviews
- 164,586 Students
- 246 Courses
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.