Book description
Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up, and you will find clear, step-by-step screen shots that show you how to tackle more than 170 Access 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including
* Navigating the new interface
* Using templates to create databases
* Entering and editing data
* Working with tables and fields
* Creating simple or summary queries
* Linking to Excel(r) worksheets
* Helpful sidebars offer practical tips and tricks
* Full-color screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules
Table of contents
- Copyright
- Praise for Visual Books
- Credits
- About the Author
- Author's Acknowledgments
- How to Use This Book
-
1. Getting Started with Access 2007
- 1.1. An Introduction to Access
- 1.2. Start and Exit Access
- 1.3. Create a Blank Database
- 1.4. Close a Database
- 1.5. Create a Database Using a Template
- 1.6. Open a Database File
- 1.7. Understanding the Access 2007 Interface
- 1.8. Change the Navigation Pane View
- 1.9. Open and Close an Object
- 1.10. View an Object
-
2. Entering and Editing Data
- 2.1. Enter New Records
- 2.2. Navigate between Records
- 2.3. Edit Records
- 2.4. Attach Files to Records
- 2.5. Open, Save, and Remove File Attachments
- 2.6. Insert an OLE Object
- 2.7. Open, Edit, and Remove OLE Objects
- 2.8. Enter Data in a Multivalued Field
- 2.9. Delete Records
- 2.10. Resize Datasheet Columns and Rows
- 2.11. Sort Records
- 2.12. Display Summary Statistics
- 2.13. Print a Datasheet or Form
-
3. Working with Tables
- 3.1. Plan Effective Tables
- 3.2. Create a Table from a Template
- 3.3. Save a Table
- 3.4. Create a Table in Datasheet View
- 3.5. Create a Table by Copying Another Table's Structure
- 3.6. Create a SharePoint List
- 3.7. Create a Table in Design View
- 3.8. Understanding Primary and Composite Keys
- 3.9. Set the Primary or Composite Key
- 3.10. Rename a Table
- 3.11. Delete a Table
-
4. Working with Fields
- 4.1. Open a Table in Design View
- 4.2. Rearrange Fields
- 4.3. Insert and Delete Fields
- 4.4. Understanding Data Types
- 4.5. Change a Field's Data Type
- 4.6. Understanding Field Properties
- 4.7. Understanding Field Sizes
- 4.8. Change a Field Size
- 4.9. Set a Field's Format
- 4.10. Set a Field Caption
- 4.11. Set a Default Value
- 4.12. Make a Field Required
- 4.13. Index a Field
- 4.14. Apply Smart Tags
- 4.15. Create an Input Mask
- 4.16. Create a Validation Rule
- 4.17. Create a Record-Level Validation Rule
-
5. Working with Relationships and Lookups
- 5.1. Understanding Relationships
- 5.2. Create a Relationship between Two Tables
- 5.3. Edit a Relationship
- 5.4. Remove a Relationship
- 5.5. Arrange the Relationships Window
- 5.6. Print a Relationship Report
- 5.7. View Object Dependencies
- 5.8. Document the Database
- 5.9. Understanding Lookups
- 5.10. Create a Table for Use As a Field Lookup
- 5.11. Create a Field Lookup Based on a Table
- 5.12. Create a Field Lookup with Values That You Specify
- 5.13. Set Up a Multivalued Field
- 6. Finding and Filtering Data
-
7. Creating Simple Queries
- 7.1. Understanding Queries
- 7.2. Create a Query with the Simple Query Wizard
- 7.3. Start a New Query in Query Design View
- 7.4. Insert, Arrange, and Remove Query Fields
- 7.5. Set Field Sorting
- 7.6. Add an Alias to a Query Field
- 7.7. Understanding Criteria
- 7.8. Filter a Query for a Specific Value
- 7.9. Specify a Range of Values
- 7.10. Specify a List of Values
- 7.11. Hide a Field in the Query Results
- 7.12. Combine Criteria
- 7.13. Limit the Records Returned
-
8. Creating More Complex Queries
- 8.1. Understanding Summary Queries
- 8.2. Create a Summary Query with the Simple Query Wizard
- 8.3. Create a Summary Query in Query Design View
- 8.4. Understanding Calculated Fields
- 8.5. Create a Calculated Field
- 8.6. Understanding Action Queries
- 8.7. Run a Make Table Query
- 8.8. Run a Delete Query
- 8.9. Run an Append Query
- 8.10. Run an Update Query
- 8.11. Prompt the User for a Parameter
- 8.12. Understanding Parameter Syntax
- 9. Creating Forms
-
10. Modifying and Formatting Forms
- 10.1. Display the Header and Footer
- 10.2. Size Sections of a Form
- 10.3. Select Sections of a Form
- 10.4. Add a Form Title
- 10.5. Apply an AutoFormat Preset
- 10.6. Apply an AutoFormat Style
- 10.7. Create an AutoFormat Style by Example
- 10.8. Adjust Internal Margins and Padding
- 10.9. Add a Label
- 10.10. Format Label Text
- 10.11. Change the Background Color
- 10.12. Add a Hyperlink
- 10.13. Add a Tabbed Section
- 10.14. Insert a Logo or Image
- 10.15. Set Conditional Formatting
-
11. Creating and Formatting Reports
- 11.1. Understanding Report Views
- 11.2. Create a Simple Report
- 11.3. AutoFormat a Report
- 11.4. Preview and Print a Report
- 11.5. Create a Report with the Report Wizard
- 11.6. Create a Report in Layout View
- 11.7. Set the Page Size and Orientation
- 11.8. Change the Report Layout Type
- 11.9. Set Page Margins
- 11.10. Set Control Margins and Padding
- 11.11. Format Report Text
- 11.12. Size and Align Report Fields
- 11.13. Insert a Page Numbering Code
-
12. Grouping and Summarizing Data
- 12.1. Understanding Grouping and Summarizing
- 12.2. Group Report Results
- 12.3. Sort Report Results
- 12.4. Count Records
- 12.5. Add an Aggregate Function
- 12.6. Summarize a Datasheet with a PivotTable
- 12.7. Add Aggregate Functions to a PivotTable
- 12.8. Group and Ungroup PivotTable Content
- 12.9. Clear a PivotTable Grid
- 12.10. Switch a PivotTable to a PivotChart
-
13. Creating Mailing Labels and Charts
- 13.1. Create Labels
- 13.2. Add a Field to an Existing Line
- 13.3. Add a Field to a Label As a Separate Line
- 13.4. Color the Label Background
- 13.5. Color the Label Text
- 13.6. Apply Font Formatting to Label Text
- 13.7. Export Labels to Word
- 13.8. Open a PivotChart View
- 13.9. Create a PivotChart
- 13.10. Group Data in a PivotChart
- 13.11. Change the PivotChart Type
- 13.12. Change Chart Colors
-
14. Working with External Data
- 14.1. Import an Excel Worksheet
- 14.2. Link to an Excel Worksheet
- 14.3. Manage Linked Tables
- 14.4. Import a Table from Another Access Database
- 14.5. Import Data from a Delimited Text File
- 14.6. Export Data to Excel
- 14.7. Export Data as HTML
- 14.8. Export Data to a Plain Text File
- 14.9. Save Import or Export Specifications
- 14.10. Using Saved Import or Export Specifications
- 15. Maintaining a Database
Product information
- Title: Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007
- Author(s):
- Release date: January 2007
- Publisher(s): Visual
- ISBN: 9780470045916
You might also like
book
Microsoft® Office Access™ 2007 Plain & Simple
Get the fast facts that make learning Microsoft Office Access 2007 plain and simple! This no-nonsense …
book
Special Edition Using Microsoft® Office Access 2003
Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of …
book
What’s New in Microsoft® Office Access 2007?
Microsoft Office Access 2007 includes a plethora of new features that could prove difficult to find …
book
Microsoft® Office Access 2003 Inside Out
Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving …