MS Access 2007 Step By Step - Asim Abbasi

CH1: Overview | CH2:  MS Access Local & Linked Tables | CH3:  MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions

Chapter 1: Overview

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

 

7 Areas of Action

Once you run the MS Access 2007 software residing under <Start> and <Programs> menu after installation, you will notice that the software has seven objects or seven areas of operation.

Figure 1-1: Accessing MS Access under Windows <Start> menu.
________________________________________

 

In other words you can say that MS Access has the ability to do seven major types of jobs. Out of seven we would be discussing following six objects one by one. These six important areas of action are as follows.

Tables
Queries
Reports
Macros
Modules
Forms

Figure 1-2: All Access Objects are available in the left pane.
________________________________________

 

Once you expand the ‘Tables’ object under the “All Access Objects” group as shown, the MS Access GUI will show you the list of tables in your database (as shown in Figure 1-3 and Figure 1-4), both local and linked tables provided if you have any. The word GUI stands for Graphical User Interface. GUI is the software interface using which users can interact. It includes everything you see once the software is in front of you after running it though the <Start>, <Programs> menu. All the buttons, menu bar (Home, Create, External Data, etc.), the ribbon (the area with the icon/pictures under the menu bar) etc. you see on the software application and as shown in the Figure 1-2, are parts of MS Access GUI.


Chapter 1: Overview

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

CH1: Overview | CH2:  MS Access Local & Linked Tables | CH3:  MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions

Share with others: