Access 2010 Intermediate
- 5.5 hours on-demand video
- 2 downloadable resources
- 1 Practice Test
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business- 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
- Basic Microsoft Windows and Microsoft Access 2010 training or equivalent experience
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.
- 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
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.