Access 2010 Intermediate
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
Requirements
- Basic Microsoft Windows and Microsoft Access 2010 training or equivalent experience
Description
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.
Who this course is for:
- Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features
Course content
- Preview03:07
Instructor
![Intellezy Trainers](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 39,737 Reviews
- 150,299 Students
- 227 Courses
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.