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

Similer Documents