Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.
Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.
Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.
Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.
Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.
Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.
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. Access and Data Basics; Creating a Database; Using a Table; Queries; Forms; Reports; Database Design and Maintenance; Advanced Queries and SQL; Custom Forms; Custom Reports; Macros; Building a Database Application.
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
More About This Textbook
Overview
Access and Data Basics; Creating a Database; Using a Table; Queries; Forms; Reports; Database Design and Maintenance; Advanced Queries and SQL; Custom Forms; Custom Reports; Macros; Building a Database Application.
For all readers interested in Access™ 2007.
Product Details
Related Subjects
Meet the Author
Maggie Trigg is a CIS professional/consultant in Denver and used to teach Access at Denver–area community colleges.
Table of Contents
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