Access 2013 Intermediate ( 2 Days)
- This event has passed.
You have the basic skills needed to work with Microsoft® Office Access™ 2013 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
Who is this course for?
Microsoft Office Access 2013: Intermediate is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Intermediate course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2013.
Pre-requisites
- Microsoft Office Access 2013: Basic
Course content
Unit 1: Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
Unit 2: Related tables
- Lookup fields
- Modifying lookup fields
- Subdatasheets
Unit 3: Complex queries
- Joining tables in queries
- Calculated fields
- Summarizing and grouping values
Unit 4: Advanced form design
- Adding unbound controls
- Adding Graphics
- Adding calculated values
- Adding combo boxes
- Advanced form types
Unit 5: Reports and printing
- Customized headers and footers
- Adding calculated values
- Printing
- Labels
Unit 6: Charts
- Charts in forms
- Charts in reports
Unit 7: PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
- PivotTable forms