Teach yourself visually Microsoft Office Access 2007 / by Faithe Wempen.

Format:

Book

Author/Creator:

Wempen, Faithe.

Series:

Visual read less, learn more.

Visual read less, learn more

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Physical Description:

1 online resource (321 p.)

Edition:

1st edition

Other Title:

Microsoft Office Access 2007

Access 2007

Place of Publication:

New York, NY : Wiley Pub., c2007.

Language Note:

English

System Details:

text file

Summary:

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) work

Contents:

Teach Yourself Visually Microsoft Office Access 2007; Table of Contents; How to Use This Book; Chapter 1 Getting Started with Access 2007; An Introduction to Access; Start and Exit Access; Create a Blank Database; Close a Database; Create a Database Using a Template; Open a Database File; Understanding the Access 2007 Interface; Change the Navigation Pane View; Open and Close an Object; View an Object; Chapter 2 Entering and Editing Data; Enter New Records; Navigate between Records; Edit Records; Attach Files to Records; Open, Save, and Remove File Attachments; Insert an OLE Object

Open, Edit, and Remove OLE ObjectsEnter Data in a Multivalued Field; Delete Records; Resize Datasheet Columns and Rows; Sort Records; Display Summary Statistics; Print a Datasheet or Form; Chapter 3 Working with 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; Chapter 4 Working with Fields; Open a Table in Design View

Rearrange FieldsInsert and Delete Fields; Understanding Data Types; Change a Field's Data Type; Understanding Field Properties; Understanding Field Sizes; Change a Field Size; Set a Field's Format; Set a Field Caption; Set a Default Value; Make a Field Required; Index a Field; Apply Smart Tags; Create an Input Mask; Create a Validation Rule; Create a Record-Level Validation Rule; Chapter 5 Working with Relationships and Lookups; Understanding Relationships; Create a Relationship between Two Tables; Edit a Relationship; Remove a Relationship; Arrange the Relationships Window

Print a Relationship ReportView Object Dependencies; Document the Database; Understanding Lookups; Create a Table for Use As a Field Lookup; Create a Field Lookup Based on a Table; Create a Field Lookup with Values That You Specify; Set Up a Multivalued Field; Chapter 6 Finding and Filtering Data; Understanding Find and Replace; Find Data Using Find and Replace; Replace Data Using Find and Replace; Filter to Show Only Blank or Nonblank Entries; Filter by Selection; Filter for Multiple Values; Using Text Filters; Filter by Form; Save a Filter As a Query; Chapter 7 Creating Simple Queries

Understanding QueriesCreate a Query with the Simple Query Wizard; Start a New Query in Query Design View; Insert, Arrange, and Remove Query Fields; Set Field Sorting; Add an Alias to a Query Field; Understanding Criteria; Filter a Query for a Specific Value; Specify a Range of Values; Specify a List of Values; Hide a Field in the Query Results; Combine Criteria; Limit the Records Returned; Chapter 8 Creating More Complex Queries; Understanding Summary Queries; Create a Summary Query with the Simple Query Wizard; Create a Summary Query in Query Design View; Understanding Calculated Fields

Create a Calculated Field

Notes:

Description based upon print version of record.

ISBN:

9786611238100

9781281238108

1281238104

9780470377727

0470377720

OCLC:

244206087