Microsoft Access Version 2002 Inside Out (Inside Out (Microsoft))

ISBN: 0735612838
EAN: 2147483647

Year: 2005
Pages: 172

Authors: Helen Feddema

BUY ON AMAZON

Cover
LOC Page
Dedication
Acknowledgments
Wed Like to Hear from You
Conventions and Features Used in This Book
Chapter 1 - Exploring What s New in Access 2002
Office-Wide Changes
Access Changes
ADP Project Changes
XML and Access
Data Access Page Changes
Chapter 2 - Overview of Basic Access Features
Uses of Microsoft Access
Creating Databases, Data Access Pages, and Projects
Using Online Help
Navigating the Access Interface
Choosing Your Access Preferences
Chapter 3 - Introduction to Database Design
Overview of Database Concepts
Database Design Considerations
Design Considerations for Large or Complex Databases
Design Example: The Crafts Database
Database Terminology
Chapter 4 - Creating a Database
Naming Database Objects
Creating Tables
Creating Relationships
Working with Database Tools
Chapter 5 - Creating Forms for Entering, Editing, and Viewing Data
Working with Form Views
Creating Forms with the Form Wizard
Creating Forms Manually Using Design View
Creating Data Entry Forms
Giving Your Forms a Consistent Look
Form Features and Properties
Form Record Sources
Using Forms to Display Linked Data
Using Forms to Display Unlinked Data
Chapter 6 - Working with Form Controls
Placing Controls on Forms
Naming Controls
Commonly Used Controls
Less Frequently Used Controls
Setting Control Properties
Working with ActiveX Controls
Chapter 7 - Using Reports to Print Data
Printing Forms vs. Printing Reports
Working with Report Controls
Designing Reports
Adding Embedded Subreports and Subforms to Reports
Formatting Reports
Understanding Report Features and Properties
Chapter 8 - Using Design Tools
Using the Toolbox to Insert Native Controls
Using the Grid
Selecting Multiple Controls
Sizing, Aligning, and Grouping Controls
Putting It All Together
Working with ActiveX Controls
Chapter 9 - Using Queries to Select Data
An Introduction to the Query Environment
The Simple Query Wizard
Summarizing Data
Retrieving Data
Evaluating Expressions with Calculated Fields
Limiting Data
Sorting Records
Grouping and Summarizing Records
Relationships Between Data Sources
Creating Crosstab Queries
Optimizing Queries
Chapter 10 - Using Action Queries
Protecting Your Data
Changing Data with an Update Query
Adding Data with an Append Query
Deleting Records with a Delete Query
Creating and Running a Make-Table Query
Distinguishing Between Updatable and Nonupdatable Queries
Using Queries to Archive Data
Chapter 11 - Working with Advanced Queries
Using Parameter Queries
Using Union Queries
Using Pass-Through Queries
Understanding Data-Definition Queries
Using Subqueries as an Alternative to Multiple Queries
Chapter 12 - Using PivotTables and PivotCharts to Analyze Data
Using PivotTables to Organize Your Data
Creating a Basic PivotTable
Using PivotCharts to Display Data Graphically
Creating a Basic PivotChart
Chapter 13 - Customizing Access Toolbars and Menus (Command Bars)
Customizing Built-In Access Command Bars
Placing Custom Commands on Menus and Toolbars
Creating Custom Command Bars in the Interface
Assigning Toolbars, Menus, and Shortcut Menus to Forms and Controls
Working with the Customize Dialog Box
Creating Custom Command Bars and Their Controls in Code
Chapter 14 - Using Macros
Access Macros - Then and Now
Creating Simple Macros
Creating Macro Conditions
Creating Special-Purpose Macros
Replacing Macros with VBA Code
Chapter 15 - Using Add-Ins to Expand Access Functionality
An Overview of Add-Ins
Using Built-In Access Add-Ins
Using Microsoft Office XP Developer Add-Ins
Installing Add-Ins
Using Helen Feddema s Add-Ins
Using the Database Wizard to Create a Database from a Database Template
Chapter 16 - Importing and Linking Data to Access
Importing vs. Linking Data
Selecting File Types for Importing and Linking
Importing and Linking Using the Interface
Importing and Linking Data Using VBA Code
Using Queries to Reformat Imported Mainframe Data
Chapter 17 - Exporting Data from Access
Exporting Data Using the Interface
Exporting Data Using VBA Code
Chapter 18 - Working with Data Access Pages
Understanding Data Access Pages
Anatomy of a Data Access Page
Creating Data Access Pages
Deploying Data Access Pages on the Web
Chapter 19 - Creating Access Projects
Access Project Components
Creating a Project File for an Existing SQL Server Back-End Database
Creating a Project File for a New SQL Server Back-End Database
Creating SQL Server Tables in a Project
Understanding Views, Stored Procedures, and User-Defined Functions
Using Forms in Access Projects
Using Reports in Access Projects
Writing Code in Access Projects
Chapter 20 - Customizing Your Database Using VBA Code
An Overview of VBA Programming
Working with Object Models
Using the Visual Basic Editor
Writing Form and Report Event Procedures
Using the Printer Object in Code
Chapter 21 - Creating Your Own Add-Ins
Creating Access Add-Ins
Creating COM Add-Ins
Appendix A - Setup and Installation
Appendix B - Distributing Access Applications
Appendix C - Security
Appendix D - Replication
Appendix E - Upsizing to SQL Server
Appendix F - Control Properties
About the Author
About This Electronic Book
Create a List of Favorite Topics
External Links
Enlarge Graphics
Use Accessibility Shortcut Keys
Use the Shortcut Menu Commands
To Turn On MouseKeys
Customize the Help Viewer
Print the Current Topic
Full-Text Search
Use Full-Text Search
Advanced Full-Text Search
Search for Information
Find Information with Advanced Full-Text Search
Search for Words or Phrases
Define Search Terms
Use Nested Expressions
Search for Words in the Titles of Topic Files
Find Words Similar to Your Search Term
Search Previous Results
About Microsoft Press