Download Plain Simple MS Access 2010 PDF

TitlePlain Simple MS Access 2010
File Size21.2 MB
Total Pages289
Table of Contents
                            Table of Contents
Chapter 1. Introduction: About This Book
	No Computerese!
	A Quick Overview
	A Few Assumptions
	A Final Word (or Two)
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
	Introducing Databases
	Starting Access 2010
	Surveying the Access 2010 Window
	Opening a Database
	Viewing Multiple Database Objects
	Closing a Database and Exiting Access 2010
	Displaying and Managing Database Objects
	Using the Access 2010 Help System
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. CustomizingTables
	Finding and Replacing Text
	Entering Data Using AutoCorrect
	Adding and Editing Text
	Manipulating Columns
	Modifying Columns and Rows
	Viewing a Subworksheet
	Filtering Table Records
Chapter 7. Creating Forms
	Creating a Simple Form
	Creating a Form Using the Form Wizard
	Creating a Form in Design View
	Creating a Multiple Items Form
	Modifying an Existing Form
	Adding and Deleting Form Controls
	Adding a Date Picker Control
	Creating a Subform
	Displaying a Form and Its Datasheet Simultaneously
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
	Creating a Chart
	Formatting Chart Elements
	Customizing Chart Axes
	Add Information to a Chart
	Changing a Chart’s Type
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
	Introducing Database Security
	Encrypting a Database
	Locking Database Records
	Creating a Navigation Form
	Documenting a Database
	Setting Startup Options
Chapter 14. Customizing Access 2010
	Adding Commands to the Quick Access Toolbar
	Modifying the Ribbon User Interface
	Changing AutoCorrect Options
Chapter 15. Presenting Table and Query Data Dynamically
	Introducing PivotTables and PivotCharts
	Creating a PivotTable
	Adding and Removing PivotTable Fields
	Pivoting a PivotTable
	Filtering PivotTable Data
	Formatting a PivotTable
	Creating a PivotChart
Document Text Contents
Page 2


Access® 2010 Plain & Simple


Page 144

Adding and Deleting Report Controls
After you create a report, you can add controls like labels, text
boxes, check boxes, and option buttons to display your table
and query data . The specific steps you take to add a control
and define its data source depend on the control you want to
create, but the control wizards are there to help you through
the process .

When you create a control, you actually create a control (such
as a text box) and a label identifying the control . You can
delete, modify, or move the label without affecting its associ-
ated control .

Add a Control Using a Wizard

1 Open a report in Design view .

2 If necessary, click the Design tab .

3 If necessary, click the Controls gal-
lery’s More button .

4 Click Use Control Wizards .

5 Click the control you want to add .

6 Drag the mouse pointer on the report
to define the control’s area .

7 If a control wizard appears, follow its
steps to define the contents of the
control . If not, you can modify the
control using the formatting tech-
niques found in this section and in
Section 10, “Beautifying Forms and
Reports .”






Adding and Deleting Report Controls 135

Creating Reports

Page 145

Delete a Control

1 Right-click the control you want
to delete .

2 Click Delete .



For more information about controls and
control types, see the table “Available Con-
trol Types” on page 97 .

See Also

When you delete a control, be sure
to click the control itself—not the
label next to the control .


You can change the value in a control’s
label by editing the label directly or by
setting the control’s Caption property .


Modify Control Properties

1 Open the report in Design view .

2 Click the control .

3 Click Property Sheet .

4 Click the property to change .

5 Follow one of these steps:

• Type a new value in the text box
next to the property name .

• Click the down arrow, and select
a new property from the list that
appears .

• Click the Build button and use the
dialog box that appears to select or
construct a new value .

3 4



136 Adding and Deleting Report Controls

Page 289

Stay in touch!
To subscribe to the Microsoft Press® Book Connection Newsletter—for news on upcoming books, events, and special offers—please visit:


What do you think
of this book?
We want to hear from you!

To participate in a brief online survey, please visit:

Tell us how well this book meets your needs —what works effectively, and what we can do better .
Your feedback will help us continually improve our books and learning resources for you .

Thank you in advance for your input!


Similer Documents