Book description
Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward language. You'll learn how out-of-the-box templates and reusable components make Access 2010 a fast and simple database solution.
Here's WHAT you'll learn:
Design and build your own database quickly
Use Access forms to collect information with ease
Create and modify tables to organize your data
Store files such as documents and images
Exchange data with other databases and documents
Bring your data alive with colorful reports
Here's HOW you'll learn it:
Jump in whenever you need answers
Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
Handy TIPS teach new techniques and shortcuts
Quick TRY THIS! exercises help apply what you learn right away
Table of contents
- Microsoft® Access® 2010 Plain & Simple
- 1. Introduction: About This Book
-
2. What’s New in Access 2010?
- Managing Access Settings and Files in Backstage View
- Customizing the Access 2010 User Interface
- Creating Databases Using Improved Templates
- Building Databases by Re-Using Application Parts
- Creating Navigation Forms
- Formatting Database Objects Using Office Themes
- Gaining Insights into Data Using Conditional Formatting
- Defining Calculated Fields Using the Improved Expression Builder
- 3. Introducing Access 2010
-
4. Creating a Database
- Designing a Database
- Viewing a Sample Database
- Creating a New Database
- Creating Databases Using Database Templates
- Creating a New Table in Design View
- Creating a New Table by Typing
- Creating a New Table Using a Template
- Creating a New Table Using Application Parts
- Setting a Primary Key
- Getting Data from Other Access 2010 Tables
- Relationships Explained
- Creating Relationships Between Tables
- Enforcing Referential Integrity
-
5. Customizing Fields
- Working with Tables
- Assigning a Data Type
- Viewing or Changing Field Properties
- Introducing the Expression Builder
- Formatting Field Contents
- Creating Input Masks
- Assigning Required Fields and Requiring Data Entry
- Setting Default Values
- Indexing Field Values
- Validating Data Entry
- Creating a Lookup Field
- Creating an Append-Only Memo Field
- Creating an Attachment Field
- 6. Customizing Tables
- 7. Creating Forms
-
8. Creating Queries
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Creating a Parameter Query
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
-
9. Creating Reports
- Creating a Report Using the Report Wizard
- Creating a Summary Report
- Creating a Report in Design View
- Modifying an Existing Report
- Adding and Deleting Report Controls
- Calculating Values in a Report
- Introducing Report Sections
- Grouping Report Records
- Creating a Subform or Subreport
- Creating Mailing Labels
-
10. Beautifying Forms and Reports
- Formatting Text
- Introducing Office Themes
- Applying Office Themes
- Setting Control Appearance
- Adding Lines, Shapes, and Borders
- Showing Gridlines in a Report
- Coloring Alternate Rows in a Form or Report
- Adding a Totals Row to a Worksheet
- Adding a Picture
- Applying Conditional Formatting
- Changing the Source of an Image
- Setting Image Alignment and Backing Color
- Tiling a Picture
- Setting Image Height and Width
- 11. Creating Charts in Access 2010
-
12. Interacting with Other Programs
- Introducing Linking and Embedding
- Inserting a New Object
- Manipulating Objects
- Inserting Excel 2010 Charts and Worksheets
- Importing Data from Another Access 2010 Database
- Linking to a Table in Another Access 2010 Database
- Working with Hyperlinks
- Importing Data from an Excel 2010 File
- Importing Data from a Text File
- Importing Data from an XML File
- Exporting Data to a Text File
- Exporting Data to Another Access 2010 File
- Exporting Data to an XML File
- Saving Database Objects As Web Files
- Analyzing Data with Excel 2010
- Publishing Data to Word 2010
- Collecting Data from E-mail Messages
- 13. Administering a Database
- 14. Customizing Access 2010
- 15. Presenting Table and Query Data Dynamically
- A. About the Author
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® Access® 2010 Plain & Simple
- Author(s):
- Release date: June 2010
- Publisher(s): Microsoft Press
- ISBN: 9780735647350
You might also like
book
Using Microsoft® Access® 2010
Get comfortable with Access 2010. Don’t just read about it: see it, hear it, with step-by-step …
book
Microsoft® Access® 2010 Inside Out
You're beyond the basics, so dive right in and really put your database skills to work! …
book
Microsoft® Access® 2010: Step by Step
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With …
book
2007 Microsoft® Office System Plain & Simple
Get the fast facts that make learning the 2007 Microsoft Office system plain and simple! This …