Chapter 18
MS ACCESS 2000
18.1 CREATING A DATABASE IN MS ACCESS 2000
W
hen starting MS Access a dialogue box with three option buttons appears.
FIGURE 18.1
319
320 SOF T WARE ENGINEERING AND TESTING
Blank Access Database is used to create a new database by defining field
name, data type, and field size.
Access database wizard is used to cr
eate a database using a wizard.
Open an existing file is used to open an alr
eady created database.
18.1.1 Access Database Wizard
To create the database with a wizard, first select the Database wizard option, then
click the OK button. You will see the screen given below:
FIGURE 18.2
Select any type of database and click the OK button. You will see a screen called
File New Database. Enter the filename in the box and click the Create button. Now
follow the instructions and options given and click the Next button and lastly click
the Finish button.
After gathering the information MS Access creates a database with the extension
.mdb. The database contains different tables, forms, queries, and reports.
MS ACCESS 2000 321
FIGURE 18.3
18.1.2 Blank Access Database
This option is used to create a customized database. To create a new database,
select this option and click the OK button. On the next screen you will see a File
New Database window. Give any valid filename in the File Name box and click
the Create button to save the database file with the .mdb extension. You can select
any path to save your database file by selecting the Save in box (see Figure 7.3).
The next window that appears is given below:
FIGURE 18.4
322 SOF T WARE ENGINEERING AND TESTING
On the left side of the window, seven types of objects are given. Select the first
object, i.e., Table (by default it is already selected) and click the New button. The
options that come with the New Table dialogue box are (see Figure 7.4):
Datasheet V
iew: You can create a table by entering the data. Twenty fields
are given in the table from field1 to field20. The data type of all the fields
are by default text, but once you save the data, the data type of the fields
are changed according to the data entered. You can rename the field by
double-clicking the field name.
T
able Wizard: Creates a table using a wizard.
Design V
iew: A customized table can be created using Design View.
Import T
able: A table can be imported from another database using this
option.
Link T
able: The table can be linked with another database and you can
work with these options.
FIGURE 18.5
Select the Create table in the Design View option. As you select this option, on
the tool bar the Open and Design buttons get enabled. Now click the Open button
on the tool bar that gives a window to design the table.
MS ACCESS 2000 323
FIGURE 18.6
Give a field name in the Field Name column and select a data type from the
Data Type column. A table with the following fields is shown in Figure 18.7.
Field Name Data Type Field Size
Name Text 50
Age Number 3
Date_of _birth Date 8
Monthly_income Currency 8
FIGURE 18.7

Get Software Engineering and Testing now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.