Free Delivery Over $100
|
|
|||
|
||||
OverviewBy 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 DetailsAuthor: Maggie Trigg , Phyllis DobsonPublisher: Pearson Education (US) Imprint: Pearson Edition: 6th edition Dimensions: Width: 21.60cm , Height: 2.40cm , Length: 27.60cm Weight: 1.216kg ISBN: 9780321517012ISBN 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 ContentsPreface 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 IndexReviewsAuthor InformationPhyllis 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 6Author Website:Countries AvailableAll regions |
||||
