SECTION 1
Lesson 1.1: Using My Computer Within Access

   

 

 

If you are using Access to find a database file on your computer, you will see the Open dialogue box. In fact, if you are familiar with other word processing or productivity software when using Windows 2000 or Windows XP, this box will look familiar:

(Note that the proper name of this dialogue box is the ‘My Computer’ dialogue box and is used for saving and opening files in most Windows 2000/XP programs.)

 

Let’s examine the different parts of the dialogue box:

Look In

At the very top of the dialogue box is the Look In combo box. Click the pull-down arrow to list the different locations available on your computer (like the desktop, a CD or DVD drive, another hard drive, or any folders on your desktop.)

Top Toolbar

 

 

These buttons provide quick access to different features on your computer. You can hover your mouse over each icon for a few seconds to see what action it will perform. From left to right:

  • The Back icon will revisit any previous locations from which you have navigated.
  • The Up One Level icon will visit the root folder of the current folder.
  • (Consider the computer ‘address’ C:\WINDOWS\Fonts. WINDOWS is called a ‘root’ or ‘parent’ folder of Fonts, while Fonts is a subfolder or ‘child’ folder of WINDOWS.)
  • The Search the Web icon will open your Internet browser to its default search page.
  • The Delete icon will delete any file or folder that is currently selected.
  • The Create New Folder icon will make a new child folder inside the current folder you are viewing.
  • The Views icon will adjust the look of the icons currently displayed in the Open dialogue box.
  • The Tools submenu provides the Delete functionality described above as well as the ability to search for a Microsoft Office file based on certain criteria, rename the currently selected object, add the currently selected object to My Places (described below), map an external network resource not on your computer, and view the properties of the currently selected object.

My Places Toolbar

 

 

 

 

The My Places toolbar gives you quick access to the most commonly accessed resources. For example, no matter where you have navigated to on your computer, clicking the ‘Desktop’ icon will always bring you back to the view of your desktop.

File Name and Type

At the bottom of the Open dialogue box are the controls to type in a file path manually and change the format of file you are looking for.

 

Click the Open button to open the currently selected object or Cancel to stop the Open operation.

 

Should you ‘get lost’ while traversing your computer or go too far when looking for a file, you can always make use of the Back icon and the My Places Toolbar