Page 26 - Code & Click - 8

WORKING WITH DATABASES

Creating a New Database
You can create a new database by building your own tables, forms, reports, and other database
objects in a blank database.
To create a new blank database:
1. Click the File tab.
2. Select the New option. 2
3. Click the Blank database button.

4. Specify the name and location
for the database and click the
4 Create button. 3
Access creates a new database with an empty table named
Table1.

Opening an Existing Database
You can open a database that you have created and saved earlier to
view, add, or edit the existing data in it.
To open an existing database:
1. Click the File tab. 2
The Backstage view opens.

2. Select the Open option.

3. Click the Browse option. 3
The Open dialog box opens.

4. Select the database you want to open and click the
4 Open button.

WORKING WITH TABLES
Tables are the basic building blocks of a database. They hold all the information or data in the
database. A database can contain one or more tables. All tables comprise of fields and records.

Field
A Field is the smallest unit of data in a database. It stores a single value for an entity. For example, a
table for sales data may contain the fields – salesman number, name, workzone, sales, and commission.

Record
A Record contains data about one instance of an entity. Each record is a collection of values for the
various fields in the table. For example, a record for a salesman with the above mentioned fields is:
Fields

SalesmanNum Name Zone Sales Commission

Record 2301 Jatin North 2356245 25000

24