Deze website maakt gebruik van cookies. Klik hier voor meer informatie.X sluit
Uitgebreid zoeken

Microsoft Access 2013


Microsoft Access 2013 - Poatsy, Mary Anne (EDT)/ Krebs, Cynthia (EDT)/ Cameron, Eric (EDT) - ISBN: 9780133412192
Prijs: € 102,95
Levertijd: 5 tot 15 werkdagen
Bindwijze: Boek, Paperback (02-07-2013)
Genre: Databases
Microsoft Access 2013 op
Add to cart


This book covers introductory Access.

Move students beyond the point-and-click.


The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.


Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.

NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.


Used books, rentals, and purchases made outside of Pearson

If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.



Titel: Microsoft Access 2013
auteur: Poatsy, Mary Anne (EDT)/ Krebs, Cynthia (EDT)/ Cameron, Eric (EDT)
Mediatype: Boek
Bindwijze: Paperback
Taal: Engels
Druk: 1
Aantal pagina's: 322
Uitgever: Pearson College Div
Plaats van publicatie: 01
Publicatiedatum: 02-07-2013
NUR: Databases
Afmetingen: 273 x 228 x 19
Gewicht: 771 gr
ISBN/ISBN13: 9780133412192
Intern nummer: 24407257


Microsoft Office 2013

Chapter One Office Fundamentals and File Management: Taking the First Step 1

Objectives¿¿¿¿¿¿¿¿ 1

Case Study: Spotted Begonia Art Gallery 1

Windows 8 Startup 2

Logging In with Your Microsoft Account 2

Identifying the Start Screen Components 3

Interacting with the Start Screen 4

Accessing the Desktop 4

Hands-On Exercise 1:

Windows 8 Startup 6

Files and Folders¿¿¿¿¿¿¿¿ 10

Using File Explorer 10

Working with Folders and Files 13

Selecting, Copying, and Moving Multiple Files and Folders 15

Hands-On Exercise 2:

Files and Folders 17

Microsoft Office Software 22

Identifying Common Interface Components 22

Getting Office Help 28

Hands-On Exercise 3:

Microsoft Office Software 31

The Backstage View Tasks¿¿¿¿¿¿¿¿ 36

Opening a File 36

Printing a File 38

Closing a File and Application 39

Hands-On Exercise 4:

The Backstage View Tasks 41

Home Tab Tasks¿¿¿¿¿¿¿¿ 45

Selecting and Editing Text 45

Using the Clipboard Group Commands 49

Using the Editing Group Commands 52

Hands-On Exercise 5:

Home Tab Tasks 55

Insert Tab Tasks¿¿¿¿¿¿¿¿ 60

Inserting Objects 60

Review Tab Tasks¿¿¿¿¿¿¿¿ 62

Reviewing a File 62

Page Layout Tab Tasks¿¿¿¿¿¿¿¿ 65

Using the Page Setup Dialog Box 66

Hands-On Exercise 6:

Insert Tab Tasks, Page Layout Tab Tasks, and

Review Tab Tasks 68

Chapter Objectives Review¿¿¿¿¿¿¿¿ 72

Key Terms Matching¿¿¿¿¿¿¿¿ 73

Multiple Choice 74

Practice Exercises¿¿¿¿¿¿¿¿ 75

Mid-Level Exercises¿¿¿¿¿¿¿¿ 79

Beyond the Classroom¿¿¿¿¿¿¿¿ 81

Capstone Exercise 82


Microsoft Office Access 2013

Chapter One Introduction to Access: Finding Your Way Through an Access Database 83

Objectives¿¿¿¿¿¿¿¿ 83

Case Study: Managing a Business in the Global

Economy 83

Databases Are Everywhere! 84

Understanding Database Fundamentals 84

Using an Existing Database 91

Hands-On Exercise 1:

Databases Are Everywhere! 95

Sorts and Filters¿¿¿¿¿¿¿¿ 102

Sorting Table Data on One or Multiple Fields 102

Creating, Modifying, and Removing Filters 103

Hands-On Exercise 2:

Sorts and Filters 106

Access Versus Excel, and Relational Databases¿¿¿¿¿¿¿¿ 111

Knowing When to Use Access or Excel to Manage Data 111

Understanding Relational Power 112

Hands-On Exercise 3:

Access Versus Excel, and Relational Databases 115

Access Database Creation¿¿¿¿¿¿¿¿ 119

Creating a Database 119

Hands-On Exercise 4:

Access Database Creation 123

