25 Books to Read Before You Die
 
 

Recently Viewed clear list


Original Essays | August 20, 2014

Julie Schumacher: IMG Dear Professor Fitger



Saint Paul, August 2014 Dear Professor Fitger, I've been asked to say a few words about you for Powells.com. Having dreamed you up with a ball-point... Continue »
  1. $16.07 Sale Hardcover add to wish list

    Dear Committee Members

    Julie Schumacher 9780385538138

spacer
Qualifying orders ship free.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
4 Remote Warehouse Personal Computers- Desktop Applications- Databases
11 Remote Warehouse Personal Computers- Desktop Applications- Databases

This title in other editions

Teach Yourself Visually #64: Teach Yourself Visually Access 2010

by

Teach Yourself Visually #64: Teach Yourself Visually Access 2010 Cover

 

Synopses & Reviews

Publisher Comments:

The visual way to get up to speed on Access 2010

It's one thing to gain access to Access. It's another thing entirely to figure out how to do all the things you want to do in Access, because the software is not all that intuitive. This full-color guide clearly shows you how to get the most out of Access 2010, including how to enter new records; create, edit, and design tables and forms; organize, analyze, and share data; generate concise reports; and much more.

With pages of step-by-step instructions, graphics, and helpful advice, this is the visual learner's Access book-keep this on your desk and flip to what you need, any time!

  • Explores the very latest features, functions, and tools of Access 2010, a database software tool that is part of the new Microsoft Office 2010
  • Teaches you how to enter new records and create, edit, and design tables and forms
  • Explains how to organize, analyze, and share data; generate concise reports; add smart tags to tables, save backup copies of your data; and more
  • Demonstrates through step-by-step instructions and numerous, full-color screen shots and graphics, so you can see exactly how to perform tasks

This unparalleled book contains everything you need to know to use Access 2010 effectively.

Synopsis:

Teach Yourself Visually

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'll find clear, step-by-step screen shots that show you how to tackle more than 185 Access 2010 tasks. Each task-based spread covers a single technique, sure to help you get up and running with Access 2010 in no time.

You'll learn to:

  • Create databases

  • Build tables to store information

  • Find and filter data

  • Develop forms and reports

  • Create queries

  • Back up and repair a database

  • Two-page lessons break big topics into bite-sized modules

  • Succinct explanations walk you through step by step

  • Full-color screen shots demonstrate each task

  • Helpful sidebars offer practical tips and tricks

About the Author

Faithe Wempen, M.A., is a Microsoft Office Specialist Master Instructor and the author of over 100 books on computer hardware and software, including the PowerPoint 2010 Bible, Microsoft Office 2010 for Seniors for Dummies, and A+ Certification Workbook for Dummies.

Faithe is currently an adjunct instructor of computer information technology at IUPUI, where she teaches PC hardware and software architecture and A+ certification. Her online courses for corporate clients, including Hewlett Packard, Sony, and CNET, have educated over a quarter of a million students all over the world.

Table of Contents

Chapter 1: Getting Started with Access 2010.

An Introduction to Access 2010.

Start and Exit Access.

Create a Blank Database.

Close a Database.

Create a Database by Using a Template.

Open a Database File.

Understanding the Access 2010 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 Objects.

Enter 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 in Datasheet View.

Save a Table.

Create a Table in Design View.

Open a Table in Design View.

Rearrange Fields.

Insert and Delete Fields.

Understanding Data Types.

Change a Field’s Data Type.

Understanding Primary and Composite Keys.

Set the Primary or Composite Key.

Rename a Table.

Delete a Table.

Copy a Table.

Chapter 4: Working with Fields.

Understanding Field Properties.

Understanding Field Sizes.

Change a Field Size.

Set a Field Caption.

Set a Field’s Format.

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 Report.

View 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 by Using Find and Replace.

Replace Data by 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 Queries.

Create 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.

Understanding Action Queries.

Run a Make Table Query.

Run a Delete Query.

Run an Append Query.

Run an Update Query.

Prompt the User for a Parameter.

Understanding Parameter Syntax.

Chapter 9: Creating Forms.

Understanding Forms.

Create and Save a Form.

Create a Form with the Form Wizard.

Create a Form in Layout View.

Create a Form in Design View.

Delete a Field from Design View.

Arrange Fields on a Form.

Group Fields.

Define the Tab Order on a Form.

Chapter 10: Modifying and Formatting Forms.

Display the Header and Footer.

Resize Sections of a Form.

Select Sections of a Form.

Add a Form Title.

Apply a Theme.

Apply a Font Theme or Color Theme.

Create a Custom Font Theme.

Create a Custom Color Theme.

