Rating 0 out of 5 (0 ratings in Udemy)
What you'll learn- Design a relational database
- Create a related table
- Create query joins
- Relate data within a table
- Work with sub-datasheets
- Use field, form and record validation
- Create parameter queries and sub-queries
- Create unmatched and duplicate queries
- Normalize and de-normalize data
- Include control formatting in a report
- Add a calculated field to a report
- Create PivotTable
DescriptionThe Microsoft Office Access 2010: Intermediate …
Rating 0 out of 5 (0 ratings in Udemy)
What you'll learn- Design a relational database
- Create a related table
- Create query joins
- Relate data within a table
- Work with sub-datasheets
- Use field, form and record validation
- Create parameter queries and sub-queries
- Create unmatched and duplicate queries
- Normalize and de-normalize data
- Include control formatting in a report
- Add a calculated field to a report
- Create PivotTable
DescriptionThe Microsoft Office Access 2010: Intermediate course builds upon basic Microsoft Access skills acquired in Access 2010 Level 1 course to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage and normalize data, manage table relationships, enforce referential integrity, work with lookup fields and subdatasheets, create join queries, calculated fields and summary values, add objects to forms, and learn to create advanced form types, print reports and labels, and understand the functionalities of PivotTables and PivotCharts.
Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2010 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2010.
