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
MS Access Modules
Modules provide the opportunity to you to use the power of Visual BASIC
language in your MS Access database. Later in the book we will teach you
how to create a auto_login modules which will help you to sign-in to
your Oracle ODBC DSN (Data Source Name) automatically the time you open
the MS Access database.
To create a module the first step would be to click the “Create” command
and then clicking/expanding “Modules” as shown in Figure 1-11. Whereas
if you want to edit the already existing module, the first step would be
to expand the Modules object under the “All Access Objects” and right
click on the selected macro. Finally click the “Design View” command
from the popped-up window.
Figure 1-11: Create new module using the Module design
view under the Create command or edit the exiting macro with right click
and then clicking “Design View” from popped-up menu.
________________________________________
MS Access Forms
Forms provide the interface for data entry to the database. End-users
are usually unaware of MS Access tables’ structure and inter-table
relationships; they can use the forms to perform data entry operations
to the background tables.
All different Form design options are available under the “Create”
command on the menu bar as shown in Figure 1-12. In order to edit a
already existing Form, the first step would be to expand the “Forms”
object under the “All Access Objects” and right click the selected Form.
Finally click the “Design View” command from the popped-up window as
shown in Figure 1-12.
A detail discussion on forms and how to design forms within MS Access
environment will follow later in the book.
Figure 1-12: All different Form design options are
available under “Create” command. Moreover, editing exiting Form
requires a right click and then clicking “Design View” from popped-up
window.
________________________________________
Chapter 1: Overview
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: