book

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Name: Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007
Author: Faithe Wempen
ISBN: 9780470045916

by Faithe Wempen

January 2007

Beginner

303 pages

8h 46m

English

Visual

Read now

Unlock full access

Copyright
Trademark AcknowledgmentsContact Us
Praise for Visual Books
Credits
About the Author
Author's Acknowledgments
How to Use This Book
How to Use This Teach Yourself VISUALLY BookWho Needs This BookBook OrganizationChapter OrganizationUsing the MouseThe Conventions in This Book
1. Getting Started with Access 2007
1.1. An Introduction to Access1.2. Start and Exit Access1.3. Create a Blank Database1.4. Close a Database1.5. Create a Database Using a Template1.6. Open a Database File1.7. Understanding the Access 2007 Interface1.8. Change the Navigation Pane View1.9. Open and Close an Object1.10. View an Object
2. Entering and Editing Data
2.1. Enter New Records2.2. Navigate between Records2.3. Edit Records2.4. Attach Files to Records2.5. Open, Save, and Remove File Attachments2.6. Insert an OLE Object2.7. Open, Edit, and Remove OLE Objects2.8. Enter Data in a Multivalued Field2.9. Delete Records2.10. Resize Datasheet Columns and Rows2.11. Sort Records2.12. Display Summary Statistics2.13. Print a Datasheet or Form
3. Working with Tables
3.1. Plan Effective Tables3.2. Create a Table from a Template3.3. Save a Table3.4. Create a Table in Datasheet View3.5. Create a Table by Copying Another Table's Structure3.6. Create a SharePoint List3.7. Create a Table in Design View3.8. Understanding Primary and Composite Keys3.9. Set the Primary or Composite Key3.10. Rename a Table3.11. Delete a Table
4. Working with Fields
4.1. Open a Table in Design View4.2. Rearrange Fields4.3. Insert and Delete Fields4.4. Understanding Data Types4.5. Change a Field's Data Type4.6. Understanding Field Properties4.7. Understanding Field Sizes4.8. Change a Field Size4.9. Set a Field's Format4.10. Set a Field Caption4.11. Set a Default Value4.12. Make a Field Required4.13. Index a Field4.14. Apply Smart Tags4.15. Create an Input Mask4.16. Create a Validation Rule4.17. Create a Record-Level Validation Rule

