Course Description
What You'll Learn
- Design relational databases and create relationships between tables
- Customize table fields, create indexes, and build lookup and logical fields
- Build interactive queries including parameter, multi-criteria, calculated, and action queries
- Use query wizards to find duplicates, unmatched records, and create crosstab queries and PivotTables
- Create forms with subforms, additional controls, tabbed forms, and forms from queries
- Exchange and manipulate data by working with Microsoft Excel and Word
Key Takeaways
- The course advances existing Microsoft Access 2010 skills to a more advanced level.
- It covers designing relational databases and relating tables together.
- Learners use interactive queries to produce reports and create simple macros to automate everyday tasks.
- The course shows how to work with Microsoft Excel and Word to exchange and manipulate data effectively.
- It includes specialty forms such as forms with subforms, tabbed forms, and forms built from queries.
Frequently Asked Questions
Who is this course for?
It is designed for learners who already use Microsoft Access 2010 and want to take their skills to the next level with advanced topics.
What does this course cover?
It covers designing relational databases, relating tables, customizing fields and indexes, building interactive queries, creating forms and subforms, using specialty forms, creating simple macros to automate everyday tasks, and exchanging data with Microsoft Excel and Word.
What types of queries will I learn to build?
You will work with parameter queries, multi-criteria queries, calculated queries, query wizards for finding duplicates and unmatched records, crosstab queries, PivotTables, and action queries such as update, make table, delete, and append queries.
What skills does this course help develop?
It develops skills in Microsoft Access, Access query languages, data access, Microsoft Data Access Components, Microsoft Forms, and Microsoft Office Specialist (MOS) - Access.
Does this course include working with other Microsoft Office programs?
Yes, it includes working with Microsoft Excel and Word to exchange and manipulate data effectively.
