Page 36 - Computer - 8

Creating a New Database from Blank Database

Instead of using a template, 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

The Backstage view opens.
2. Select the New option.

3. Click the Blank database button.
A dialog box opens. 3
4. Specify the name and location for the database and click the
4 Create button.

Access creates a new blank 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: 2
1. Click the File tab.
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 Open
4 button.

The selected database is opened in the Access window.

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

34