Microsoft Office Access, 2003 : Inside Track (PAP/CDR)

Microsoft Office Access, 2003 : Inside Track (PAP/CDR)

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版
  • 言語 ENG
  • 商品コード 9780735619760
  • DDC分類 005.7565

Full Description


Advance your database expertise-your way and as far as you want to go-with learn-by-doing training for Access 2003. With INSIDE TRACK, you choose exactly how and what you learn: Use the book's learning road map to plot your course. Select relevant lessons and get hands-on experience with practice-and-solution files. Assess your progress against learning checkpoints. And then apply your new skills to the real world of work. The CD packs all the exercises and database samples from inside the book, along with links to great resources. No matter what your current skill level, you'll build a better data pipeline with training from the inside track! Discover how to: Design effective database tables and fields Import or link to data in spreadsheets, text files, and other databases Create forms for entering and viewing data Build queries, reports, and PivotTable and PivotChart dynamic views for data analysis Use data access pages and XML to make data Web-accessible Set up an Access project file to work with a Microsoft SQL Server database Write macros and code to automate your database Back up critical data and use permissions, encryption, macro security, and other security techniques Share data and collaborate on projects by using Access with other Microsoft Office applications CD Inside! CD features: Practice files and database samples for all the book's exercises Links to Access newsgroups and Microsoft Office learning resources Demos for Microsoft Office Access, InfoPath, and OneNote "Extending Access," a guide to Access tools and utilities Fully searchable eBook of this text in PDF format Microsoft Computer Dictionary, Fifth Edition, eBook Here's how you get the Inside Track: Road Map-chart your course and target what you want to learn Hands-On Exercises-get expert guidance and practice performing real-world tasks Just The Steps-find instructions for key procedures at a glance Quick Check questions-put yourself to the test On Your Own-polish your skills for real work and better results For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Table of Contents

