Overview

By encouraging skill building and concept application, Access™ 2007 Guidebook, Sixth Edition, provides basic database principles students need to use Access™ 2007 effectively in real-world situations. Trigg and Dobson’s thoughtful, hands-on approach combines clearly written instructions, good reference materials, challenging exercises, and extensive practice opportunities to reach beyond simplistic “point and click” manuals. These practical tools ensure that students will become designers, developers, and informed users of simple Access™ databases today and throughout their careers. The Sixth Edition is ideal for a non-technical audience in introductory database and Access™ courses. Four preview chapters are available on the Companion Website until the end of September.

Full Product Details

Author:   Maggie Trigg ,  Phyllis Dobson
Publisher:   Pearson Education (US)
Imprint:   Pearson
Edition:   6th edition
Dimensions:   Width: 21.60cm , Height: 2.40cm , Length: 27.60cm
Weight:   1.216kg
ISBN:  

9780321517012

ISBN 10:   0321517016
Pages:   672
Publication Date:   29 August 2007
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Out of stock  

Table of Contents

Preface Chapter 1 Access and Data Basics 1.1 Introducing Data 1.2 Introducing Other Database Objects 1.3 Starting Access 1.4 Recognizing Screen Layout 1.5 Touring Access 1.6 Using Access Help 1.7 Exiting Access 1.8 Defining a Relational Database 1.9 Designing a Database Chapter 2 Creating a Database 2.1 Introducing Database Files 2.2 Creating Database Files 2.3 Creating a Table 2.4 Setting Field Properties 2.5 Printing the Table Design 2.6 Modifying Table Design 2.7 Entering Data in the Datasheet View 2.8 Formatting and Setting Access Options 2.9 Printing Records 2.10 Maintaining Data Integrity Chapter 3 Using a Table 3.1 Performing Basic Data Maintenance 3.2 Importing and Linking Data 3.3 Creating Information from Data 3.4 Restructuring Table Design 3.5 Setting and Removing Simple Relationships Chapter 4 Queries 4.1 Defining a Query 4.2 Creating a Simple Select Query 4.3 Working with Criteria 4.4 Creating Total Queries 4.5 Utilizing Other Query Features 4.6 Creating Queries with Multiple Tables Chapter 5 Forms 5.1 Defining a Form 5.2 Creating a Form Using the Form Tool 5.3 Working with Form Views 5.4 Creating Other Types of Forms 5.5 Using the Form Wizard Chapter 6 Reports 6.1 Defining a Report 6.2 Creating a Report 6.3 Working with a Report 6.4 Creating a Report with the Labels Tool 6.5 Creating a Report with the Report Wizard 6.6 Creating a Mail Merge Report with Word Chapter 7 Database Design and Maintenance 7.1 Designing a Relational Database 7.2 Normalizing Tables 7.3 Using Advanced Field Properties 7.4 Maintaining Referential Integrity 7.5 Maintaining Databases Chapter 8 Advanced Queries and SQL 8.1 Building Parameter Queries 8.2 Creating Action Queries 8.3 Summarizing Data with Crosstab Queries 8.4 Using Expressions in Queries 8.5 Viewing Property Sheets 8.6 Defining SQL 8.7 Retrieving Data with the Select Statement Chapter 9 Custom Forms 9.1 Planning, Designing, and Starting a Form 9.2 Working with Unbound Controls 9.3 Working with Bound Controls 9.4 Customizing the Form:Working with other Controls 9.5 Creating Other Forms 9.6 Saving a Form as a Report Chapter 10 Custom Reports 10.1 Getting Started with a Custom Report 10.2 Working with Bound Controls 10.3 Formatting the Report 10.4 Using the Report 10.5 Working with Subtotals, Totals, and Subreports 10.6 Using the Blank Report Chapter 11 Macros 11.1 Introducing Events and Macros 11.2 Creating a Macro 11.3 Enhancing Macros 11.4 Running and Debugging Macros 11.5 Creating Conditional Macros 11.6 Using Special Macros 11.7 Running Macros from Command Buttons Chapter 12 Building a Database Application 12.1 Developing an Application 12.2 Developing an Interface 12.3 Creating and Using Switchboards 12.4 Developing an Interface Without a Switchboard 12.5 Modal Dialog Form 12.6 Customizing the Quick Access Toolbar 12.7 Controlling Startup Functions Appendix A: Answers to Selected Exercises Appendix B: Access Functions Appendix C: Glossary Index

Reviews

Author Information

Phyllis Dobson is a CIS instructor at a community college near Denver. Maggie Trigg is a CIS professional/consultant in Denver and used to teach Access at Denver--area community colleges.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions