Teach Yourself VISUALLY Access 2010

Name: Teach Yourself VISUALLY Access 2010
Price: 4.65 USD
Availability: InStock
ISBN: 9780470577653

ISBN-10: 0470577657

ISBN-13: 9780470577653

Edition: 2010

Authors: Faithe Wempen

List price: $21.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $4.65

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

The visual way to get up to speed on Access 2010It'²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…

Book details

List price: $21.99
Copyright year: 2010
Publisher: John Wiley & Sons, Limited
Publication date: 5/11/2010
Binding: Paperback
Pages: 352
Size: 7.50" wide x 9.50" long x 0.75" tall
Weight: 1.782
Language: English




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



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



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



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



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



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



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



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



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



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



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



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



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



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



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



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



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