Page 30 - ModularV1.1 _c8_flipbook
P. 30
04 WORKING WITH
TABLES IN MS ACCESS
Your Aim
to learn about:
l Creating a New Table l Handling Columns in a Table
l Handling Records in a Table
As you know, a table is used to store data in a database. It contains the data in the form of rows
and columns. MS Access 2010 allows us to add a maximum of 256 columns and unlimited rows
in a table. In the previous chapter, you have learnt about database and table. In this chapter, you
will learn how to perform different types of operations on a table. You will also learn how to work
with records.
CREATING A NEW TABLE
Table can be created in two ways:
Creating tables using Design View. Creating tables using Datasheet View.
Let us create a table using Design view.
Creating a Table Using Design View
In this view, you can define fields that are to be included in the table. You can simultaneously
define properties of these fields also.
To create a table in Design view, follow these steps:
Step 1 Click on the Table command from the Tables group under
the Create tab. This will create a new table as Table1 in the
database.
Creating a Table
Step 2 Click on the View command from the Views group under the
Home tab. A drop-down list opens.
Step 3 Click on the Design View option. This will open the Save As dialog
box.
Selecting Design View
28 Modular (Ver. 1.1)-VIII

