Access 2003
Identifying the Basic Parts of the Access Window
Introduction
By the end of this lesson, you should be able to:
- Identify the parts of the main Access window
- Identify the parts of the database window
- Understand the role of design windows
Launching Microsoft Access from the Windows desktop
Microsoft Access is launched from the Windows desktop in a manner similar to that used to launch Microsoft Word, Excel, and PowerPoint. You can launch Microsoft Access either from the desktop shortcut or from the Start program.
To open Microsoft Access using the desktop shortcut:
- Double-click the Microsoft Access shortcut icon on the Windows desktop.
To open Microsoft Access using the Start program:
- Click the Start button located in the bottom-left corner of the Windows screen.
- Click the Programs option on the Start menu.
- Click the Microsoft Access selection.
If Access does not appear, click the double-down areas immediately below the Microsoft PowerPoint entry, then locate Access from a complete list of software installed on your computer.
The main Access window
When you open Microsoft Access, many items you see are standard, just like with most Microsoft software programs like Word, Excel, and PowerPoint.
Menu bar
The Menu bar displays the menus available for use in Access 2003. The contents of any menu can be displayed by left-clicking the menu.
The main Access window
Toolbar
The pictured buttons in the toolbar are quick and easy shortcuts to specific actions. For example, if you want to save a spreadsheet using the menus, then you would first click File and then click Save. Using the toolbar to perform this save operation actually saves you a click. Click the save button once to save the spreadsheet.
Some commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the toolbar.
The database window
Database toolbar
The database toolbar presents operations that can be performed against different database objects, including buttons to open an object, design an object, create a new object, and delete an object.
Left pane
Database objects are created and opened by choosing any of the buttons listed in the left pane of the database window.
Right pane
Any of the first four options—tables, queries, forms, or reports—opens additional choices related to that selection in the right pane.
Choosing the tables button, for example, displays at least three options in the right pane: Create a table in Design view, Create a table by using wizard, and Create table by entering data. It also shows any objects you created in the database.
Challenge!
- Display the contents of the File, Edit, View, Insert, Tools, Window, and Help menus in the main Access menu bar. As each menu is displayed, you may want to write down the contents listed under each.
- Identify the operation performed by each button in the main Access toolbar.
- Some buttons in the toolbar also appear alongside options listed in a menu. For each button in the main Access toolbar, identify the menu where that operation can be performed.