Getting Started

Welcome to the Access 2010 Advanced Course. You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL and publish a Web database—among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!

Course Objectives

At the end of this Course, you should be able 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

Pre-Assignment

The purpose of the Pre-Assignment is to get you thinking about the features of Excel that you are already using and where you need or want to improve. Review the list of topics and use a rating system to indicate your interest in the topic. Take a moment to review the list and highlight areas of interest.