5. Working with Relationships and Lookups
5.1. Understanding Relationships5.2. Create a Relationship between Two Tables5.3. Edit a Relationship5.4. Remove a Relationship5.5. Arrange the Relationships Window5.6. Print a Relationship Report5.7. View Object Dependencies5.8. Document the Database5.9. Understanding Lookups5.10. Create a Table for Use As a Field Lookup5.11. Create a Field Lookup Based on a Table5.12. Create a Field Lookup with Values That You Specify5.13. Set Up a Multivalued Field
6. Finding and Filtering Data
6.1. Understanding Find and Replace6.2. Find Data Using Find and Replace6.3. Replace Data Using Find and Replace6.4. Filter to Show Only Blank or Nonblank Entries6.5. Filter by Selection6.6. Filter for Multiple Values6.7. Using Text Filters6.8. Filter by Form6.9. Save a Filter As a Query
7. Creating Simple Queries
7.1. Understanding Queries7.2. Create a Query with the Simple Query Wizard7.3. Start a New Query in Query Design View7.4. Insert, Arrange, and Remove Query Fields7.5. Set Field Sorting7.6. Add an Alias to a Query Field7.7. Understanding Criteria7.8. Filter a Query for a Specific Value7.9. Specify a Range of Values7.10. Specify a List of Values7.11. Hide a Field in the Query Results7.12. Combine Criteria7.13. Limit the Records Returned
8. Creating More Complex Queries
8.1. Understanding Summary Queries8.2. Create a Summary Query with the Simple Query Wizard8.3. Create a Summary Query in Query Design View8.4. Understanding Calculated Fields8.5. Create a Calculated Field8.6. Understanding Action Queries8.7. Run a Make Table Query8.8. Run a Delete Query8.9. Run an Append Query8.10. Run an Update Query8.11. Prompt the User for a Parameter8.12. Understanding Parameter Syntax
9. Creating Forms
9.1. Understanding Forms9.2. Create and Save a Form9.3. Create a Form with the Form Wizard9.4. Create a Form in Layout View9.5. Create a Form in Design View9.6. Delete a Field from Design View9.7. Arrange Fields on a Form9.8. Group Fields Together9.9. Define the Tab Order on a Form
10. Modifying and Formatting Forms
10.1. Display the Header and Footer10.2. Size Sections of a Form10.3. Select Sections of a Form10.4. Add a Form Title10.5. Apply an AutoFormat Preset10.6. Apply an AutoFormat Style10.7. Create an AutoFormat Style by Example10.8. Adjust Internal Margins and Padding10.9. Add a Label10.10. Format Label Text10.11. Change the Background Color10.12. Add a Hyperlink10.13. Add a Tabbed Section10.14. Insert a Logo or Image10.15. Set Conditional Formatting
11. Creating and Formatting Reports
11.1. Understanding Report Views11.2. Create a Simple Report11.3. AutoFormat a Report11.4. Preview and Print a Report11.5. Create a Report with the Report Wizard11.6. Create a Report in Layout View11.7. Set the Page Size and Orientation11.8. Change the Report Layout Type11.9. Set Page Margins11.10. Set Control Margins and Padding11.11. Format Report Text11.12. Size and Align Report Fields11.13. Insert a Page Numbering Code
12. Grouping and Summarizing Data
12.1. Understanding Grouping and Summarizing12.2. Group Report Results12.3. Sort Report Results12.4. Count Records12.5. Add an Aggregate Function12.6. Summarize a Datasheet with a PivotTable12.7. Add Aggregate Functions to a PivotTable12.8. Group and Ungroup PivotTable Content12.9. Clear a PivotTable Grid12.10. Switch a PivotTable to a PivotChart
13. Creating Mailing Labels and Charts
13.1. Create Labels13.2. Add a Field to an Existing Line13.3. Add a Field to a Label As a Separate Line13.4. Color the Label Background13.5. Color the Label Text13.6. Apply Font Formatting to Label Text13.7. Export Labels to Word13.8. Open a PivotChart View13.9. Create a PivotChart13.10. Group Data in a PivotChart13.11. Change the PivotChart Type13.12. Change Chart Colors
14. Working with External Data
14.1. Import an Excel Worksheet14.2. Link to an Excel Worksheet14.3. Manage Linked Tables14.4. Import a Table from Another Access Database14.5. Import Data from a Delimited Text File14.6. Export Data to Excel14.7. Export Data as HTML14.8. Export Data to a Plain Text File14.9. Save Import or Export Specifications14.10. Using Saved Import or Export Specifications
15. Maintaining a Database
15.1. Set a Trusted Location15.2. Save in a Previous Version Format15.3. Convert to the Access 2007 Format15.4. Back Up a Database15.5. Document a Database15.6. Compact and Repair a Database15.7. Password-Protect a Database

Content preview from Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Chapter 3. Working with Tables

Tables form the basis of any database. A table's structure defines the fields and their properties and specifies how data should be entered. In this chapter, you will learn to create and manage tables.

Plan Effective Tables
Create a Table from a Template
Save a Table
Create a Table in Datasheet View
Create a Table by Copying Another Table's Structure
Create a SharePoint List
Create a Table in Design View
Understanding Primary and Composite Keys
Set the Primary or Composite Key
Rename a Table
Delete a Table

Plan Effective Tables

As a database designer, you have the opportunity to create tables in your database that match your storage ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Special Edition Using Microsoft® Office Access 2003

Publisher Resources

ISBN: 9780470045916Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

by Faithe Wempen

Chapter 3. Working with Tables

Plan Effective Tables

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.