CATEGORY:
Office 2010 Advanced
Access 2010 Advanced
Course Access: Lifetime
Course Overview
Workshop Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the time this course is finished, students should have learned how to:
- Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting
- Expression Builder and logical functions.
- Add, move, remove and format both regular and calculated controls
- Set the Primary Key
- Create a subform, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
- Group and sort data
- Understand, view and edit relationships
- Understand and establish referential integrity
- Sort and filter a query
- Add calculated fields
- Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
- Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
- Use the Database Documenter, analyze table and database performance and repair and compact a database