Office 2007 - Access

Lesson 1: Introduction to Access

1/72 Lessons 

Open “Access” 2007

When we open Access 2007, “Getting Started with Microsoft Access” window is displayed.
In this window, we can create a “Blank database”, a database based on a “Template” or open a recently opened database.

When we create a “Blank database” or open an existing database, the application window displays our database.

This application window is divided into three parts.
At the top, we find the “Office” button, the “Quick Access” toolbar and “Ribbon”.
On the left side of the application window, we have the “Navigation Panel”.
In the “Navigation Pane”, we have all our previously created items.
Objects are “Tables”, “Queries”, “Forms”, “Reports”, “Macros” and “Modules”.
When you open a new blank database, this “Navigation Panel” is obviously empty.

When we open an object, it will be opened on the right side of the “Navigation Panel”.
Any object that is opened has its tab at the top. This makes it easy to navigate between multiple open objects.
To open an object, click the downward pointing arrow next to the object type and double-click the object in the list.
A second way is to right-click the object and in the pop-up menu, choose “Open”.

To close an open object, right-click the tab for this object, and select “Close” from the pop-up menu.
A second way to close an open object is to select the tab for the object and click the X button on the far right.


Working with objects

Sometimes, the name “Table” and “Database” are confused but, when we work with “Access” and we have a database and then we have “Tables”, “Queries”, “Forms” , “Reports”, “Macros” and “Modules” in a database.

A table on the other hand is a collection of data about a particular subject, such as customers or suppliers.

A table is divided into columns and rows.
The data from an entire row, such as name, address, and address, is called a “Record”.

In “Access”, you can open different objects from a database but, you can open only one database.

When we open a second database, the first will be closed.


If you can not find the different object types in your “Navigation Panel”, click the downward pointing arrow next to the “All Access Objects” and select “Object Type” in the drop-down menu.

Repeat this again but now, click “All Access Objects” in the drop-down menu to make sure that all objects are displayed.
You only need to do the later if, this option is not checked in the drop-down list.

If no objects of a type are made, it will not prevent this type of object to be displayed in the “Navigation Panel”.

You've completed Lesson 1