Introduction to Microsoft Access
Microsoft Access Launching
Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM), in a small business to organize and manage all data, or in an enterprise to communicate with servers.
Like any other computer application, in order to use Microsoft Access, you must first open it. There are various ways you can do this. Microsoft Access is a classic computer application and it gets launched like the usual products you have probably been using. As such, to start this program, you could click Start -> (All) Programs -> Microsoft Office -> Microsoft Office Access 2003.
By default, Microsoft Office 2003 gets installed in the D:\Program Files\Microsoft Office\OFFICE11 folder. The shortcuts of its applications are also installed in that folder. The shortcut for Microsoft Office is named MSACCESS.EXE. This means that you could launch it from Windows Explorer or My Computer. To do this, locate the shortcut in Windows Explorer or My Computer and double-click it.
If you have a Microsoft Access database such as an E-Mail attachment, a file on a floppy disk, on the network, or in any other means, once you see its icon, you can double-click it. Not only will this action launch Microsoft Access, but also it will open the file.
You can also launch Microsoft Access from a shortcut. If you happen to use the software on a regular basis, you can create a shortcut on your desktop or on the Quick Launch area. Many users also take advantage of the Microsoft Office Shortcut Bar. Sometimes, the icon you need will not be there; in that case you should insert it manually.
If you are working on a network of related computers, your database may be located in another computer. In this case the network or database administrator would create a link or shortcut to the drive that is hosting the database. You can then click or double-click this link or shortcut to open the database and, as a result, launch Microsoft Access.
When Microsoft Access 2003 opens, it displays a rectangular window occupied in the top and the right sections while the middle section is empty:
As a regular Windows application, Microsoft Access shares some characteristics that are common to other programs. The top section of the interface is made of wide bar called the title bar:
The left section of the title bar displays a small picture known as the system icon. This icon is used to identify the application. The icon holds a list of actions you can use to close, minimize, maximize, move or restore the application. To perform any of these actions, you would click the system icon:
This list can also be referred to as the system menu. To use one of its items, you can click it. If you click the system icon, a menu would come up. If you click Move, you would notice that the mouse pointer changes its shape into a cross
You can use this system cursor to move the window:
The main area of a title bar is a long bar actually referred to as the title bar. This section is also used to perform the same operations available on the system menu. There are other operations you can perform different than the system menu depending on the way you click the main area of the title bar. For example to maximize Microsoft Access, you can double-click the title bar.
The right section of the title bar displays three small squares referred to as the system buttons. They are used to minimize, maximize, restore or close Microsoft Access. These items are
Under the title bar, there is a horizontal list of words. This list is made of items such as File, Edit, View, etc. Since there are various kinds of menus on this application, the menu on top will be referred to as the Main Menu and sometimes the Menu Bar.
To use a menu item, you click one of its words and the menu expands. When the menu has focus and you want to dismiss it, you can press Esc. If an item is missing from the main menu, you can customize it.
There are four main types of menus you will encounter:
On the main menu (and any menu), there is one letter underlined on each word. Examples are F in File, E in Edit, V in View, etc. The underlined letter is called an access key (the word access has nothing to do with Microsoft Access, it is used in this sense throughout Microsoft Windows and other operating systems). The access key allows you to access the same menu item using the keyboard. In order to use an access key, the menu should have focus first. The menu is given focus by pressing either the Alt or the F10 keys.
On some menu items, there is a key or a combination of keys we call a shortcut. This key or this combination allows you to perform the same action on that menu using the keyboard.
Under the menu bar, there is another bar made of various buttons. This is called a toolbar. The toolbars change a lot in Microsoft Access. As you spend more time with this application you will learn how to recognize these toolbars. Each toolbar has a proper name and we will learn how to recognize them.
At times, there will be many toolbars that come and go while you are using Microsoft Access. For this reason, we will refer to each toolbar by its name. To know the name of a toolbar, you can right-click any word on the menu bar or any button on the toolbar. If you have only one toolbar on your screen, its name will have a check box. The other name(s) on the context menu is (are) the one (those) you can add to the screen if you wish:
You can also create your own toolbar.
The status bar is a long horizontal bar that spans the whole bottom section of Microsoft Access. It will be used to provide some assistance or information about an item that is displaying or being accessed in Microsoft Access. At this time, it may be displaying Ready (and it means it)
A Microsoft Access database is primarily a Windows file like any other. It must have a location, also called a path, which indicates how the file can be retrieved and made available. Although you can create a database on the root directory such as the C: drive, it is usually a good idea to create your files, including your databases, in an easily recognizable folder.
Starting with Microsoft Windows 95 but except Windows NT 4.0, the operating system creates a folder called My Documents that provides a convenient place for a user to create files. With Windows 2000, XP, and 2003, there is also a My Documents folder but because various people may use the same computer, there is a different My Documents folder for each user. When a user logs in, the operating system locates his or her corresponding My Documents folder and makes it available.
Unlike some other programming environments, Microsoft Access considers a database as a single Windows file with a name. We will eventually learn that this file can contain various objects that actually make up a database. Therefore, a Microsoft Access database is opened as a normal file.
To open a database:
After creating or opening a database, unless the product is setup otherwise, the first object that appears is a rectangular box named the Database window:
The Database window is a classic object of Windows applications. It is equipped with a system icon on the left side of its title bar and three system buttons on the right side. Based on this, you can maximize, minimize, restore, or close it. You can also resize it by dragging one of its borders or corners. Because the Database window holds all objects that are part of a database, if you close the Database window, it also closes the database but leaves Microsoft Access opened. Because Microsoft Access is a Multiple Document Interface (MDI) application, if you maximize any of its child objects, such as the Database windows, the other objects that you subsequently open would be maximized also.
The objects of the Database window are organized in categories under the Objects Bar. To access a category, you can click its corresponding button. Once in the section of a category, to open an object:
The Database window is equipped with a title bar. Under the title bar, the window is equipped with a contextual toolbar. This means that the toolbar responds according to the object that is selected in the Database window. Besides the buttons that represent categories, when you click a button, one or three links allow you to create objects of that category. For example, you can create a table by double-clicking the Create Table By Using Wizard link.
Besides providing the ability to create a new object or open an existing one, you can also delete an object using the Database window’s toolbar. To do this, you can click the object to select it. Then, on this toolbar, click the Delete button. The Database window’s toolbar also provides four view buttons that allow you to change the way the list displays in the right side of the view. If you have used Windows Explorer, My Computer, or My Documents, you are probably familiar with these buttons. For example, here is the Database window that displays its list in Large Icons:
Context-sensitive help refers to help provided on a specific item on the screen. Such help is provided for objects that are part of Microsoft Access interface. It includes objects like buttons on toolbars and other objects. Context-sensitive help is also referred to as “What’s This?”.
To get context-sensitive help, you can press Shift + F1. In addition to the traditional arrow, the mouse cursor would be accompanied by a question mark. To get help on an object, you can just click it.
Another type of context sensitive help is provided in various dialog boxes. They display a button with a question mark on the left of the system Close button. To use this type of help, click the question mark button and click the item on which you need help.
The Office Assistant is a “character” or a “virtual person” whose main job is to provide instant help when using a Microsoft Office product. The Office Assistant is usually on top of Microsoft Access while you are working. If you do not like the way it looks, you can click it and click Options. This would present you with the Office Assistant property sheet in which the Gallery property page allows you to select a different Office Assistant. The Options property page allows you to configure the behavior and responsiveness of the Office Assistant.
To use its service, just click it, then type a word, a sentence, or a question. After pressing Enter, a primary list of possible matches would be displayed. If you do not find what is close to your request, you can use the available options or change your request.
If you do not want the Office Assistant on the screen while you are working, you can hide it. To do this, on the main menu, you can click Help -> Hide Office Assistant. To display it when it is not available, on the main menu, you can click Help -> Show the Office Assistant.
Online help is a separate program that provides help on Microsoft Access. There are two main types of online help:
Although help on the Internet tends to be disparate, it is still the widest form of help available. This is provided in web sites, web pages, newsgroups, support groups, etc. As the publisher of the database environment, it is only natural to refer to Microsoft corporate web site first for help. The Microsoft web site is divided in categories. A web site is dedicated to Microsoft Access at http://www.microsoft.com/access. You can get help at http://support.microsoft.com. Probably the most visited site of Microsoft for developers of all Microsoft products is http://msdn.microsoft.com. This last site provides a tree list that presents items in categories (like the MSDN CD-ROM or a DVD).
Since Microsoft Access shares the same functionality you are probably familiar with from using other applications, you can close it easily.
|Copyright © 2002-2007 Yevol||Next|