Tabs for Contents, notes, highlights

Hide Contents, Notes, and Highlights

Search TermsShow Hide

« Back to eTextbook

Copyright, iv
Preface, v
Getting Started with Microsoft Office 2007: Preparing a Meeting Agenda, OFF1
Exploring Microsoft Office 2007, OFF2
Integrating Office Programs, OFF3
Starting Office Programs, OFF3
Switching Between Open Programs and Files, OFF5
Exploring Common Window Elements, OFF6
Resizing the Program Window and Workspace, OFF6
Getting Information from the Status Bar, OFF7
Switching Views, OFF8
Zooming the Workspace, OFF8
Using the Ribbon, OFF10
Clicking Button Icons, OFF10
Using Galleries and Live Preview, OFF12
Opening Dialog Boxes and Task Panes, OFF13
Using Contextual Tools, OFF15
Displaying Contextual Tabs, OFF15
Accessing the Mini Toolbar, OFF15
Opening Shortcut Menus, OFF17
Working with Files, OFF18
Saving a File, OFF18
Closing a File, OFF21
Opening a File, OFF21
Getting Help, OFF23
Viewing ScreenTips, OFF23
Using the Help Window, OFF23
Printing a File, OFF27
Exiting Programs, OFF28
Quick Check, OFF29
Tutorial Summary, OFF29
Key Terms, OFF29
Review Assignments, OFF30
SAM Assessment and Training, OFF31
Quick Check Answers, OFF31
Reality Check, OFF32
Access Level I Tutorials, AC1
Tutorial 1. Creating a Database: Creating a Database to Contain Customer, Contract, and Invoice Data, AC1
Session 1.1, AC2
Introduction to Database Concepts, AC2
Creating a Database, AC5
Creating a Table in Datasheet View, AC8
Session 1.1 Quick Check, AC19
Session 1.2, AC19
Copying Records from Another Access Database, AC19
Navigating a Datasheet, AC22
Creating a Simple Query, AC23
Creating a Simple Form, AC27
Creating a Simple Report, AC29
Viewing Objects in the Navigation Pane, AC32
Managing a Database, AC33
Session 1.2 Quick Check, AC36
Tutorial Summary, AC36
Key Terms, AC36
Review Assignments, AC37
Case Problems, AC38
Internet Assignments, AC43
SAM Assessment and Training, AC43
Quick Check Answers, AC43
Tutorial 2. Building a Database and Defining Table Relationships: Creating the Invoice and Customer Tables, AC45
Session 2.1, AC46
Guidelines for Designing Databases, AC46
Guidelines for Setting Field Properties, AC48
Viewing and Modifying Field Data Types and Formatting, AC50
Creating a Table in Design View, AC54
Modifying the Structure of an Access Table, AC62
Session 2.1 Quick Check, AC66
Session 2.2, AC66
Adding Records to a New Table, AC66
Importing Data from an Excel Worksheet, AC68
Creating a Table by Importing an Existing Table Structure, AC71
Adding Data to a Table by Importing a Text File, AC79
Defining Table Relationships, AC81
Session 2.2 Quick Check, AC87
Tutorial Summary, AC87
Key Terms, AC87
Review Assignments, AC88
Case Problems, AC89
Internet Assignments, AC97
SAM Assessment and Training, AC98
Quick Check Answers, AC98
Tutorial 3. Maintaining and Querying a Database: Updating and Retrieving Information About Customers, Contracts, and Invoices, AC99
Session 3.1, AC100
Updating a Database, AC100
Introduction to Queries, AC104
Query Window, AC105
Creating and Running a Query, AC107
Updating Data Using a Query, AC109
Creating a Multitable Query, AC110
Sorting Data in a Query, AC112
Filtering Data, AC116
Session 3.1 Quick Check, AC118
Session 3.2, AC119
Defining Record Selection Criteria for Queries, AC119
Defining Multiple Selection Criteria for Queries, AC128
Creating a Calculated Field, AC133
Using Aggregate Functions, AC137
Working with the Navigation Pane, AC142
Session 3.2 Quick Check, AC144
Tutorial Summary, AC144
Key Terms, AC144
Review Assignments, AC145
Case Problems, AC146
Internet Assignments, AC151
SAM Assessment and Training, AC151
Quick Check Answers, AC152
Tutorial 4. Creating Forms and Reports: Creating a Customer Data Form, a Customer Contracts Form, and a Customers and Contracts Report, AC153
Session 4.1, AC154
Creating a Form Using the Form Wizard, AC154
Modifying a Form's Design in Layout View, AC157
Navigating a Form, AC165
Finding Data Using a Form, AC165
Maintaining Table Data Using a Form, AC168
Previewing and Printing Selected Form Records, AC170
Session 4.1 Quick Check, AC172
Session 4.2, AC172
Creating a Form with a Main Form and a Subform, AC172
Creating a Report Using the Report Wizard, AC176
Modifying a Report's Design in Layout View, AC181
Using Conditional Formatting in a Report, AC185
Session 4.2 Quick Check, AC189
Tutorial Summary, AC189
Key Terms, AC189
Review Assignments, AC190
Case Problems, AC191
Internet Assignments, AC197
SAM Assessment and Training, AC197
Quick Check Answers, AC198
Reality Check, AC199
Access Level II Tutorials, AC201
Tutorial 5. Creating Advanced Queries and Enhancing Table Design: Making the Panorama Database Easier to Use, AC201
Session 5.1, AC202
Reviewing the Panorama Database, AC202
Using a Pattern Match in a Query, AC204
Using a List-of-Values Match in a Query, AC207
Using the Not Operator in a Query, AC208
Using an AutoFilter to Filter Data, AC209
Assigning a Conditional Value to a Calculated Field, AC211
Creating a Parameter Query, AC215
Session 5.1 Quick Check, AC219
Session 5.2, AC219
Creating a Crosstab Query, AC219
Creating a Find Duplicates Query, AC226
Creating a Find Unmatched Query, AC227
Creating a Top Values Query, AC229
Session 5.2 Quick Check, AC231
Session 5.3, AC231
Creating a Lookup Field, AC231
Using the Input Mask Wizard, AC235
Identifying Object Dependencies, AC239
Defining Data Validation Rules, AC241
Working with Memo Fields, AC244
Designating a Trusted Folder, AC246
Session 5.3 Quick Check, AC248
Tutorial Summary, AC249
Key Terms, AC249
Review Assignments, AC250
Case Problems, AC251
Internet Assignments, AC260
SAM Assessment and Training, AC261
Quick Check Answers, AC261
Tutorial 6. Using Form Tools and Creating Custom Forms: Creating Forms for Belmont Landscapes, AC263
Session 6.1, AC264
Designing Forms, AC264
Printing Database Relationships and Using the Documenter, AC267
Creating Forms Using Form Tools, AC269
Session 6.1 Quick Check, AC280
Session 6.2, AC280
Planning and Designing a Custom Form, AC280
Creating a Custom Form in Design View, AC281
Selecting, Moving, and Aligning Controls, AC285
Resizing and Deleting Controls, AC288
Adding a Combo Box to a Form, AC291
Using Form Headers and Form Footers, AC296
Session 6.2 Quick Check, AC298
Session 6.3, AC299
Adding a Combo Box to Find Records, AC299
Adding a Subform to a Form, AC302
Displaying a Subform's Calculated Controls in the Main Form, AC306
Changing the Tab Order in a Form, AC313
Improving a Form's Appearance, AC315
Session 6.3 Quick Check, AC320
Tutorial Summary, AC321
Key Terms, AC321
Review Assignments, AC322
Case Problems, AC324
Internet Assignments, AC331
SAM Assessment and Training, AC331
Quick Check Answers, AC331
Tutorial 7. Creating Custom Reports: Creating Reports with Information About Contracts and Invoices, AC333
Session 7.1, AC334
Customizing Existing Reports, AC334
Session 7.1 Quick Check, AC349
Session 7.2, AC349
Designing a Custom Report, AC349
Creating a Query for a Custom Report, AC351
Creating a Custom Report, AC352
Sorting and Grouping Data in a Report, AC355
Working with Controls in Design View, AC359
Adding Lines to a Report, AC362
Hiding Duplicate Values in a Report, AC363
Session 7.2 Quick Check, AC365
Session 7.3, AC365
Adding the Date to a Report, AC365
Adding Page Numbers to a Report, AC368
Adding a Title to a Report, AC370
Creating Mailing Labels, AC373
Session 7.3 Quick Check, AC377
Tutorial Summary, AC377
Key Terms, AC377
Review Assignments, AC378
Case Problems, AC379
Internet Assignments, AC386
SAM Assessment and Training, AC386
Quick Check Answers, AC387
Tutorial 8. Sharing, Integrating, and Analyzing Data: Importing, Exporting, Linking, and Analyzing Data in the Panorama Database, AC389
Session 8.1, AC390
Using the Web, AC390
Exporting an Access Query to an HTML Document, AC390
Viewing an HTML Document Using Internet Explorer, AC393
Importing a CSV File as an Access Table, AC395
Using XML, AC400
Session 8.1 Quick Check, AC408
Session 8.2, AC409
Creating a Multi-page Form Using a Tab Control, AC409
Integrating Access with Other Programs, AC413
Embedding a Chart in a Form, AC414
Creating and Using a PivotTable, AC420
Creating a PivotChart, AC426
Linking Data from an Excel Worksheet, AC429
Session 8.2 Quick Check, AC432
Tutorial Summary, AC432
Key Terms, AC432
Review Assignments, AC433
Case Problems, AC434
Internet Assignments, AC438
SAM Assessment and Training, AC438
Quick Check Answers, AC438
Reality Check, AC440
Appendix: Relational Databases and Database Design, ACA1
Tables, ACA2
Keys, ACA3
Relationships, ACA5
One-to-Many Relationships, ACA5
Many-to-Many Relationship, ACA6
One-to-One Relationship, ACA7
Entity Subtype, ACA8
Entity-Relationship Diagrams, ACA10
Integrity Constraints, ACA11
Dependencies and Determinants, ACA12
Anomalies, ACA14
Normalization, ACA15
First Normal Form, ACA15
Second Normal Form, ACA16
Third Normal Form, ACA18
Natural, Artificial, and Surrogate Keys, ACA19
Microsoft Access Naming Conventions, ACA23
Appendix Summary, ACA27
Key Terms, ACA27
Review Assignments, ACA28
Glossary/Index, REF1
Task Reference, REF12

Search Results

« Back to eTextbook


PAGE	Description

OFF21	...

Tabs for Contents, notes, highlights

Table of Contents

Search Results