+612 9045 4394
How To Do Everything With Microsoft Access 2007 : How to Do Everything - Virginia Andersen

How To Do Everything With Microsoft Access 2007

How to Do Everything

Paperback Published: 11th January 2007
ISBN: 9780072263466
Number Of Pages: 1024

Share This Book:


Ships in 7 to 10 business days

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Maximize the powerful features of the latest release of today's most popular desktop database program

How to Do Everything with Microsoft Office Access 2007 shows you how to create and customize an efficient, multi-user database, retrieve, interpret, and share your data, secure your information, and much more. Designed to help you get things done quickly and easily, this user-friendly guide is your all-access pass to Access 2007.

  • Navigate the new user interface with ease
  • Design a well-organized database using pre-designed templates
  • Enter and edit data and ensure data validity
  • Sort, filter, and print records
  • Extract specific information using queries
  • Master form and report design basics
  • Add charts and graphs to forms and reports easily
  • Optimize database performance and speed
  • Exchange database objects and text files between Access databases

Acknowledgmentsp. xvii
Introductionp. xix
Get Started
Get Acquainted with Access 2007p. 3
Start Access and Open a Databasep. 4
Take a Tour of the Access Windowp. 6
Open a Databasep. 7
Tour the Navigation Pane and the Object Windowp. 12
Look at the Ribbonp. 16
Use Shortcut Menusp. 18
Open a Tablep. 18
Take a Tour of the Datasheet Viewp. 19
Check Out the Subdatasheetp. 22
Get Help When You Need Itp. 24
Use Microsoft Access Help Windowp. 24
Ask What's This?p. 25
Get Help with What You're Doingp. 26
Create a Databasep. 27
Design an Efficient Databasep. 28
Determine the Goals of the Databasep. 30
Distribute the Data Among the Tablesp. 30
Identify the Data Fieldsp. 31
Specify Key Fieldsp. 31
Define Table Relationshipsp. 33
Complete the Databasep. 34
Create a Database with a Templatep. 36
Run the New Applicationp. 41
Start with a Blank Databasep. 42
Create and Modify Tablesp. 45
Create a New Table from a Templatep. 46
Create a New Table in Datasheet Viewp. 46
Add Fields to the New Tablep. 47
Use a Field Templatep. 49
Add Fields from an Existing Tablep. 50
Save the New Tablep. 51
Create a Table from Scratch in Design Viewp. 52
Tour the Table Design Viewp. 52
Add Fieldsp. 53
Choose a Primary Keyp. 63
Create Other Indexesp. 64
Save the Table Designp. 66
Modify the Table Designp. 67
Switch Table Viewsp. 67
Add or Delete Fieldsp. 67
Change the Field Orderp. 68
Change a Field Name or Typep. 69
Change a Field Sizep. 69
Modify or Delete the Primary Keyp. 70
Ensure Data Validityp. 71
Define Field Validation Rulesp. 72
Define a Record Validation Rulep. 73
Require an Entry and Prevent Duplicatesp. 74
Handle Blank Fieldsp. 74
Assign a Default Valuep. 76
Copy an Existing Table Structurep. 77
Relate Tablesp. 79
Define a Relationshipp. 80
Use the Relationships Windowp. 80
Use the Field List Panep. 91
View and Edit Relationshipsp. 93
Hide or Delete a Tablep. 93
Modify or Delete a Relationshipp. 93
Change a Table Design from the Relationships Windowp. 94
Print the Relationshipsp. 94
Enter and Edit Datap. 97
Enter New Datap. 98
Copy and Move Datap. 98
Insert Picturesp. 103
Insert Hyperlinksp. 105
Attaching Files to a Fieldp. 108
Customize Data Entryp. 110
Add Custom Input Masksp. 110
Create Lookup Fieldsp. 113
Change the Datasheet Appearancep. 119
Move and Resize Columns and Rowsp. 119
Freeze and Hide Columnsp. 121
Change the Fontp. 122
Change Gridlines and Cellsp. 123
Set Datasheet Default Optionsp. 124
Change Table Definitionp. 125
Insert/Delete a Columnp. 125
Change Field Namesp. 126
Insert/Delete a Subdatasheet in Design Viewp. 126
Find and Edit Record Datap. 127
Locate Recordsp. 127
Find and Replace Datap. 131
Delete Datap. 132
Retrieve and Present Information
Sort, Filter, and Print Recordsp. 135
Sort Recordsp. 136
Sort on a Single Fieldp. 136
Sort by Two or More Fieldsp. 137
Save the Sort Orderp. 137
Filter Recordsp. 137
Filter by Contextp. 139
Use the Filter Commandp. 142
Filter By Selectionp. 143
Filter By Formp. 146
Filter with Advanced Filter/Sortp. 152
Save a Filterp. 153
Remove and Clear Filtersp. 155
Preview and Print Sorted or Filtered Table Datap. 155
Extract Information with Queriesp. 157
Create a Select Queryp. 159
Use the Simple Query Wizardp. 160
Tour the Query Design Windowp. 162
Without the Wizardp. 164
Relate Multiple Tables in a Queryp. 165
Add/Remove Fieldsp. 168
Run and Save the Queryp. 171
Hide and Show Fieldsp. 172
Specify the Record Orderp. 173
Show Highest or Lowest Valuesp. 174
Add Selection Criteriap. 175
Use Wildcards and Operatorsp. 176
Use a Single Criterionp. 176
Use Multiple Criteriap. 177
Get Help from the Expression Builderp. 180
Set Query Propertiesp. 182
Modify a Queryp. 183
Insert a Field and Change the Field Orderp. 183
Change Field Propertiesp. 183
Perform Calculations in a Queryp. 185
Add a Calculated Fieldp. 185
Summarize with the Wizardp. 188
Summarize with Aggregate Functionsp. 188
Summarizing in Datasheet Viewp. 192
Create Special Queries with the Query Wizardp. 193
Create a Find Duplicates Queryp. 193
Create a Find Unmatched Queryp. 194
Create a Crosstab Queryp. 195
Create Advanced Queriesp. 199
Create Special Purpose Queriesp. 200
Parameter Queriesp. 200
AutoLookup Queriesp. 204
Design Action Queriesp. 206
Update Queryp. 206
Make-Table Queryp. 210
Append Queryp. 211
Delete Queryp. 213
Look at Structured Query Language (SQL)p. 215
Review SQL Statementsp. 215
Create a Subqueryp. 217
Define a Criterionp. 217
Define a New Fieldp. 218
Understand Form Report Design Basicsp. 221
Use Simple Form and Simple Report Toolsp. 222
Common Form and Report Design Elementsp. 224
Understand Controlsp. 224
Work in the Design Windowp. 225
Start a New Designp. 225
Tour the Design Windowp. 228
Add Controlsp. 232
Starting a New Form in Layout Viewp. 238
Modify Controlsp. 238
Select Controls and Other Objectsp. 239
Move and Resize Controlsp. 243
Align and Space Controlsp. 245
Use Property Sheetsp. 246
Use the Font Groupp. 250
Format Conditionallyp. 251
Change a Control Typep. 253
Delete Controlsp. 254
Modify Form or Report Propertiesp. 254
Change the Record Sourcep. 254
Apply Filters and Sort Ordersp. 256
Use AutoFormatp. 257
Create Custom Forms and Subformsp. 259
Create a New Form Designp. 260
Use the Form Wizardp. 260
Create a Form Without the Wizardp. 263
Modify the Form Designp. 264
Add Form Header and Footer Sectionsp. 264
Place and Customize Data-Related Controlsp. 266
Add Yes/No Controlsp. 275
Add User-Interactive Controlsp. 278
Use the Form for Data Entryp. 282
Navigate in the Formp. 282
Change the Tab Orderp. 283
Locate Recordsp. 284
Sort and Filter Data in a Formp. 284
View Multiple Recordsp. 285
Create a Multiple-Page Formp. 285
Add a Page Breakp. 285
Add a Tab Controlp. 287
Customize a Tab Controlp. 288
Add Special Controlsp. 288
Add Calculated Controlsp. 288
Add an AutoDialer Controlp. 289
Create a Hierarchical Formp. 290
Use the Form Wizardp. 291
Use the Subform Wizardp. 293
Use the Hierarchical Formp. 296
Modify a Subformp. 296
Add Custom User Guidancep. 297
Add Data Validationp. 298
Validate with Propertiesp. 298
Validate with Eventsp. 299
Create and Customize Reports and Subreportsp. 301
Start a New Reportp. 302
Use the Report Toolp. 303
Use the Report Wizardp. 304
Preview and Print the Reportp. 308
Work in the Print Preview Windowp. 309
Print the Reportp. 311
Modify the Report Designp. 313
Examine the Report Sectionsp. 314
Set Report and Section Propertiesp. 314
Change the Report Stylep. 316
Add Page Numbers and Date/Time Controlsp. 316
Save the Report Designp. 317
Filter, Sort, and Group Records in Layout Viewp. 318
Filter Records in Layout Viewp. 319
Change the Sort Orderp. 320
Add Group Sectionsp. 322
Modify and Add Groupsp. 326
Create a Summary Report with the Report Wizardp. 329
Print an Alphabetic Indexp. 332
Add a Subreportp. 335
Create a Subreport with the Report Wizardp. 335
Create a Subreport Controlp. 336
Insert an Existing Subreportp. 339
Link the Report and Subreportp. 339
Modify a Subreport Controlp. 340
Design a Multiple-Column Reportp. 340
Print Mailing Labelsp. 342
Use the Label Wizardp. 343
Create Charts and Graphsp. 347
Choose a Chart Typep. 348
Create a New Chart with the Chart Wizardp. 348
Select the Data for the Chartp. 348
Use the Microsoft Chart Wizardp. 352
Save the Chartp. 354
Link the Chart to Record Datap. 355
Add an Existing Chart to a Form or Reportp. 356
Modify the Chartp. 358
Modify with Accessp. 358
Edit with Microsoft Graphp. 364
Improve the Access 2007 Workplace
Customize the Workplacep. 375
Personalize the Workplacep. 376
Work with Objects in the Navigation Panep. 376
Using the Ribbonp. 380
Create a Shortcutp. 380
Set Access Optionsp. 381
Popular Optionsp. 382
Set Options for the Current Databasep. 384
Set Datasheet Optionsp. 388
Set Object Designers Optionsp. 388
Set Proofing Optionsp. 393
Set Advanced Optionsp. 395
Customize the Toolbarp. 401
View and Manage Add-Insp. 402
Choose Trust Center Optionsp. 404
Search Additional Resourcesp. 405
Customize the Status Barp. 406
Speed Up Your Databasep. 407
Optimize a Databasep. 408
Use the Analyzer Wizardsp. 408
Optimize Tables and Queriesp. 414
Optimize Filter By Formp. 416
Optimize Forms and Reportsp. 416
Optimize Controlsp. 418
Back Up and Restore a Databasep. 418
Compact and Repair a Databasep. 419
Automate with Macrosp. 423
Create a Simple Macrop. 424
Choose Macro Actionsp. 426
Set Action Argumentsp. 427
Test and Debug a Macrop. 429
Start the Macrop. 429
Step Through a Macrop. 430
Modify a Macrop. 431
Assign a Macro to an Event Propertyp. 432
Decide Which Event to Usep. 433
Add Conditions to a Macrop. 434
Create a Macro to Display a Warningp. 435
Create Other Commonly Used Macrosp. 437
Set Control Values and Propertiesp. 438
Change the Flow of Operationsp. 441
Filter Recordsp. 443
Create an AutoExec Macrop. 444
Create a Macro Groupp. 445
Customize the User Interfacep. 449
Work with the Ribbonp. 450
Resize the Ribbonp. 450
Hide and Restore the Ribbonp. 451
Use Keyboard Shortcuts for Ribbon Commandsp. 451
Customize the Quick Access Toolbarp. 452
Move the Quick Access Toolbarp. 452
Add Commands to the Toolbarp. 452
Remove Commands from the Toolbarp. 457
Use Existing Customizationp. 458
Show Startup Switchboardp. 458
Use Custom menus and toolbarsp. 458
Create a Custom Dialog Boxp. 460
Design the Formp. 461
Create and Attach the Macrosp. 464
Create a Dialog Box for User Inputp. 469
Set the Input Form Propertiesp. 469
Create the Macrosp. 470
Modify the Queryp. 470
Customize the Navigation Pane and Create Switchboardsp. 473
View Objects in the Navigation Panep. 474
Change Categories and Groupsp. 474
Hide/Restore Groups and Objectsp. 480
Search for an Objectp. 482
Customize the Navigation Panep. 484
Plan the Custom Groupsp. 484
Hide/Restore Custom Groups and Objectsp. 489
Create Switchboardsp. 490
Use the Switchboard Manager to Create Switchboardsp. 491
Modify the Switchboardp. 498
Exchange Data with Others
Exchange Database Objects and Textp. 505
Copy Objects among Access Databasesp. 506
Copy and Pastep. 506
Drag and Dropp. 507
Import or Link Access Datap. 508
Import Objectsp. 509
Set Import Optionsp. 512
Link Access Tablesp. 513
Import from or Link to Other Data Sourcesp. 515
Use Data from dBASE or Paradoxp. 516
Work with Linked or Imported Tablesp. 517
Rename a Linked Table in Accessp. 517
Change Linked Table Propertiesp. 517
Update Links with the Linked Table Managerp. 518
Unlink Tablesp. 520
Import and Link Text Filesp. 520
Use Delimited Text Filesp. 520
Use Fixed-Width Text Filesp. 526
Change Import Specificationsp. 527
Export to an Existing Access Databasep. 529
Export to Another Database Formatp. 530
Export to Text Filesp. 531
Exchange Data with Outside Sourcesp. 537
Copy or Move Recordsp. 538
Copy or Move Data from a Word Processorp. 538
Copy or Move Data from a Spreadsheetp. 540
Copy or Move Records from Access to Another Applicationp. 541
Save Access Output as an External Filep. 542
Work with Wordp. 545
Save in Rich Text Formatp. 545
Use Merge It with Microsoft Wordp. 546
Work with Excelp. 548
Import from and Link to Excel Spreadsheetsp. 549
Export a Table or Query to Excelp. 554
Mailing Access Objectsp. 555
Share with Multiple Usersp. 557
Share a Database on a Networkp. 558
Share an Entire Databasep. 558
Split the Databasep. 559
Prevent Exclusive Accessp. 563
Manage the Database in a Multiuser Environmentp. 564
Control Data Editingp. 565
Update Records with Refresh and Requeryp. 567
Edit Shared Database Objectsp. 568
Secure a Databasep. 571
New Security Measuresp. 572
Enable/Disable Database Contentp. 572
Encrypt the Databasep. 573
Encrypt with a Passwordp. 574
Use the Trust Centerp. 575
Create a Trusted Environmentp. 575
Trust Macrosp. 578
Trust Add-Insp. 580
Security with Earlier Version Databasesp. 581
Create a Certificatep. 582
Code-sign the Databasep. 583
Convert to Access 2007p. 585
Decide on a Conversion Strategyp. 586
Convert a Database to Access 2007p. 586
Convert a Workgroup Information File (MDW)p. 588
Convert a Secured Databasep. 588
Convert a Replicated Databasep. 588
Convert to an Earlier Versionp. 589
Open an Earlier Databasep. 589
Share a Database Across Several Access Versionsp. 590
Indexp. 591
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072263466
ISBN-10: 0072263466
Series: How to Do Everything
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 1024
Published: 11th January 2007
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.3 x 18.8  x 3.3
Weight (kg): 0.89
Edition Number: 1