Create a Custom Theme.

Browse for a Theme to Apply.

Adjust Internal Margins and Padding.

Add a Label.

Format Label Text.

Change the Background Color.

Use a Background Image.

Add a Hyperlink.

Add a Tabbed Section.

Insert a Logo or Image.

Set Conditional Formatting.

Chapter 11: Creating and Formatting Reports.

Understanding Report Views.

Create a Simple Report.

Apply a Theme to a Report.

Preview and Print a Report.

Create a Report with the Report Wizard.

Create a Report in Layout View.

Set the Page Size and Orientation.

Change the Report Layout Type.

Set Page Margins.

Set Control Margins and Padding.

Format Report Text.

Size and Align Report Fields.

Insert a Page-Numbering Code.

Chapter 12: Grouping and Summarizing Data.

Understanding Grouping and Summarizing.

Group Report Results.

Sort Report Results.

Count Records.

Add an Aggregate Function.

Summarize a Datasheet with a PivotTable.

Add and Delete Aggregate Functions in a PivotTable.

Group and Ungroup PivotTable Content.

Clear a PivotTable Grid.

Switch a PivotTable to a PivotChart.

Chapter 13: Creating Mailing Labels.

Create Labels.

Add a Field to an Existing Line.

Add a Field to a Label as a Separate Line.

Color the Label Background.

Color the Label Text.

Apply Font Formatting to Label Text.

Export Labels to Word.

Chapter 14: Creating Charts.

Understanding Charts in Access.

Open a PivotChart View.

Start a PivotChart Form.

Construct a PivotChart.

Group Data in a PivotChart.

Change the PivotChart Type.

Change Chart Colors.

Create an Embedded Chart Object.

Chapter 15: Working with External Data.

Import an Excel Worksheet.

Link to an Excel Worksheet.

Link to an Outlook Folder.

Manage Linked Tables.

Import a Table from Another Access Database.

Import Data from a Delimited Text File.

Export Data to Excel.

Export Data as HTML.

Export Data to a Plain Text File.

Save Import or Export Specifications.

Using Saved Import or Export Specifications.

Chapter 16: Performing a Mail Merge with Microsoft Word.

Begin a Mail Merge.

Create the Main Document in Word.

Insert an Address Block.

Insert a Greeting Line.

Match Fields.

Insert Individual Fields.

Preview the Merge Results.

Filter the Recipient List.

Sort the Recipient List.

Merge to a New Document.

Merge Directly to a Printer.

Save the Merge for Later Use.

Chapter 17: Maintaining a Database.

Set a Trusted Location.

Save in a Previous Version Format.

Convert to the Access 2007/2010 Format.

Back Up a Database.

Document a Database.

Compact and Repair a Database.

Password-Protect a Database.

Create a Switchboard.

Set Switchboard Startup Options.

Product Details

ISBN:
9780470577653
Author:
Wempen, Faithe
Publisher:
Visual
Subject:
Database Management - General
Subject:
Desktop Applications - MS Access
Subject:
Database management
Subject:
Books on Access, guide to Access 2010, guide to Access, how to use Access, how to use Access 2010, instructions on Access 2010, Access 2010, Microsoft Office 2010, database software, using access
Subject:
Microsoft Access
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Copyright:
Series:
Teach Yourself VISUALLY (Tech)
Series Volume:
64
Publication Date:
20110406
Binding:
Electronic book text in proprietary or open standard format
Language:
English
Illustrations:
Y
Pages:
352
Dimensions:
9.26x7.42x.73 in. 1.75 lbs.

Other books you might like

  1. Story of My Life (Vintage... Used Trade Paper $4.50
  2. Not for Profit: Why Democracy Needs... Used Hardcover $12.00
  3. Yves Saint Laurent New Hardcover $65.00
  4. Libertarianism, from A to Z Sale Trade Paper $7.98
  5. Excel 2010 Visual Quick Tips Used Trade Paper $13.95

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Databases

Teach Yourself Visually #64: Teach Yourself Visually Access 2010 New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 352 pages Visual - English 9780470577653 Reviews:
"Synopsis" by , Teach Yourself Visually

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'll find clear, step-by-step screen shots that show you how to tackle more than 185 Access 2010 tasks. Each task-based spread covers a single technique, sure to help you get up and running with Access 2010 in no time.

You'll learn to:

  • Create databases

  • Build tables to store information

  • Find and filter data

  • Develop forms and reports

  • Create queries

  • Back up and repair a database

  • Two-page lessons break big topics into bite-sized modules

  • Succinct explanations walk you through step by step

  • Full-color screen shots demonstrate each task

  • Helpful sidebars offer practical tips and tricks

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.