Access 2007 Intermediate

Enhance your Access database skills with our comprehensive course on queries, reports, and forms, designed for Microsoft Certified Application Specialist certification.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course helps you expand your Access database skills. It's all about digging deeper into queries, reports, and making your data work for you. Plus, it sets you up for that Access 2007 exam. Get ready to ace it, my friend!

Key Points

  • Learn to normalize data for better organization.
  • Create join queries to connect different tables.
  • Use advanced report features for printing.
  • Add objects to forms and make them interactive.
  • Use PivotTables and PivotCharts for data analysis.

Learning Outcomes

  • Master the art of table design and creation.
  • Understand how to use relational database concepts.
  • Perform calculations to analyze your data.
  • Build dynamic forms with interactive features.
  • Get ready and confident for the Access 2007 exam.

About This Course

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.

  • Understand relational database concepts

  • Effectively design and create tables

  • Perform calculations

Course Curriculum

1 Lectures

1 Lectures

Instructor

Profile photo of Intellezy Trainers
Intellezy Trainers

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individualsOur library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need...

More Courses By Intellezy Trainers
Review
4.9 course rating
4K ratings
ui-avatar of Hal Brown
Hal B.
5.0
5 years ago

The amount of details being discussed in this course so far are great.

  • Helpful
  • Not helpful
ui-avatar of Jim Elliott
Jim E.
4.0
6 years ago

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.

  • Helpful
  • Not helpful
ui-avatar of Chandrashekhar Pethe
Chandrashekhar P.
5.0
6 years ago

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...

  • Helpful
  • Not helpful
ui-avatar of GUEUS Robert
Gueus R.
5.0
7 years ago

It is great!

  • Helpful
  • Not helpful
ui-avatar of Valmir Figueiredo
Valmir F.
5.0
7 years ago

Apesar de ser tudo em inglĂŞs, Ă© muito bem explicado.

  • Helpful
  • Not helpful
ui-avatar of Marcos QuĂ­lez MartĂ­n
Marcos Q. M.
4.5
7 years ago

Muy completo.

  • Helpful
  • Not helpful
ui-avatar of Elijah
Elijah
4.5
8 years ago

The course is good but I just wished not to have too many short lessons. but otherwise very good course so far.

  • Helpful
  • Not helpful
ui-avatar of Rebecca Roper
Rebecca R.
5.0
8 years ago

Good explanations and examples

  • Helpful
  • Not helpful
ui-avatar of Lisa D. Mijatovic
Lisa D. M.
3.0
9 years ago

There's a lot of stops/starts in the lectures. I can't relate to the premise of the queries since I'm not involved in sales data. Definitions of terms are not given. There are no excerises to apply what is being taught.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses