Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 54 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
Learn how to bring all Access objects together to create a cohesive and effective application
This course builds on the Introduction and Intermediate courses to show techniques to bring all of the different Access objects together to make a cohesive application. It does this by showing the viewer how and why Microsoft Access utilizes the Properties and Events of the different objects. Finally, the course shows the viewer how to create macros using the new Macro editor and how to select the proper Control and Event for the best possible outcome.
Course Content
- 9 section(s)
- 27 lecture(s)
- Section 1 Introduction
- Section 2 Designing The Application
- Section 3 Table Data Macros
- Section 4 Creating Advanced Queries
- Section 5 Advanced Form Design
- Section 6 Macros
- Section 7 System Wrap-Up and Distribution
- Section 8 Conclusion
- Section 9 Access 2010 Advanced Assessment
What You’ll Learn
- Design the application
- Create and use advanced queries
- Use advanced form design
- Create effective reports
- Create and use macros
- Understand importance of documentation
- Distribute the database
Skills covered in this course
Reviews
-
ZZahra Rakhshan
More theoretical part practical exposure needed
-
BBryan Legge
I listen to the entire program on speed 2. as for what could be done better, I did not see a section that spoke about reports or charts, although it is mentioned in the conclusion.
-
FFahad M Gohar
I like the course, but I think there is more to access to understand than just 4 hours of lecture. Student should examine every option available with this application
-
DDoug LeMon
The course has been MOST helpful to me. The Macro editor is a great help. One thing I need help with is: Ex Employee table, I want to concatenate First &", "&Last and then on close form, insert First and Last into a field FullName in the Employee table. I don't know yet how to insert via add or edit an employee first or last name to trigger this macro that then updates the FullName field. Great examples to show things that often happen, and we don't know why!!
