Office 2010 - Access

Lesson 1: Introduction to Microsoft Access

1/76 Lessons 

Open Access 2010

When we open “Access” 2010, we are in the “Backstage” window.  In this window, we can create a new empty database (1), a database based on a “Template” (2), or open a recently opened database (3).

Start by creating a new empty database and give it a name (a).


You can start a database using a “Template” by double-clicking on “Sample Template” in the middle column.


Under the “Recent” tab found in the middle column, a list of recently opened databases will be displayed. The list of recently opened databases can contain upto 50 files. By clicking on the “pin-icon” next to a file, you can pin the file to the list.


When we create a new database or open an existing database, it opens the “Application Window” which displayes an empty database or our selected database.  This “Application Window” is divided into three parts. At the top of the “Application Window”, we find the “Quick Access” toolbar and the “Ribbon”.  On the left side of the “Application Window”, we have the “Navigation Panel”, which shows you all your previous items.  If you open a new blank database, this “Navigation Panel” will be empty.

In the “Navagation Panel” you will be able to view objects.  “Tables”, “Queries”, “Forms”, “Reports”, “Macros”, and “Modules” are objects.  When you open an object, it will be displayed 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 objects that are open.

To open an object, click the downward pointing arrow next to the object type, and double-click the object in the list.  Another way to open an object is to right-click the object and choose “Open” in the pop-up menu .

To close an open object, right-click the tab for this object and select “Close” from the pop-up menu.   Another way to close an open object is to select the tab for the object and click the “X” button on the far right (or left with a Mac).



You've completed Lesson 1