Access 2010 Intermediate

Enhance your Access databases by mastering queries, advanced reports, and interactive forms with this comprehensive Microsoft Access 2010 course.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course dives into making your Microsoft Access databases more interactive and fun! You’ll learn about table relationships, advanced table design, and how to use action queries with data from Excel. Plus, you’ll get to create awesome forms and reports. Sounds cool, right?

Key Points

  • Understand table relationships
  • Design advanced tables
  • Use action queries with imported data
  • Create interactive forms
  • Generate detailed reports with calculated controls

Learning Outcomes

  • Gain a solid understanding of how table relationships work.
  • Learn to design and set advanced properties for tables.
  • Master action queries for importing and manipulating data.
  • Create interactive forms that enhance user experience.
  • Generate in-depth reports using calculated controls.

About This Course

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.

  • Understand table relationships

  • Design advanced tables

  • Use action queries with imported data

Course Curriculum

1 Lectures

1 Lectures

0 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
4 years ago

So far the videos are greatly detailed and full of useful information.

  • Helpful
  • Not helpful
ui-avatar of Charlie@Enginspire.Co.Uk
Charlie@enginspire.co.uk
4.5
7 years ago

Helped to 'cement' existing knowledge.

  • Helpful
  • Not helpful
ui-avatar of John Thompson
John T.
4.0
7 years ago

Not too sure at the moment

  • Helpful
  • Not helpful
ui-avatar of Fahad M Gohar
Fahad M. G.
4.0
7 years ago

Great instructor but needs to go more deeper into the rest of access functions

  • Helpful
  • Not helpful
ui-avatar of Carolyn V Brown
Carolyn V. B.
4.5
8 years ago

I thought the class was very informative and was done at the right pace. Instructor very knowledgeable.

  • Helpful
  • Not helpful
ui-avatar of Geoff Chown
Geoff C.
4.0
8 years ago

Great detail throughout -- this kind of information is how an end user gets better.

  • Helpful
  • Not helpful
ui-avatar of Lyonel Depestre
Lyonel D.
5.0
8 years ago

Excellent course

  • Helpful
  • Not helpful
ui-avatar of Marco van der Linde
Marco V. D. L.
5.0
8 years ago

Does exactly what is advertised- teach you how to take your Access skills and knowledge to the next level.

  • Helpful
  • Not helpful
ui-avatar of Nicolette Davis
Nicolette D.
5.0
8 years ago

Awesome explanations!
Very detailed and easy to understand as one follows

  • Helpful
  • Not helpful
ui-avatar of Cassondra Dixon
Cassondra D.
5.0
8 years ago

Great Instructor, He speaks very well. I can understand what he's saying. (Proper English). Very informative. I look forward to other courses he maybe teaching. Thank you...

  • 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