Microsoft's Access 2000 is a relational database program that allows one to store and
analyze database records or data. Unlike other databases, Access allows one to
store a number of related tables and options in a single database instead of
creating a new database for each table. In addition, we cover the following topics:
Chapter 1: Introduction to Access
- Introduction
- What is an Access Database?
- Starting Access
- Exploring the Task Pane
- Opening a Database File
- Introducing the Database Window
- Getting to know the Access Screen
- Saving and closing a Database File
- Opening a Recently Used Database File
- Exiting Access
Chapter 2: Working with Database
- Introduction
- Using the Database Wizard
- Working with Datasheets
- Moving Between Records
- Using Go To
- Updating Records
- Selecting Rows and Columns
- Finding Records
- Changing Column Width
- Saving and Closing a Datasheet
- Performing Database Maintenance
Chapter 3: Working with Tables
- Introduction
- Creating a New Database
- Adding Tables to a Database
- Adding Fields to Tables
- Setting a Primary Key
- Saving a Table
- Adding Records to a Table
- Sorting and Filtering Records
- Importing Data
- Using the Office Clipboard
- Exporting Data as a Web Page
- Using the Table Wizards
Chapter 4: Creating and Running Queries
- Introduction
- What is a Query?
- Creating a Query
- Working with Queries
- Saving and Running a Query
- Creating Calculated Fields
- Understanding Query Properties
- Creating Multi-Table Select Queries
- Joining Tables
- Enforcing Referential Integrity
- Printing Table Relationships
- Using Sub-datasheets
Chapter 5: Using Forms
- Introduction
- What is a Form?
- Using an AutoForm
- Creating a Form with the Form Wizard
- Working in Design View
- Applying an AutoFormat
- Changing the Form Layout
- Using Calculated Controls
- Working with Records on a Form
- Creating a Data Access Page
Chapter 6: Generating Reports
- Introduction
- What is a Report?
- Creating an AutoReport
- Previewing and Printing a Report
- Saving a Report
- Designing a Report
- Changing the Report Layout
- Understanding Controls
- Using a Calculated Control
- Creating Mailing Labels
Would you like to learn MS Access 2000/XP? We provide
home tutoring service.
Please
contact us
for any additional information.