Chapter Objectives Review¿¿¿¿¿¿¿¿ 127

Key Terms Matching¿¿¿¿¿¿¿¿ 128

Multiple Choice 129

Practice Exercises¿¿¿¿¿¿¿¿ 130

Mid-Level Exercises¿¿¿¿¿¿¿¿ 135

Beyond the Classroom¿¿¿¿¿¿¿¿ 139

Capstone Exercise 140


Chapter Two Tables and Queries in Relational Databases: Designing

Databases and Extracting Data 141

Objectives¿¿¿¿¿¿¿¿ 141

Case Study: Bank Audit 141

Table Design, Creation, and Modification¿¿¿¿¿¿¿¿ 142

Designing a Table 142

Creating and Modifying Tables 146

Hands-On Exercise 1:

Table Design, Creation, and Modification 152

Multiple-Table Databases¿¿¿¿¿¿¿¿ 157

Sharing Data 157

Establishing Table Relationships 160

Hands-On Exercise 2:

Multiple-Table Databases 165

Single-Table Queries¿¿¿¿¿¿¿¿ 171

Creating a Single-Table Query 171

Specifying Query Criteria for Different Data Types 173

Understanding Query Sort Order 177

Running, Copying, and Modifying a Query 177

Using the Query Wizard 178

Hands-On Exercise 3:

Single-Table Queries 181

Multitable Queries¿¿¿¿¿¿¿¿ 184

Creating a Multitable Query 184

Modifying a Multitable Query 185

Hands-On Exercise 4:

Multitable Queries 189

Chapter Objectives Review¿¿¿¿¿¿¿¿ 193

Key Terms Matching¿¿¿¿¿¿¿¿ 195

Multiple Choice 196

Practice Exercises¿¿¿¿¿¿¿¿ 197

Mid-Level Exercises¿¿¿¿¿¿¿¿ 202

Beyond the Classroom¿¿¿¿¿¿¿¿ 206

Capstone Exercise 208


Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions 211

Objectives¿¿¿¿¿¿¿¿ 211

Case Study: Housing Slump Means Opportunity

For College Students¿¿¿¿¿¿¿¿ 211

Calculations and Expressions¿¿¿¿¿¿¿¿ 212

Creating a Calculated Field in a Query 212

Formatting and Saving Calculated Results 215

Hands-On Exercise 1:

Calculations and Expressions 218

The Expression Builder and Functions¿¿¿¿¿¿¿¿ 223

Creating Expressions with the Expression Builder 223

Using Built-In Functions in Access 225

Hands-On Exercise 2:

The Expression Builder and Functions 228

Aggregate Functions¿¿¿¿¿¿¿¿ 233

Adding Aggregate Functions to Datasheets 233

Creating Queries with Aggregate Functions 234

Hands-On Exercise 3:

Aggregate Functions 240

Chapter Objectives Review¿¿¿¿¿¿¿¿ 243

Key Terms Matching¿¿¿¿¿¿¿¿ 244

Multiple Choice 245

Practice Exercises¿¿¿¿¿¿¿¿ 246

Mid-Level Exercises¿¿¿¿¿¿¿¿ 249

Beyond the Classroom¿¿¿¿¿¿¿¿ 253

Capstone Exercise 255


Chapter Four Creating and Using Professional Forms and Reports:

Moving Beyond Tables and Queries 257

Objectives¿¿¿¿¿¿¿¿ 257

Case Study: Coffee Shop Starts New Business¿¿¿¿¿¿¿¿ 257

Form Basics¿¿¿¿¿¿¿¿ 258

Creating Forms Using Form Tools 258

Using Form Views 265

Working with a Form Layout Control 268

Sorting Records in a Form 270

Hands-On Exercise 1:

Form Basics 272

Report Basics¿¿¿¿¿¿¿¿ 278

Creating Reports Using Report Tools 278

Using Report Views 285

Modifying a Report 287

Sorting Records in a Report 290

Hands-On Exercise 2:

Report Basics 292

Chapter Objectives Review¿¿¿¿¿¿¿¿ 296

Key Terms Matching¿¿¿¿¿¿¿¿ 298

Multiple Choice 299

Practice Exercises¿¿¿¿¿¿¿¿ 300

Mid-Level Exercises¿¿¿¿¿¿¿¿ 303

Beyond the Classroom¿¿¿¿¿¿¿¿ 306

Capstone Exercise 307

Application Capstone Exercise
Access 309

Glossary 313


Dit product is op dit moment niet op voorraad in een van onze vestigingen.