Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 18 Minute(s)
Language
English
Taught by
Intellezy Trainers
Rating
Course Overview
Expand your Access databases with queries, advanced report and form features and much more
This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a Table, this course shows you how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. Additionally, this course shows you how to import an Excel spreadsheet and use the different Action Queries to create a relational database. Finally, the course shows how to create interactive forms and reports by adding calculated controls.
Course Content
- 9 section(s)
- 40 lecture(s)
- Section 1 Introduction
- Section 2 Understanding Table Relationships
- Section 3 Introducing Advanced Table Design
- Section 4 Using Action Queries with Imported Data
- Section 5 Creating Calculated and Parameter Queries
- Section 6 Using Advanced Form Features
- Section 7 Advanced Report Functions
- Section 8 Conclusion
- Section 9 Access 2010 Intermediate Assessment
What You’ll Learn
- Understand table relationships
- Design advanced tables
- Use action queries with imported data
- Create and use calculated and parameter queries
- Use advanced form features
- Create and use advanced report functions
Skills covered in this course
Reviews
-
HHal Brown
So far the videos are greatly detailed and full of useful information.
-
CCharlie@Enginspire.Co.Uk
Helped to 'cement' existing knowledge.
-
FFahad M Gohar
Great instructor but needs to go more deeper into the rest of access functions
-
CCarolyn V Brown
I thought the class was very informative and was done at the right pace. Instructor very knowledgeable.
