Share
Create bookmark
Microsoft® Access® 2010 Plain & Simple
Notes
Please login to add notes
- Contents
- + Chapter 1. Introduction: About This Book
-
+
Chapter 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
- + Chapter 3. Introducing Access 2010
-
+
Chapter 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
-
+
Chapter 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
- + Chapter 6. Customizing Tables
- + Chapter 7. Creating Forms
-
+
Chapter 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
-
+
Chapter 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
-
+
Chapter 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
- + Chapter 11. Creating Charts in Access 2010
-
+
Chapter 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
- + Chapter 13. Administering a Database
- + Chapter 14. Customizing Access 2010
- + Chapter 15. Presenting Table and Query Data Dynamically
- + Index
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
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Web > Site Design
Publishers
Publication year : 2010
License: All rights reserved ©
Times read: 83
