Access XP Beginners Tutorial Created By Internet Fixes!

Microsoft Access is a versatile relational database program that enables you to efficiently store and retrieve data. This handout explains how to navigate the Access interface, create simple tables and queries, and relate information from one table to another.

Starting Access


1. On the PC, select Start, Programs, and Microsoft Access from the Start list. Microsoft Access Icon
2 Double-click on the icon of any Access database. When you double-click an Access database, Access opens with the database already loaded.

Exploring the Access Interface


Components of the Access Window

Besides the usual window components (close box, title bar, scroll bars, etc.), an Access window has several unique elements identified in the figure below.

The Database Toolbar

The Database toolbar, located beneath the menu bar, has buttons for commonly performed tasks like accessing the Relationships window, adding Objects, Exporting to Office, and other operations. Access let's you customize the toolbar or even display multiple toolbars at the same time. The Standard Access XP toolbar appears undocked in the figure below.

The Data sheet Toolbar

The Data sheet toolbar provides common tasks for editing an object in Data sheet view. The Database toolbar will automatically change into the Data sheet toolbar when this view is selected. The Data sheet tool bar exists between different objects, thus, this toolbar largely remains consistent.

Datasheet Toolbar

The Design Toolbar

The Design toolbar provides common tasks for editing an object in Design view. The Database toolbar will automatically change into the Design toolbar when this view is selected. The Design tool bar exists between different objects, and thus, maintains much of the same functionality.

The Design Toolbar

Common Database Features

Access provides a quick and convenient method of accessing the most common tasks. This includes switching between views, opening and creating new databases, and a few minor formatting issues

All products mentioned are registered trademarks or trademarks of their respective companies.
Questions or problems regarding this web site should be directed to the
Webmaster.
Copyright 1999-2006 Internet Fixes. All rights reserved.      
Legal Disclaimer

This Site Is Part Of The Internet Fixes Network!

Page Was Last Updated On 06/03/2008