Microsoft Access 2013: Illustrated Brief

Praised by instructors for its concise, focused approach and user-friendly format, the Illustrated Series engages both computer rookies and hot shots in mastering Microsoft Access 2013 quickly and efficiently. Skills are accessible and easy-to-follow thanks to the Illustrated Series’ hallmark 2-page layout, which allows students to see an entire task in one view. New Learning Outcomes outline the skills covered in each lesson, and larger full-color screens represent exactly what students should see on their own computers. Each unit begins with a brief overview of the principles of the lesson, and introduces a case study for further application.

Table of Contents

Office 2013
Unit A: Getting Started with Microsoft Office 2013 21
Understand the Office 2013 Suite 22
Start an Office App 24
Identify Office 2013 Screen Elements 26
Create and Save a File 28
Open a File and Save It with a New Name 30
View and Print Your Work 32
Get Help, Close a File, and Exit an App 34
Practice 36

Access 2013
Unit A: Getting Started with Access 2013 37
Understand Relational Databases 38
Explore a Database 40
Create a Database 42
Create a Table 44
Create Primary Keys 46
Relate Two Tables 48
Enter Data 50
Edit Data 52
Practice 54

Unit B: Building and Using Queries 63
Use the Query Wizard 64
Work with Data in a Query 66
Use Query Design View 68
Sort and Find Data 70
Filter Data 72
Apply AND Criteria 74
Apply OR Criteria 76
Format a Datasheet 78
Practice 80

Unit C: Using Forms 89
Use the Form Wizard 90
Create a Split Form 92
Use Form Layout View 94
Add Fields to a Form 96
Modify Form Controls 98
Create Calculations 100
Modify Tab Order 102
Insert an Image 104
Practice 106

Unit D: Using Reports 115
Use the Report Wizard 116
Use Report Layout View 118
Review Report Sections 120
Apply Group and Sort Orders 122
Add Subtotals and Counts 124
Resize and Align Controls 126
Format a Report 128
Create Mailing Labels 130
Practice 132

Cloud
Appendix: Working in the Cloud 141
Understand Office 2013 in the Cloud 142
Work Online 144
Explore SkyDrive 146
Manage Files on SkyDrive 148
Share Files 150
Explore Office Web Apps 152
Team Project 154