MOS 2013 Study Guide for Microsoft® Access®

Table of contents

1. Introduction
   1. Who this book is for
   2. How this book is organized
   3. Download the practice files
   4. Get support and give feedback
      1. Errata
      2. We want to hear from you
      3. Stay in touch
2. Taking a Microsoft Office Specialist Exam
   1. Microsoft Office Specialist certification
   2. Selecting a certification path
   3. Test-taking tips
   4. Certification benefits
   5. For more information
3. 1. Exam 77-424: Microsoft Access 2013
   1. 1. Create and Manage Databases
      1. 1.1 Create new databases
         1. Creating desktop databases
         2. Creating Access web apps
         3. Working with application parts
            1. Inserting blank forms
            2. Using Quick Start elements
         4. Using earlier Access file formats
      2. 1.2 Manage relationships and keys
         1. Specifying primary keys
         2. Setting and viewing relationships
      3. 1.3 Navigate through databases
         1. Working with Access views
         2. Finding records
         3. Configuring the Navigation pane
         4. Building navigation forms
      4. 1.4 Protect and maintain databases
         1. Compacting and repairing databases
         2. Encrypting database files
         3. Backing up databases
         4. Restoring data from a backup
         5. Merging Access databases
         6. Splitting databases
      5. 1.5 Print and export databases
         1. Printing in Access
         2. Working in Print Preview
            1. Page Size options
            2. Page Layout options
            3. Zoom options
         3. Exporting data
            1. Exporting to Excel
            2. Exporting text files
            3. Exporting to XML files
            4. Saving export steps
         4. Saving databases as templates
         5. Using the Save Database As options
            1. Saving files in earlier formats
            2. Packaging and signing databases
            3. Creating executable files
      6. Objective review
   2. 2. Build Tables
      1. 2.1 Create a table
         1. Defining tables in Design view
         2. Creating tables in Datasheet view
         3. Importing data into a table
            1. Importing data from Excel
            2. Importing data from another Access database
            3. Importing text files
         4. Using linked tables
            1. Linking to a table in another Access database
            2. Linking to an Excel worksheet or a text file
            3. Managing linked tables
         5. Creating tables in Access web apps
      2. 2.2 Format tables
         1. Hiding fields in tables
         2. Changing data formats
         3. Adding a Total row
         4. Adding table descriptions
         5. Renaming tables
      3. 2.3 Manage records
         1. Adding, updating, and deleting records
         2. Appending records
         3. Finding, sorting, and filtering data
            1. Finding records
            2. Sorting records
            3. Filtering records
      4. 2.4 Create and modify fields
         1. Adding and deleting fields
         2. Working with field properties
            1. Adding validation rules to fields
            2. Changing field captions
            3. Changing field sizes
            4. Setting default values
            5. Setting field properties in Design view
         3. Changing field data types
         4. Using input masks
      5. Objective review
   3. 3. Create Queries
      1. 3.1 Create a query
         1. Running queries
         2. Saving and deleting queries
         3. Creating select queries
            1. Using the Simple Query wizard
            2. Using the Query Designer
         4. Creating parameter queries
         5. Creating action queries
            1. Using make-table queries
            2. Appending records by using a query
            3. Updating and deleting records by using a query
         6. Viewing data in a crosstab query
            1. Using the Crosstab Query wizard
            2. Creating crosstab queries in Design view
         7. Managing multiple tables and joins
      2. 3.2 Modify queries
         1. Changing the fields in a query
         2. Showing and hiding query fields
         3. Specifying the sort order for queries
         4. Formatting fields in a query
      3. 3.3 Utilize calculated fields and grouping within queries
         1. Grouping and summarizing query records
         2. Using calculated fields
         3. Using operators in query criteria and expressions
         4. Entering expressions in the Zoom dialog box
      4. Objective review
   4. 4. Create Forms
      1. 4.1 Create a form
         1. Building forms by using the Form wizard
         2. Creating forms in Layout view
         3. Creating forms in Design view
         4. Creating subforms
         5. Setting form properties
         6. Saving and deleting forms
         7. Creating views in an Access web app
      2. 4.2 Set form controls
         1. Adding, moving, and deleting form controls
         2. Working with control properties
         3. Formatting form controls
         4. Modifying data sources
         5. Sizing and ordering controls in Design view
         6. Working with control layouts in Layout view
         7. Managing labels
      3. 4.3 Format forms
         1. Setting the tab order for forms
         2. Formatting print layouts
         3. Sorting records
         4. Applying themes to a form
         5. Modifying a form’s background
         6. Using a form header and footer
         7. Inserting images
      4. Objective review
   5. 5. Create Reports
      1. 5.1 Create a report
         1. Running the Report wizard
         2. Building reports in Layout view
         3. Using report design tools
         4. Using subreports
         5. Deleting reports
      2. 5.2 Set report controls
         1. Adding controls to a report
         2. Managing report fields and properties
         3. Formatting report controls
         4. Working with labels
         5. Modifying data sources
         6. Grouping and sorting fields
      3. 5.3 Format reports
         1. Applying themes to reports
         2. Adding information to report headers and footers
         3. Adding backgrounds and images to a report
         4. Applying page setup options
         5. Adding calculated fields
         6. Sorting records in a report
      4. Objective review
4. Index
5. About the Author
6. Copyright