Microsoftï¿½ Accessï¿½ 2010

Name: Microsoftï¿½ Accessï¿½ 2010
Availability: InStock
ISBN: 9780735626928

ISBN-10: 0735626928

ISBN-13: 9780735626928

Edition: 2011

Authors: Joan Lambert, Microsoft Press Active Education Staff, Joyce Cox, C. D. Frye

List price: $49.99

30 day, 100% satisfaction guarantee!

Semester Rental: $18.68 Due date: 8/14/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $8.04

Marketplace

4 new & used from $5.01

what's this?

Rush Rewards U
Members Receive:

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

Teach yourself how to build database solutions with Access 2010. Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; and using filters and queries.

Book details

List price: $49.99
Copyright year: 2011
Publisher: Microsoft Press
Publication date: 7/15/2010
Binding: Paperback
Pages: 448
Size: 7.50" wide x 9.00" long x 1.25" tall
Weight: 1.540
Language: English

Joyce Cox has more than 30 years' experience in the development of training materials about technical subjects for non-technical audiences and is the author of dozens of books about Office and Windows technologies. Joyce is vice president of Online Training Solutions, Inc. (OTSI). Previously, she was president of and principal author for Online Press, where she developed the Quick Course series of computer training books for beginning and intermediate adult learners. She was also the first managing editor of Microsoft Press, an editor for Sybex, and an editor for the University of California.



Introducing Microsoft Access 2010


New Features


Let's Get Started!; Modifying the Display of the Ribbon


Dynamic Ribbon Elements


Changing the Width of the Ribbon


Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help


Getting Help with This Book


Getting Help with Access 2010


More Information; Simple Database Techniques



Explore an Access 2010 Database



Working in Access 2010



Understanding Database Concepts



Exploring Tables



Exploring Forms



Exploring Queries



Exploring Reports



Previewing and Printing Access Objects



Key Points



Create Databases and Simple Tables



Creating Databases from Templates



Creating Databases and Tables Manually



Manipulating Table Columns and Rows



Refining Table Structure



Creating Relationships Between Tables



Key Points



Create Simple Forms



Creating Forms by Using the Form Tool



Changing the Look of Forms



Changing the Arrangement of Forms



Key Points



Display Data



Sorting Information in Tables



Filtering Information in Tables



Filtering Information by Using Forms



Locating Information That Matches Multiple Criteria



Key Points



Create Simple Reports



Creating Reports by Using a Wizard



Modifying Report Design



Previewing and Printing Reports



Key Points; Relational Database Techniques



Maintain Data Integrity



Restricting the Type of Data



Restricting the Amount of Data



Restricting the Format of Data



Restricting Data by Using Validation Rules



Restricting Data to Values in Lists



Restricting Data to Values in Other Tables



Key Points



Create Custom Forms



Modifying Forms Created by Using a Wizard



Adding Controls



Adding Subforms



Using E-Mail Forms to Collect Data



Key Points



Create Queries



Creating Queries by Using a Wizard



Creating Queries Manually



Using Queries to Summarize Data



Using Queries to Perform Calculations



Using Queries to Update Records



Using Queries to Delete Records



Key Points



Create Custom Reports



Creating Reports Manually



Modifying Report Content



Adding Subreports



Key Points; Database Management and Security



Import and Export Data



Importing Information



Exporting Information



Copying to and from Other Office Programs



Key Points



Make Databases User Friendly



Creating Navigation Forms



Creating Custom Categories



Controlling Which Features Are Available



Key Points



Protect Databases



Assigning Passwords to Databases



Splitting Databases



Securing Databases for Distribution



Preventing Database Problems



Key Points



Customize Access



Changing Default Program Options



Customizing the Ribbon



Customizing the Quick Access Toolbar



Key Points


Glossary


Keyboard Shortcuts


General Shortcut Keys


Keys for Working with Text and Data


Keys for Navigating Records


Keys for Working with the Ribbon


Keys for Working with Online Help


Keys for Basic Office Tasks


About The Authors


Joyce Cox


Joan Lambert


The Team


Online Training Solutions, Inc. (OTSI)