Acknowledgments                                    xv
Introduction xvii
The Inside Track xvii
The HelloWorld Sample Database xix
About This Book's CD-ROM xx
Companion CD Contents xx
Installing and Using the Practice Files xxi
System Requirements xxi
Support Information xxii
Road Map xxiii
Part I Getting Started
1 The HelloWorld Database 3 (28)
Getting Started 3 (2)
Creating a Table 5 (6)
Defining a Table's Fields 6 (1)
Selecting Data Types 7 (1)
Setting Field Properties 8 (1)
Designating a Primary Key 9 (2)
Building a Data Entry Form 11 (2)
Entering Data 13 (1)
Creating a Simple Query and Report 14 (7)
Enhancing Our Simple Form 21 (4)
Using Events and Code 25 (4)
Chapter Summary 29 (1)
Q&A 30 (1)
On Your Own 30 (1)
2 The Basics of Database Design 31 (48)
Principles of Relational Databases 32 (11)
Table Relationships 35 (7)
Why Use More Than One Table? 42 (1)
Planning and Designing the HelloWorld 43 (21)
Database
Planning for the Data Your Database 44 (1)
Will Store
Gathering Requirements 45 (3)
Splitting a Database: Using One 48 (1)
Database File or More
Identifying the Tables and Fields for 49 (2)
Your Database
Creating the MarketingCampaigns, 51 (8)
Marketing Materials, and
CampaignLanguage Tables
Defining Fields 59 (2)
Normalization: Achieving a 61 (3)
Well-Designed Database
Using the Table Wizard to Create the 64 (3)
CampaignExpenses Table
Creating a Lookup Field 67 (4)
Analyzing Your Database's Design 71 (1)
Testing Your Design 72 (1)
Documenting Your Database 73 (2)
Using the Access Database Templates 75 (1)
Chapter Summary 76 (1)
Q&A 77 (1)
On Your Own 78 (1)
3 Managing the Consistency, Format, and 79 (36)
Integrity of Your Data
Table Relationships and Referential 80 (7)
Integrity
Cascade Update and Cascade Delete 82 (1)
Fixing Referential Integrity Errors 83 (4)
Table and Field Properties 87 (10)
Table Properties 88 (1)
Field Size Property 89 (2)
Caption Property 91 (1)
Default Value Property 92 (1)
Required and Allow Zero Length 93 (1)
Properties
Indexed Property 94 (2)
Other Field Properties 96 (1)
Using an Input Mask to Manage Data Entry 97 (5)
Input Mask Special Characters 97 (1)
Using the Input Mask Wizard 98 (3)
Modifying a Standard Input Mask 101 (1)
The Format Property 102 (2)
Expressions and the Expression Builder 104 (2)
Validating Data 106 (6)
Chapter Summary 112 (1)
Q&A 113 (1)
On Your Own 113 (2)
4 Importing and Linking to Data 115 (32)
Should You Import Data or Link to Data? 116 (1)
Importing Data 117 (15)
Importing Data from Microsoft Excel 119 (8)
Importing Data and Database Objects 127 (3)
from an Access Database
Importing Data from Other Data Formats 130 (2)
Splitting a Database 132 (1)
Linking to Data 133 (3)
Linking to Tables in the Northwind 134 (1)
Database
Linking to Data in Other Formats 135 (1)
The Linked Table Manager 136 (1)
Creating a Macro to Import Data 136 (7)
Chapter Summary 143 (1)
Q&A 144 (1)
On Your Own 144 (3)
5 Using Visual Basic to Automate Your 147 (64)
Database
Converting a Macro to Visual Basic Code 149 (1)
Creating an Event Procedure 150 (6)
Using Standard and Class Modules 156 (2)
Understanding Scope and Variables 158 (11)
Working with Scope 159 (1)
Declaring Variables 159 (1)
Modifying the Import Procedure 160 (5)
More About Variables 165 (4)
Using Control Structures 169 (8)
The If... Then...Else Statement 170 (2)
The SelectCase Statement 172 (1)
The Call Statement 172 (1)
The For...Next Statement 173 (1)
The For Each...Next Statement 173 (1)
The Do While...Loop Statement 174 (1)
The While... Wend Statement 175 (1)
The With ... End With Statement 176 (1)
Setting Up the Visual Basic Editor 177 (4)
The EditorTab 178 (1)
The Editor Format Tab 179 (1)
The General Tab 179 (1)
The Docking Tab 179 (2)
Handling Errors and Debugging Code 181 (11)
Types of Errors 181 (1)
Adding Error Handling to Your Code 182 (3)
Debugging Tools 185 (7)
Using an Object Model 192 (13)
Elements of an Object Model 192 (4)
DAO Object Model 196 (3)
ADO Object Model 199 (3)
Office Automation 202 (3)
Chapter Summary 205 (1)
Q&A 206 (1)
On Your Own 207 (4)
Part II The Database Application
6 Sorting, Filtering, and Retrieving Data 211 (34)
Sorting Table Data in Datasheet View 212 (3)
Applying a Filter to Data in a Table 215 (8)
Designing Select Queries 223 (15)
Creating a Query in Design View 223 (3)
Multitable Queries 226 (3)
Using Criteria to Select Data 229 (3)
Summarizing and Grouping Records 232 (2)
Using an Expression to Create a 234 (4)
Calculated Field
Using a Parameter Query 238 (2)
Queries and Visual Basic 240 (1)
Chapter Summary 241 (1)
Q&A 242 (1)
On Your Own 242 (3)
7 Designing Basic Forms 245 (43)
Creating a Form with the Form Wizard and 246 (6)
AutoForm Formats
Working with the Views and Structure of a 252 (13)
Form
Viewing Data in a Form 252 (1)
Form Sections 253 (4)
Record Source Property 257 (4)
Control Source Property 261 (4)
Using Design Tools to Fine-Tune Forms 265 (19)
Moving, Sizing, and Aligning Controls 267 (6)
Selecting Multiple Controls 273 (1)
Formatting Controls with Properties 274 (2)
Setting the Tab Order 276 (2)
Adding a Control to a Form 278 (6)
Chapter Summary 284 (1)
Q&A 284 (1)
On Your Own 285 (3)
8 Adding Features and Function to Forms 287 288 (37)
Customizing the Appearance of a Form
Highlighting Data with Conditional 295 (2)
Formatting
Using a Subform to View Related Data 297 (5)
Using an Option Group to Perform 302 (5)
Alternative Operations
Using a Control's Value in Query and 307 (7)
Filter Criteria
Turning a Control On and Off 314 (3)
Handling Unexpected Behavior in a Form 317 (1)
Running a Visual Basic Procedure by Using 318 (3)
a Form Event
Chapter Summary 321 (1)
Q&A 321 (1)
On Your Own 322 (3)
9 Extending Your Use of Queries 325 (36)
Summarizing Data with a Crosstab Query 325 (5)
Understanding the Basics of SQL 330 (5)
Running Action Queries 335 (10)
Updating Field Values with a Query 336 (3)
Archiving Data with an Append Query 339 (3)
Using a Delete Query 342 (3)
Running a Make-Table Query 345 (2)
Creating SQL-Specific Queries 347 (3)
Union Query 348 (1)
SQL Pass-Through Query 349 (1)
Data-Definition Queries 349 (1)
Working with Query Properties 350 (3)
Unique Values Property 351 (2)
Unique Records Property 353 (1)
Using Outer Joins and Self-Joins 353 (5)
Chapter Summary 358 (1)
Q&A 358 (1)
On Your Own 359 (2)
10 Presenting Data with Reports 361 (44)
Creating a Report with the Report Wizard 362 (6)
Working with a Report in Design View 368 (8)
Managing a Report's Record Source 376 (6)
Filtering Records in a Report 376 (3)
Using a Parameter in Report Criteria 379 (3)
Displaying Data in a Chart 382 (5)
Adding a Subreport to a Main Report 387 (4)
Controlling Report Layouts with Properties 391 (4)
Working with Report and Section Events 395 (6)
Using a Report's Open and Close Events 395 (5)
Using a Section's Format Event 400 (1)
Chapter Summary 401 (1)
Q&A 402 (1)
On Your Own 402 (3)
11 Analyzing Data with PivotTables and 405 (32)
PivotCharts
Creating PivotTables 406 (6)
Changing the View of Data in a PivotTable 412 (7)
Filtering Data in a PivotTable Form 412 (1)
Analyzing Data in a PivotTable 413 (6)
Formatting a PivotTable and Setting 419 (2)
PivotTable Properties
Using a PivotChart to Display and Analyze 421 (9)
Data
Creating a PivotChart 421 (3)
Working with PivotChart Data and 424 (6)
Properties
Showing PivotTables and PivotCharts in a 430 (2)
Single Form
Using Visual Basic to Create a PivotTable 432 (4)
Chapter Summary 436 (1)
Q&A 436 (1)
On Your Own 436 (1)
12 Access and the Web 437 (42)
Exporting Data as HTML 438 (7)
Creating a Data Access Page with the Page 445 (7)
Wizard
Working with a Data Access Page in Design 452 (15)
View
Setting Up a Data Access Page in Design 453 (6)
View
Customizing Data Access Page Controls 459 (4)
Working with Data Access Page Properties 463 (4)
Hosting Office Web Components on Data 467 (9)
Access Pages
Chapter Summary 476 (1)
Q&A 477 (1)
On Your Own 477 (2)
13 Completing Your Database Application 479 (42)
Creating Macro Groups and Using Macro 480 (8)
Conditions
Macro Groups 480 (3)
Macro Conditions 483 (2)
Assigning a Macro to an Event 485 (3)
Creating an Application Switchboard 488 (4)
Creating Menu Bars and Toolbars 492 (12)
Creating a Custom Menu Bar 493 (7)
Creating a Custom Shortcut Menu 500 (4)
Assigning a Toolbar, Menu, or Shortcut 504 (3)
Menu to a Form
Customizing Toolbars and Menu Bars 507 (4)
Setting Startup Options 511 (2)
Adding a Smart Tag to a Control or a Field 513 (3)
Chapter Summary 516 (1)
Q&A 516 (1)
On Your Own 517 (4)
Part III The Data Pipeline
14 Understanding Access Projects 521 (36)
Setting Up the SQL Server Database Engine 522 (4)
Upsizing an Access Database to SQL Server 526 (6)
Creating an Access Project 532 (5)
Creating SQL Server Tables in an Access 537 (7)
Project
Using Database Diagrams 544 (5)
Working with Views and Stored Procedures 549 (6)
Views 549 (3)
Stored Procedures 552 (3)
Chapter Summary 555 (1)
Q&A 556 (1)
On Your Own 556 (1)
15 Integration with Office 2003 and 557 (28)
SharePoint Services
Extending SharePoint Using Access 557 (8)
Using SharePoint for Collaboration 558 (1)
Linking to SharePoint Data Using Access 559 (2)
Linking Tables Through SharePoint 561 (4)
Working with Access Data inInfoPath 565 (8)
Exploring Info on InfoPath 566 (1)
Designing InfoPath Forms Based on 566 (3)
Access Tables
Linking to Access from an InfoPath Form 569 (4)
Analyzing Access Data Through Excel 573 (6)
Bringing Access Data into Excel 574 (5)
Working with Outlook Data in Access 579 (3)
Chapter Summary 582 (1)
Q&A 582 (1)
On Your Own 583 (2)
16 Working with XML Data in Access 585 (26)
Introducing XML 586 (3)
Constraining XML Data in Access 587 (1)
Using Schemas to Define Data Types 588 (1)
Exporting an Access Table to an XML 589 (2)
Document
Importing an XML Document into Access 591 (7)
Access XML and the XML Schema Definition 596 (1)
Looking Inside the XSD 596 (2)
Embedding the XSD in the XML Document 598 (3)
Presenting XML Data with Access 601 (4)
Exporting Tables and Data as XML 601 (4)
Exporting Other Access Objects as XML 605 (3)
Chapter Summary 608 (32)
Q&A 640
On Your Own 609 (2)
17 Using Visual Basic to Manage Data 611 (34)
Creating a Custom Report Feature 611 (8)
Using Visual Basic to Work with Data in 619 (14)
Office Applications
Building an Outlook Contact List from 620 (3)
Access
Creating an Excel Spreadsheet from 623 (4)
Access
Using Data in Access to Create a 627 (6)
PowerPoint Presentation
Working with Recordsetsin ADO 633 (7)
Working with the ADO Connection Object 633 (2)
Understanding ADO Cursor Types 635 (1)
Using the LockType Property 636 (1)
Moving from Record to Record in a 637 (3)
Recordset
Chapter Summary 640 (1)
Q&A 640 (1)
On Your Own 641 (4)
Part IV Maintenance and Security
18 Maintaining an Access Database 645 (32)
Using Access Database Maintenance 646 (8)
Utilities
Backing Up an Access Database 646 (1)
Compacting and Repairing a Database 647 (2)
Running the Performance Analyzer 649 (5)
Viewing Object Dependencies 654 (6)
Managing a Multiuser Database 660 (6)
Setting Options for a Multiuser Database 660 (2)
Converting an Access Database 662 (4)
Replicating an Access Database 666 (9)
Synchronizing Replicas 669 (2)
Creating a Partial Replica 671 (4)
Chapter Summary 675 (1)
Q&A 675 (1)
On Your Own 676 (1)
19 Implementing Security 677
Exploring Types of Security in Access 678 (1)
Implementing User-Level Security 679 (3)
User and Group Management in Access 680 (2)
Understanding Permissions 682 (14)
Creating Groups 684 (6)
Creating Users 690 (2)
Setting a User Password 692 (4)
Securing Database Objects 696 (6)
Obfuscation Methods 697 (5)
Chapter Summary 702 (1)
Q&A 702 (1)
On Your Own 703