• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 3. Navigating Within Acces > Understanding Access's Table Display

Understanding Access's Table Display

You're probably familiar with the basic terms for many of the components that comprise the basic window in which all conventional Windows 95 applications run. (These controls, although similar in function, have a somewhat different appearance and location than those used in Windows 3.x.) The presentation of Access windows differs with each basic function that Access performs. Because Part I of this book deals almost exclusively with tables, the examples that follow use Table view. Figure 3.2 shows Access for Windows's basic display for operations with tables. Table 3.1 describes the window's individual components.

Table 3.1. Components of the Access Display for Tables
Active windowThe window to which all mouse and keyboard actions are directed. When an application or document is active, its title bar appears in color (dark blue, unless you have changed your Windows color scheme). If the application title bar and a document title bar are active, the docu-ment title bar receives the mouse and keyboard actions.
Application Control-menu boxThe icon for the application Control menu that controls the presentation of the application window. You display the application Control menu by clicking the box or pressing Alt+spacebar.
Application title barA bar at the top of the application's window that displays its name. You can move the entire application, if it isn't maximized, by clicking the application title bar and dragging it to a new position.
Application windowThe window within which Windows displays Access. Each application that you launch runs within its own application window. (Figure 3.2 shows the maximized Access 97 application window.)
CaretA vertical flashing line that indicates the insertion point for keyboard entry in areas of a window that accept text. (The caret isnOt visible in Figure 3.2.)
Current Record buttonA button that indicates a single selected record in the table. When you are editing the current record, the button icon displays a pencil rather than a triangular arrow. The Current Record button also is called the record pointer.
Current Record selectionButtons that position the record pointer to the first, next, preceding, and last record number in the table, and show the number of the currently selected record. If the table has a key field, the record number reflects the sequence of records in the primary key's sorting order; if there is no primary key in the table, the record number corresponds to the order in which records were physically added to the table.
Database windowThe window that controls the operating mode of Access and selects the active document window's current function. From the database components displayed in the Database window, you select the component (such as a particular table) to display in the document window.
Document Control-menu boxThe icon for the document Control menu that controls a document window's presentation. To access the document Control menu, click the box or press Alt+- (hyphen).
Document title barAt the top of each document's window, a bar that displays the document's name. You can move the document, if it isn't maximized, by clicking the application title bar and dragging the document to a new position.
Document windowThe window that displays an Access database component. Tables, queries, forms, reports, macros, and modules are referred to as documents in Windows terminology. You can have multiple Access documents of any type open simultaneously. These windows are called multiple document interface (MDI) child windows because the Access application window is their parent.
Field scroll barThe scroll bar that enables you to view table fields that are outside the bounds of the document window. Record scroll bars provide access to records located outside the document window.
Function tabsSix tabs with which you select a page that displays a list of tables, queries, forms, reports, macros, or modules in the database.
Inactive windowA window in the background, usually with a grayed title bar. Clicking the surface of an inactive window makes it active and brings it to the front. If an inactive window is not visible because other windows obscure it, you can make the window active by choosing its name from the W indow menu.
Maximize buttonA button that causes Access to occupy your entire display. Clicking the document's Maximize button causes the document to take over the entire display. When a window is maximized, as shown in Figure 3.2, this button's icon changes to the Restore button. Figure 3.3 shows a maximized table document.
MenubarA horizontal bar containing the main menu choices. The specific menubar choices and the commands in the menus themselves change depending on Access's status. Menubars and toolbars collectively are called command bars.
Minimize buttonA button that enables you to collapse the application or document window to an icon at the bottom of your display.
Mode buttons Three buttons that determine the operating mode of Access. Open places Access in Run mode. New or Design puts Access in Design mode, where you can create or edit tables.
New Record button A button with an asterisk that indicates the location of the next record to be added to a table. Entering data in the new record appends the record to the table and creates another new record.
Restore buttonA double set of boxes that, when clicked, returns the window from full display to its normal size, with movable borders. When displayed, the Restore button takes the place of the Maximize button in the window's upper-right corner.
Status barA bar, located at the bottom of the application window, that displays prompts and indicators, such as the status of the Num Lock key.
ToolbarA bar containing command buttons that duplicate the more commonly used menu choices. The number and type of toolbar buttons change depending on which basic function of Access you are using.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint