Back to Course

JSS3: COMPUTER STUDIES - 1ST TERM

0% Complete
0/0 Steps
  1. Computer Career Oppurtunities | Week 1
    5Topics
    |
    1 Quiz
  2. Computer Viruses I | Week 2
    7Topics
    |
    1 Quiz
  3. Computer Viruses II | Week 3
    7Topics
    |
    1 Quiz
  4. Introduction To The Internet | Week 4
    4Topics
    |
    1 Quiz
  5. Internet Terminologies | Week 5
    4Topics
    |
    1 Quiz
  6. The Concept of Digital Divide | Week 6
    5Topics
    |
    1 Quiz
  7. Database Concept, Definition And Terminologies | Week 7
    4Topics
    |
    1 Quiz
  8. Database II | Week 8
    4Topics
    |
    1 Quiz
  9. Database III | Week 9
    13Topics
    |
    1 Quiz
Lesson Progress
0% Complete

What is a datasheet?

In Access, data is stored in tables. A datasheet displays the information stored in a table in Columns and Rows. The columns are called fields and the rows are called records. You can use a datasheet to create a table, enter data, retrieve data, and perform other tasks.

Tables in Ms-Access

Tables are the foundation of an Access database. Access stores data in tables. From now on, you will learn how to create a table, add fields to a table, assign data types to fields, and set field properties.

After Access creates a blank database, it opens in Datasheet view and makes available the tools you need to create a table. Datasheet view displays a table as a set of columns and rows. When you view a blank database for the first time in the Datasheet view, you see a column named ID. This Column is by default the primary key field. A primary key is a field or combination of fields that uniquely identify each record in a table. No two records in a table should have the same values In every field. For example, the following should not occur in a table.

LAST NAMEFIRST NAMECITYSTATE
FemiBalogunIBADANOYO
FemiBalogunIBADANOYO

In the real world, it is possible to have two people, from the same city, with the same first and last name. In cases like this, you can use the ID field as the primary key field and use it to make each record unique. The ID field has a data type of Auto Number; as a result, Access automatically creates a unique number for each record in the database. The resulting table will look like the one shown below.

IDLASTNAMEFIRSTNAMECITY
1FemiBalogunIBADAN
2FemiBalogunIBADAN

To Add Fields To A Table

Screen Shot 2021 03 17 at 7.03.57 PM

1. Click the Add New Field column label.

2. Activate the Datasheet tab.

3. Click Rename in the Fields & Columns group.

4. Type the field name.

5. Press Enter.

Access creates the field.

6. Type the next field name.

Access creates the field.

Continue until you have created all of the fields in your table.

7. Press Enter without entering a field name to end your entries.

Or

1. Right-click the Add New Field column label. A menu appears.

2. Click Rename Column.

3. Type the field name.

4. Press Enter.

Access creates the field.

5. Type the next field name.

Access creates the field.

Continue until you have created all of the fields in your table.

back-to-top
error: