Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Jan's CompLit 101 > Working with Databases > Basics > Interface > Status Bar
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Databases

   Basics: Interface: Status Bar

The Status Bar hides down at the bottom of the window. It looks quite bare a lot of the time. Its job is to let you know what is going on - what the status is. 

Status Bar - labeled (Access 2010)

Message Area:

Shows a message about what the active object is or an explanation about what to do with it.

The database designer might create a message about what you should enter in a field. The illustration above shows that the Date box in the Assignments/Tests form needs the date assigned (for an assignment) or (for a test) the date that the test was given. The designer could have given a hint about the format of that date. Should it be April 3, 2014 or 04-03-2014 or 4/3/14 or 4/3/2014?


Examples of messages in Message Area:

Current View: 
What is selected
Current  Action:
What is happening
Current Object:
What it is or what to enter

Status Bar: Message: Datasheet View (Access 2010)
Status Bar: Message: Form View (Access 2010)
Status Bar: Message: Design View (Access 2010)

Status Bar: Message: Ready
Status Bar: Message: Calculating
Status Bar: Message: Updating (Access 2010)

Status Bar: Message: Name called if not first name
Status Bar: Message: r = Reading, S = Spelling, E = English
Status Bar: Message - / means to ignore (Access 2010)

This kind of explanation message is set in the design of the table's field or of the control in a form or report.


Progress Bar

Status Bar: Progress Bar Status Bar: Progress Bar (Access2016)

A progress bar appears toward the right end of the Status Bar when you are doing something that takes a while, like saving a database with a new name, coverting a database to a different file format, importing data, or exporting data. For a small database on a fast computer, the action may finish before the progress bar can display.


Mode Indicators

Status Bar: Mode Indicators (Access 2010)

Status Bar: Mode Indicators (Access 2016)

The middle section of the Status Bar can be set to show you what 'modes' are turned on. If you don't know one of these is on, you might get quite confused about what your keystrokes do or why records are missing. Most of these toggle on and off with a key on the keyboard.

Explanation of Common Modes:

Caps Lock: Key = Caps Lock Key: Caps Lock
When ON, all your typing uses capital letters automatically - except the number keys. When OFF, typing works as usual.

Num Lock: Key = Num Lock Key: Num Lock
When ON, the numeric pad keys type numbers. When OFF, those keys act as arrow keys.

Scroll Lock: Key = Scroll Lock Key: Scroll Lock
Does not seem to do anything in Access but a database designer might assign it a function.

Overtype: Key = Insert Key: Insert

When ON, your typing replaces the characters to the right. When OFF, your typing is inserted in between existing characters.

Filtered: Current data has a filter applied. When this word does not show on the Status bar, there are no filters in place.

Icon: TipWhen you don't see as many records as you expect, check the Status Bar to see if there is a filter turned on.


View Buttons

The right end of the Status Bar has shortcut buttons to switch the view of the current object.

Different types of object have different possible views. The icons for these views are similar in the recent versions of Access.

Table: Status Bar: Views - Table (Access 2010) Status Bar: Views - Table (Access 2016)
          Datasheet, Pivot Table, Pivot Chart, Design

Query: Status Bar: Views - Query (Access 2010) Status Bar: Views - Query (Access 2016)
          Datasheet, SQL, Design

Form: Status Bar: Views - Form (Access 2010) Status Bar: Views - Form (Access 2016)
          Form, Datasheet, Pivot Table, Pivot Chart, Layout, Design

Report: Status Bar: Views - Report (Access 2010) Status Bar: Views - Report (Access 2016)
          Report, Print Preview, Design

Zoom: Status Bar: Zoom Status Bar: Zoom (Access 2016)
A slider control zooms the Print Preview for a report, but does not seem to be available for anything else.

Resize window: It's not a view, but at the bottom right of the Status Bar is a triangle of dots Status Bar: Resize in Access 2007 and 2010. When the mouse pointer is over this area, its shape changes to dialog arrows Pointer: Diagonal resize. Drag to resize the whole window. Access 2013 and 2016 assume that you know the window is resizable.


Customize Status Bar

Right Click Menu: Status Bar - all checked (Access 2010)You can pick what features to show on the Status Bar. Just right click the Status Bar to see a list. Click an item to toggle it on or off. The illustration at the right has all choices checked, which means that an indicator will show on the Status Bar, but only if the item is ON.

Some items can show their current status over to the right in the context menu, like Caps Lock does.

Note: Kana Mode allows Japanese alphabetic characters.