Transcript Document
Selected Topics in Management
Information Systems
[MOIS470]
Fall 2004
Nahed Amin
MS Access
(Control Extensions)
1
Introduction
Once you have created your database
tables, reports, forms, queries, you
need to create controls for the database
to make it easy for the end-user to
operate
Making the database easy to use
prevents the user from doing redundant
steps that could be performed correctly
2
Introduction
The developer can exert more control on
the database by:
Creating a switchboard
Setting startup options
Setting a database password
3
Creating a Switchboard
A switchboard is a special Access form
that provides a simple, yet effective
navigation system to your database
Switchboards can open forms and
reports, run macros, and even launch
other applications
To navigate with the switchboard, the
user simply clicks a button adjacent to
the desired item on the switchboard
4
Creating a Switchboard
Items on the switchboard are modified in the
switchboard Manager dialog box. This dialog box
allows you to add, edit, delete, or change the
order of the items in the selected switchboard
Access allows you to create multiple switchboards
within a single database. Multiple switchboards
are used as sub-switchboards that contain specific
information under a broad information
topic
5
Setting Startup Options
Access provides a variety of methods to
customize your database, you can:
Define the name of your database application
and have it appear in the title bar
Use a custom icon for your database
application
Display or hide parts of the database window
Display a certain form or a switchboard to be the
startup screen (to prevent the startup screen to be
displayed, hold the Shift key while opening the
database)
6
Setting a Database Password
The most simple method you can use to
control data access to your database is a
database password. Database passwords
prevent unwanted users from viewing or
manipulating your database
When using a database password, all
database users must enter the password
before they are allowed to open the
database
7
Setting a Database Password
Database passwords protect only the
initial entry into the database. Once the
database is open, the database password
provides no further protection
To implement database security
measures for each database user, you
must use Access’s user-level security
options
8