New Perspectives on Microsoft Office Access 2010, Introductory

Cover Page......Page 1
Title Page......Page 5
Copyright Page......Page 7
Preface......Page 8
BRIEF CONTENTS......Page 12
TABLE OF CONTENTS......Page 14
GETTING STARTED WITH MICROSOFT\nOFFICE 2010\nPreparing a Meeting Agenda......Page 20
Exploring Microsoft Office 2010......Page 23
Starting Office Programs......Page 24
Switching Between Open Programs and Files......Page 26
Resizing the Program Window and Workspace......Page 27
Zooming and Scrolling......Page 28
Using the Ribbon......Page 30
Clicking Buttons......Page 31
Opening Dialog Boxes and Task Panes......Page 33
Accessing the Mini Toolbar......Page 35
Opening Shortcut Menus......Page 36
Working with Files......Page 37
Saving a File......Page 38
Opening a File......Page 41
Sharing Files Using Windows Live SkyDrive......Page 43
Viewing ScreenTips......Page 44
Using the Help Window......Page 45
Printing a File......Page 47
Quick Check......Page 49
Review Assignments......Page 50
ProSkills Exercise: Teamwork......Page 51
Tutorial 1: Creating a Database: Creating a Database to Contain Customer, Contract, and Invoice Data......Page 52
SESSION 1.1......Page 53
Introduction to Database Concepts......Page 55
Creating a Database......Page 58
Creating a Table in Datasheet View......Page 60
Session 1.1 Quick Check......Page 72
SESSION 1.2......Page 73
Copying Records from Another Access Database......Page 75
Navigating a Datasheet......Page 77
Creating a Simple Query......Page 78
Creating a Simple Form......Page 81
Creating a Simple Report......Page 83
Viewing Objects in the Navigation Pane......Page 88
Managing a Database......Page 89
Session 1.2 Quick Check......Page 92
Review Assignments......Page 93
Case Problems......Page 94
Tutorial 2: Building a Database and Defining Table Relationships: Creating the Invoice and Customer Tables......Page 100
SESSION 2.1......Page 101
Guidelines for Designing Databases......Page 103
Guidelines for Setting Field Properties......Page 105
Changing the Format of a Field in Datasheet View......Page 108
Creating a Table in Design View......Page 110
Modifying the Structure of an Access Table......Page 119
Session 2.1 Quick Check......Page 122
SESSION 2.2......Page 123
Adding Records to a New Table......Page 125
Importing Data from an Excel Worksheet......Page 127
Creating a Table by Importing an Existing Table Structure......Page 130
Adding Fields to a Table Using the Data Type Gallery......Page 133
Modifying the Imported Table......Page 134
Adding Data to a Table by Importing a Text File......Page 140
Defining Table Relationships......Page 142
Session 2.2 Quick Check......Page 148
Review Assignments......Page 149
Case Problems......Page 150
Tutorial 3: Maintaining and Querying a Database: Updating and Retrieving Information About Customers, Contracts, and Invoices......Page 160
SESSION 3.1......Page 161
Updating a Database......Page 163
Introduction to Queries......Page 167
Creating and Running a Query......Page 169
Updating Data Using a Query......Page 171
Creating a Multitable Query......Page 172
Sorting Data in a Query......Page 174
Filtering Data......Page 178
Session 3.1 Quick Check......Page 180
SESSION 3.2......Page 181
Defining Record Selection Criteria for Queries......Page 183
Defining Multiple Selection Criteria for Queries......Page 192
Creating a Calculated Field......Page 196
Using Aggregate Functions......Page 202
Working with the Navigation Pane......Page 206
Session 3.2 Quick Check......Page 208
Review Assignments......Page 209
Case Problems......Page 210
Tutorial 4: Creating Forms and Reports: Using Forms and Reports to Display Customer and Contract Data......Page 216
SESSION 4.1......Page 217
Creating a Form Using the Form Wizard......Page 219
Modifying a Form’s Design in Layout View......Page 221
Navigating a Form......Page 229
Finding Data Using a Form......Page 230
Maintaining Table Data Using a Form......Page 233
Previewing and Printing Selected Form Records......Page 235
Session 4.1 Quick Check......Page 236
SESSION 4.2......Page 237
Creating a Form with a Main Form and a Subform......Page 239
Creating a Report Using the Report Wizard......Page 243
Modifying a Report’s Design in Layout View......Page 248
Using Conditional Formatting in a Report......Page 252
Session 4.2 Quick Check......Page 255
Review Assignments......Page 256
Case Problems......Page 257
ProSkills Exercise: Teamwork......Page 264
Tutorial 5: Creating Advanced Queries and Enhancing Table Design: Making the Panorama Database Easier to Use......Page 268
SESSION 5.1......Page 269
Reviewing the Panorama Database......Page 271
Using a Pattern Match in a Query......Page 272
Using a List-of-Values Match in a Query......Page 275
Using the Not Logical Operator in a Query......Page 276
Using an AutoFilter to Filter Data......Page 277
Assigning a Conditional Value to a Calculated Field......Page 279
Creating a Parameter Query......Page 284
Session 5.1 Quick Check......Page 288
SESSION 5.2......Page 289
Creating a Crosstab Query \n......Page 291
Creating a Find Duplicates Query......Page 297
Creating a Find Unmatched Query......Page 298
Creating a Top Values Query.......Page 300
Session 5.2 Quick Check......Page 302
SESSION 5.3.......Page 303
Creating a Lookup Field......Page 305
Using the Input Mask Wizard......Page 309
Identifying Object Dependencies......Page 313
Defining Data Validation Rules......Page 315
Working with Memo Fields......Page 318
Designating a Trusted Folder......Page 321
Session 5.3 Quick Check......Page 324
Review Assignments......Page 325
Case Problems.......Page 326
Tutorial 6: Using Form Tools and Creating Custom Forms: Creating Forms for Belmont Landscapes......Page 336
SESSION 6.1.......Page 337
Designing Forms......Page 339
Printing Database Relationships and Using the Documenter......Page 342
Creating Forms Using Form Tools......Page 345
Session 6.1 Quick Check......Page 356
SESSION 6.2.......Page 357
Planning and Designing a Custom Form.......Page 359
Creating a Custom Form in Design View.......Page 360
Selecting, Moving, and Aligning Controls......Page 364
Resizing and Deleting Controls......Page 367
Adding a Combo Box to a Form......Page 370
Using Form Headers and Form Footers......Page 375
Session 6.2 Quick Check......Page 378
SESSION 6.3.......Page 379
Adding a Combo Box to Find Records.......Page 381
Adding a Subform to a Form.......Page 384
Displaying a Subform’s Calculated Controls in the Main Form......Page 387
Changing the Tab Order in a Form......Page 394
Improving a Form’s Appearance.......Page 396
Session 6.3 Quick Check......Page 400
Review Assignments......Page 401
Case Problems.......Page 402
Tutorial 7: Creating Custom Reports: Creating Custom Reports for Belmont Landscapes......Page 410
SESSION 7.1......Page 411
Customizing Existing Reports......Page 413
Session 7.1 Quick Check.......Page 424
SESSION 7.2.......Page 425
Designing a Custom Report......Page 427
Creating a Query for a Custom Report......Page 428
Creating a Custom Report......Page 429
Sorting and Grouping Data in a Report......Page 432
Working with Controls in Design View......Page 437
Adding Lines to a Report.......Page 441
Hiding Duplicate Values in a Report......Page 443
Session 7.2 Quick Check......Page 444
SESSION 7.3......Page 445
Adding the Date to a Report......Page 447
Adding Page Numbers to a Report.......Page 450
Adding a Title to a Report.......Page 452
Creating Mailing Labels......Page 454
Session 7.3 Quick Check......Page 458
Review Assignments......Page 459
Case Problems.......Page 460
Tutorial 8: Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the Panorama Database......Page 468
SESSION 8.1......Page 469
Exporting an Access Query to an HTML Document......Page 471
Viewing an HTML Document Using Internet Explorer......Page 473
Importing a CSV File as an Access Table.......Page 474
Using XML......Page 479
Session 8.1 Quick Check......Page 488
SESSION 8.2.......Page 489
Creating a Multi-page Form Using a Tab Control......Page 491
Integrating Access with Other Programs......Page 495
Embedding a Chart in a Form.......Page 496
Creating and Using a PivotTable......Page 503
Creating a PivotChart......Page 509
Linking Data from an Excel Worksheet......Page 511
Session 8.2 Quick Check......Page 514
Review Assignments......Page 515
Case Problems.......Page 516
ProSkills Exercise: Decision Making......Page 521
APPENDIX A RELATIONAL DATABASES AND DATABASE DESIGN......Page 524
Tables......Page 525
Keys......Page 526
One-to-Many Relationship......Page 528
Many-to-Many Relationship......Page 529
One-to-One Relationship......Page 530
Entity Subtype......Page 531
Entity-Relationship Diagrams......Page 532
Integrity Constraints.......Page 534
Dependencies and Determinants......Page 535
Anomalies......Page 537
First Normal Form......Page 538
Second Normal Form......Page 540
Third Normal Form.......Page 542
Natural, Artificial, and Surrogate Keys.......Page 544
Microsoft Access Naming Conventions.......Page 548
Review Assignments......Page 551
GLOSSARY/INDEX......Page 556
TASK REFERENCE......Page 566