Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 25 Minute(s)
Language
English
Taught by
Intellezy Trainers
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Expand your Access databases with queries, advanced report and form features and much more
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.
Course Content
- 11 section(s)
- 50 lecture(s)
- Section 1 Introduction
- Section 2 Relational Database Concept Overview
- Section 3 Table Design
- Section 4 Calculations
- Section 5 Multi-Table Queries
- Section 6 Action Queries
- Section 7 Parameter Queries
- Section 8 Calculations in Forms
- Section 9 Advanced Form Functions
- Section 10 Advanced Report Functions
- Section 11 Conclusion
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
Skills covered in this course
Reviews
-
HHal Brown
The amount of details being discussed in this course so far are great.
-
JJim Elliott
Fairly engaging for somewhat dry and tedious Access learning. Most staff here prefer Excel and make the reports in Excel, not using pivot tables, or filters groups or subtotals. Maybe in the course a little "set-up" where what the "sales and the market department" keeps coming back for reports as they think their way through it, and I as the analyst tweak queries and make reports.
-
CChandrashekhar Pethe
I am an absolute beginner for Programming, this course was a pleasant surprise, that it ran me through the course in such a simple way that I could understand nearly everything...
-
GGUEUS Robert
It is great!
