Illustrated Course Guide: Microsoft Access 2010 Basic (Illustrated Course Guides)

✍ Scribed by Lisa Friedrichsen

• Publisher: Course Technology
• Year: 2010
• Tongue: English
• Leaves: 195
• Series: Illustrated Course Guides
• Edition: 1
• Category: Library

✦ Synopsis

Loved by students for the visual and flexible way to build computer skills, the Illustrated Course Guides are ideal for learning Microsoft Access 2010 regardless of your experience level. Each two-page spread focuses on a single skill, making information easy to follow and absorb. The Illustrated Course Guides split Microsoft Access 2010 concepts and skills into three manageable levels - Basic, Intermediate, and Advanced - perfect for workshops or accelerated courses.

✦ Table of Contents

Cover Page......Page 1
Half-Title Page......Page 3
Title Page......Page 5
Copyright Page......Page 6
Brief Contents......Page 7
Contents......Page 9
Preface......Page 12
Office 2010: UNIT A: Getting Started with
Microsoft Office 2010......Page 19
Understanding the Office 2010 Suite......Page 20
Deciding which program to use......Page 21
Using shortcut keys to move between Office programs......Page 22
Windows Live and Microsoft Office Web Apps......Page 23
Viewing the Office 2010 User Interface......Page 24
Using Backstage view......Page 25
Creating and Saving a File......Page 26
Using the Office Clipboard......Page 27
Working in Compatibility Mode......Page 28
Exploring File Open options......Page 29
Customizing the Quick Access toolbar......Page 30
Creating a screen capture......Page 31
Getting Help and Closing a File......Page 32
Recovering a document......Page 33
Practice......Page 34
Access 2010: UNIT A: Getting Started with
Access 2010......Page 35
Understanding Relational Databases......Page 36
Exploring a Database......Page 38
Creating a Database......Page 40
Creating a table in Datasheet View......Page 42
Creating Primary Keys......Page 44
Learning about field properties......Page 45
Relating Two Tables......Page 46
Enforcing referential integrity......Page 47
Changing from Navigation mode to Edit mode......Page 48
Windows Live......Page 49
Resizing and moving datasheet columns......Page 50
Practice......Page 52
UNIT B: Building and Using Queries......Page 59
Using the Query Wizard......Page 60
Working with Data in a Query......Page 62
Using Query Design View......Page 64
Adding or deleting a table in a query......Page 65
Sorting and Finding Data......Page 66
Using wildcard characters......Page 68
Searching for blank fields......Page 70
Applying OR Criteria......Page 72
Formatting a Datasheet......Page 74
Practice......Page 76
UNIT C: Using Forms......Page 83
Using the Form Wizard......Page 84
Creating a Split Form......Page 86
Using Form Layout View......Page 88
Adding Fields to a Form......Page 90
Bound versus unbound controls......Page 91
Modifying Form Controls......Page 92
Creating Calculations......Page 94
Modifying Tab Order......Page 96
Inserting an Image......Page 98
Practice......Page 100
UNIT D: Using Reports......Page 107
Using the Report Wizard......Page 108
Using Report Layout View......Page 110
Reviewing Report Sections......Page 112
Applying Group and Sort Orders......Page 114
Adding Subtotals and Counts......Page 116
Precisely moving and resizing controls......Page 118
Formatting a Report......Page 120
Creating Mailing Labels......Page 122
Practice......Page 124
UNIT E: Modifying the
Database Structure......Page 131
Examining Relational Databases......Page 132
Using many-to-many relationships......Page 133
Specifying the foreign key field data type......Page 134
Creating One-to-Many Relationships......Page 136
More on enforcing referential integrity......Page 137
Creating multivalued fields......Page 138
Modifying Text Fields......Page 140
Working with the Input Mask property......Page 141
Modifying Number and Currency Fields......Page 142
Modifying fields in Datasheet View......Page 143
Modifying Date/ Time Fields......Page 144
Using Smart Tags......Page 145
Modifying Validation Properties......Page 146
Creating Attachment Fields......Page 148
Working with database file types......Page 149
Practice......Page 150
Appendix Web Apps: Working with Windows Live and Office Web Apps......Page 163
Exploring How to Work Online from Windows Live......Page 164
Obtaining a Windows Live ID and Signing In to Windows Live......Page 166
Verifying your Windows Live ID......Page 167
Uploading Files to Windows Live......Page 168
Working with the Power Point Web App......Page 170
Creating Folders and Organizing Files on SkyDrive......Page 172
Adding People to Your Network and Sharing Files......Page 174
Sharing files on SkyDrive......Page 175
Working with the Excel Web App......Page 176
Exploring other Office Web Apps......Page 177
Windows Live and Microsoft Office Web Apps Quick Reference......Page 178
Glossary......Page 179
C......Page 184
E......Page 185
G......Page 186
M......Page 187
P......Page 188
S......Page 189
U......Page 190
Z......Page 191

✦ Subjects

Библиотека;Компьютерная литература;Microsoft Office;Microsoft Access;