Microsoft Office Access 2003 in a Snap
Published on 26. August 2004
Book
Paperback/Softback
336 pages
978-0-672-32544-1 (ISBN)
Description
Microsoft Access is a database development and maintenance program, but it can be confusing when trying to learn how to complete the tasks required to create an application. Microsoft Access 2003 In a Snap can quickly show you how to complete a specific task in an easy-to-follow format complete with illustrated steps. Sections of the book are organized into task categories such as Table Creation, Queries and Form Design. Intended to keep you focused and on-target, this book does not spend time explaining database architecture or application design. If you are the casual Access user or if you use it in your day-to-day work life, this book is a great reference tool!
More details
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Width: 231 mm
Thickness: 19 mm
Weight
562 gr
ISBN-13
978-0-672-32544-1 (9780672325441)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
Alison Balter is the founder of InfoTechnology Partners, Inc., a California-based computer consulting firm. Alison is a highly experienced independent trainer and consultant, specializing in Windows applications training and development. During her seventeen years in the computer industry, she has trained and consulted with many corporations and government agencies, including Shell Oil, Prudential Insurance and the Archdiocese of Los Angeles. Alison is the author of over 300 internationally marketed computer training videos.
Content
I. INTRODUCTION TO RELATIONAL DATABASES AND ACCESS.
1. Start Here.
What Is a Relational Database?
What Types of Things Can I Do with Microsoft Access?
Starting Microsoft Access.
Opening an Existing Database.
The Access Desktop.
The Database Window.
A Preview of the Database Components.
Closing an Access Database.
Viewing and Navigating Table Data.
II. WORK WITH EXISTING DATABASES AND OBJECTS.
2. Working with an Existing Table.
Edit Table Data.
Add Records to a Table.
Delete Records from a Table.
Find and Replace Text in a Table.
Filter Table Data.
Modify the Appearance of a Datasheet.
Spell-Check Your Data.
Using the AutoCorrect Feature.
3. Working with an Existing Query.
Open a Query in Datasheet View.
Open a Query in Design View.
Add Fields to a Query.
Order a Query Result.
Refine a Query with Criteria.
Save a Query.
Print a Query Result.
Close a Query.
4. Working with an Existing Form.
Open a Form.
Work with Data.
Find Data.
Replace Data.
Sort Data.
Filter Data.
Close a Form.
Highlight Important Data with Conditional Formatting.
5. Working with an Existing Report.
Open and View a Report.
Move From Page to Page.
Zoom In and Out.
View Multiple Pages.
Print a Report.
Close a Report.
Print Database Objects.
III. CREATE YOUR OWN DATABASE AND OBJECTS.
6. Use Wizards to Create a Database.
Use a Database Template to Create a Database.
Create a New Empty Database.
Create a Table Using the Table Wizard.
Create a Query Using the Query Wizard.
Create a Form Using the Form Wizard.
Create a Report Using the Report Wizard.
7. Design and Create Your Own Tables.
About Task Analysis.
About Database Analysis and Design.
About Relational Database Design.
About the Application Development Process.
Build a New Table.
About Selecting the Appropriate Field Type for Your Data.
Set a Primary Key.
8. Create Your Own Relationships.
About the Types of Relationships.
Establish Relationships.
Establish Referential Integrity.
9. Create Your Own Queries.
Create Queries.
Order a Query Result.
About Refining a Query with Advanced Criteria.
Update Query Results.
About Building Queries Based on Multiple Tables.
Create Calculated Fields.
Get Help from the Expression Builder.
10. Create Your Own Forms.
Create a Form in Design View.
Add Controls.
About Selecting Controls.
Move, Size, and Delete Controls.
Align Controls.
About Selecting the Correct Control.
Change the Tab Order of Controls.
About Form Properties.
Work with Combo Boxes and List Boxes.
11. Create Your Own Reports.
Create a Report in Design View.
About Working with Report Sections.
About Working with Controls.
Create Groups and Totals Reports.
About Working with Report Properties.
Create Reports Based on Multiple Tables.
IV. POWER ACCESS TECHNIQUES.
12. Power Table Techniques.
About Working with Field Properties.
Look Up Values in a Table or Query.
About Working with Table Properties.
Improve Performance with Indexes.
13. Power Query Techniques.
Apply Advanced Filters.
Create and Run Parameter Queries.
Create and Run Action Queries.
Incorporate Aggregate Functions.
Refine Your Queries with Field, Field List, and Query Properties.
14. Access and the Internet.
Export to HTML.
Export to XML.
Import from HTML.
Import from XML.
Create and Modify Data Access Pages.
Save PivotTables and PivotCharts to Data Access Pages.
15. Database Administration.
Back Up and Restore a Database.
Compact and Repair a Database.
Encode and Decode a Database.
Convert a Database to Another Version.
Make an MDE File.
Use the Database Splitter.
16. Finishing Touches.
Add Toolbars.
Add Menu Bars.
Build Switchboards.
About Setting Startup Options.
1. Start Here.
What Is a Relational Database?
What Types of Things Can I Do with Microsoft Access?
Starting Microsoft Access.
Opening an Existing Database.
The Access Desktop.
The Database Window.
A Preview of the Database Components.
Closing an Access Database.
Viewing and Navigating Table Data.
II. WORK WITH EXISTING DATABASES AND OBJECTS.
2. Working with an Existing Table.
Edit Table Data.
Add Records to a Table.
Delete Records from a Table.
Find and Replace Text in a Table.
Filter Table Data.
Modify the Appearance of a Datasheet.
Spell-Check Your Data.
Using the AutoCorrect Feature.
3. Working with an Existing Query.
Open a Query in Datasheet View.
Open a Query in Design View.
Add Fields to a Query.
Order a Query Result.
Refine a Query with Criteria.
Save a Query.
Print a Query Result.
Close a Query.
4. Working with an Existing Form.
Open a Form.
Work with Data.
Find Data.
Replace Data.
Sort Data.
Filter Data.
Close a Form.
Highlight Important Data with Conditional Formatting.
5. Working with an Existing Report.
Open and View a Report.
Move From Page to Page.
Zoom In and Out.
View Multiple Pages.
Print a Report.
Close a Report.
Print Database Objects.
III. CREATE YOUR OWN DATABASE AND OBJECTS.
6. Use Wizards to Create a Database.
Use a Database Template to Create a Database.
Create a New Empty Database.
Create a Table Using the Table Wizard.
Create a Query Using the Query Wizard.
Create a Form Using the Form Wizard.
Create a Report Using the Report Wizard.
7. Design and Create Your Own Tables.
About Task Analysis.
About Database Analysis and Design.
About Relational Database Design.
About the Application Development Process.
Build a New Table.
About Selecting the Appropriate Field Type for Your Data.
Set a Primary Key.
8. Create Your Own Relationships.
About the Types of Relationships.
Establish Relationships.
Establish Referential Integrity.
9. Create Your Own Queries.
Create Queries.
Order a Query Result.
About Refining a Query with Advanced Criteria.
Update Query Results.
About Building Queries Based on Multiple Tables.
Create Calculated Fields.
Get Help from the Expression Builder.
10. Create Your Own Forms.
Create a Form in Design View.
Add Controls.
About Selecting Controls.
Move, Size, and Delete Controls.
Align Controls.
About Selecting the Correct Control.
Change the Tab Order of Controls.
About Form Properties.
Work with Combo Boxes and List Boxes.
11. Create Your Own Reports.
Create a Report in Design View.
About Working with Report Sections.
About Working with Controls.
Create Groups and Totals Reports.
About Working with Report Properties.
Create Reports Based on Multiple Tables.
IV. POWER ACCESS TECHNIQUES.
12. Power Table Techniques.
About Working with Field Properties.
Look Up Values in a Table or Query.
About Working with Table Properties.
Improve Performance with Indexes.
13. Power Query Techniques.
Apply Advanced Filters.
Create and Run Parameter Queries.
Create and Run Action Queries.
Incorporate Aggregate Functions.
Refine Your Queries with Field, Field List, and Query Properties.
14. Access and the Internet.
Export to HTML.
Export to XML.
Import from HTML.
Import from XML.
Create and Modify Data Access Pages.
Save PivotTables and PivotCharts to Data Access Pages.
15. Database Administration.
Back Up and Restore a Database.
Compact and Repair a Database.
Encode and Decode a Database.
Convert a Database to Another Version.
Make an MDE File.
Use the Database Splitter.
16. Finishing Touches.
Add Toolbars.
Add Menu Bars.
Build Switchboards.
About Setting Startup Options.