Microsoft Access 2010

ISBN-10: 0470577657

ISBN-13: 9780470577653

Edition: 2010

Authors: Faithe Wempen

List price: $21.99 Buy it from $3.00
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


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 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 tasksThis unparalleled book contains everything you need to know to use Access 2010 effectively.
New Starting from $23.44
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought

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
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.