By reading this workbook you will be able 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