web analytics

ELEMENTS OF THE MICROSOFT ACCESS 2010 WORKING SCREEN – PART 2

Microsoft Access 2010

This article is the second part of the topic: Elements of the Microsoft Access 2010 Working Screen.

6. Now the customers table is in front and the customers tab is highlighted to indicate that it is the active table. Whether you open multiple tables, queries, forms, reports, macros or any combination of these you’ll be able to move among them by clicking the tab you want and once the database object is open you can close it without closing other objects, by simply clicking the close button in the upper right corner of the object window. Now close the customers table.

1

7. To move through, search for, or create new records in tables or forms, you can use the record navigator buttons located at the bottom left corner of the object window. This navigation bar shows the current record number and the buttons allow you to go to the first, next and last records as well as to a new blank record. Now as you can see that took us to the last record in the table and displayed the last record number in the navigation bar.

2

The status bar is located just below this bar, at the bottom of the Access window. The contents of the status bar change depending on the view of the current object. In this instance it shows what the currently selected field is for and in other instances it will tell you what view you are in.

8. If you want to change the view for the current object you can use the buttons at the right end of the status bar. The views change depending on the type of database object that is currently active. Because the current object a table, the available views are: datasheet view, pivot table view, pivot charge view and design view. We will try the design view. As you can see the Access working screen changes depending on what you’re doing.

3

 

If you want to learn about the Navigation Pane in Access, click here.

Leave a Reply