MOS 2013 Study Guide for Microsoft® Access® by Pierce, John -- Read -- Imperial Library of Trantor

Index

MOS 2013 Study Guide for Microsoft® Access® A Note Regarding Supplemental Files Introduction

Who this book is for How this book is organized Download the practice files Ebook edition Get support and give feedback

Errata We want to hear from you Stay in touch

Taking a Microsoft Office Specialist Exam

Microsoft Office Specialist certification Selecting a certification path Test-taking tips Certification benefits For more information

1. Exam 77-424: Microsoft Access 2013

1. Create and Manage Databases

1.1 Create new databases

Creating desktop databases Creating Access web apps Working with application parts

Inserting blank forms Using Quick Start elements

Using earlier Access file formats

1.2 Manage relationships and keys

Specifying primary keys Setting and viewing relationships

1.3 Navigate through databases

Working with Access views Finding records Configuring the Navigation pane Building navigation forms

1.4 Protect and maintain databases

Compacting and repairing databases Encrypting database files Backing up databases Restoring data from a backup Merging Access databases Splitting databases

1.5 Print and export databases

Printing in Access Working in Print Preview

Page Size options Page Layout options Zoom options

Exporting data

Exporting to Excel Exporting text files Exporting to XML files Saving export steps

Saving databases as templates Using the Save Database As options

Saving files in earlier formats Packaging and signing databases Creating executable files

Objective review

2. Build Tables

2.1 Create a table

Defining tables in Design view Creating tables in Datasheet view Importing data into a table

Importing data from Excel Importing data from another Access database Importing text files

Using linked tables

Linking to a table in another Access database Linking to an Excel worksheet or a text file Managing linked tables

Creating tables in Access web apps

2.2 Format tables

Hiding fields in tables Changing data formats Adding a Total row Adding table descriptions Renaming tables

2.3 Manage records

Adding, updating, and deleting records Appending records Finding, sorting, and filtering data

Finding records Sorting records Filtering records

2.4 Create and modify fields

Adding and deleting fields Working with field properties

Adding validation rules to fields Changing field captions Changing field sizes Setting default values Setting field properties in Design view

Changing field data types Using input masks

Objective review

3. Create Queries

3.1 Create a query

Running queries Saving and deleting queries Creating select queries

Using the Simple Query wizard Using the Query Designer

Creating parameter queries Creating action queries

Using make-table queries Appending records by using a query Updating and deleting records by using a query

Viewing data in a crosstab query

Using the Crosstab Query wizard Creating crosstab queries in Design view

Managing multiple tables and joins

3.2 Modify queries

Changing the fields in a query Showing and hiding query fields Specifying the sort order for queries Formatting fields in a query

3.3 Utilize calculated fields and grouping within queries

Grouping and summarizing query records Using calculated fields Using operators in query criteria and expressions Entering expressions in the Zoom dialog box

Objective review

4. Create Forms

4.1 Create a form

Building forms by using the Form wizard Creating forms in Layout view Creating forms in Design view Creating subforms Setting form properties Saving and deleting forms Creating views in an Access web app

4.2 Set form controls

Adding, moving, and deleting form controls Working with control properties Formatting form controls Modifying data sources Sizing and ordering controls in Design view Working with control layouts in Layout view Managing labels

4.3 Format forms

Setting the tab order for forms Formatting print layouts Sorting records Applying themes to a form Modifying a form’s background Using a form header and footer Inserting images

Objective review

5. Create Reports

5.1 Create a report

Running the Report wizard Building reports in Layout view Using report design tools Using subreports Deleting reports

5.2 Set report controls

Adding controls to a report Managing report fields and properties Formatting report controls Working with labels Modifying data sources Grouping and sorting fields

5.3 Format reports

Applying themes to reports Adding information to report headers and footers Adding backgrounds and images to a report Applying page setup options Adding calculated fields Sorting records in a report

Objective review

Index About the Author Copyright

← Prev
Back
Next →

← Prev
Back
Next →