Chapter 4 Working with Tables Worksheet

Sub: Computer
Worksheet
Ch 4 Working with Tables

Student’s Roll No:________ Grade : VIII
Student’s Name:_____________________ Date_________ Sub. Date: ______________
Educator’s Sign: __________________ Parent’s Sign: ________________
A. Fill in the blanks with the correct words.
1. You can enter data in the _______________ view.
2. When you create a blank database, it has ______________ table(s) by

default.
3. A _____________ key refers to one or more columns that uniquely

identifies every row in a table.
4. A _____________ field has a list of values from which a user can choose
the desired value.
5. The maximum length of the Short Text data type is _____________.
6. To remove the primary key, click Primary Key in the _____________

group.
7. The _________________ view is used to enter data into a table.
8. You can set _____________ values for fields in Access tables.
9. The __________ group under the CREATE tab has the option to create a
table in the Design view.
10. A _____________ is a field with a list of values from which a user can
choose the desired value.
11. The ___________ is the top portion of the Table Design screen.
12. The _____________ property is used to define a pattern for the data to be
entered in a field.
13. __________ view is used to enter field names, and their data types, and
descriptions in the table.
B. Write T for the true statement and F for the false one. Correct the false
statement(s).
1. A database can contain more than one table. ______
2. The first field in a new table is the ID field, which is the primary key.
______
3. It is mandatory to enter some information about the field in the Description

column. ______
4. You cannot change the format of a field. ______
5. Once filtering is applied, you cannot remove it. ______
6. Field Size is the minimum size of data stored in Text or Number fields.
______
7. Access adds an ID field automatically to new tables in the Design view.

______
8. There are two ways of setting the primary key in a table in Access. ______
9. The Primary Key button works as a toggle to turn key fields on or off.
______
10. The Input Mask property controls what the user enters in the field. ______
C. Choose the correct option.
1. Which of the following is an invalid field name?

a. StudentName
b. Student.name
c. Student’sName
d. Student_name
2. Which of the following is possible in the Datasheet view?
a. Moving fields
b. Freezing/Unfreezing fields
c. Hiding/Unhiding fields
d. All of these
3. Which property should be set so that it becomes mandatory to enter a value

in the Marks field?
a. Format
b. Caption
c. Required
d. Field Size
4. The Totals button is present in the _________ group of the HOME tab.
a. View
b. Records
c. Find
d. None of these
5. In the Sort & Filter group of the HOME tab, click the _________ Sort
button to clear the sort order from the field.
a. Remove
b. Delete
c. Erase
d. None of these
6. The _________ property specifies how data will be displayed in Access.

a. Rules
b. Format
c. Structure
d. Value
7. The _______ value is automatically filled in the table when you add a new
record to the table.
a. default
b. first
c. primary
d. unary
8. The ___________ data type stores results of a calculation involving fields
from the same table in Access 2013.
a. AutoNumber
b. OLE
c. Computed
d. Calculated
9. What is the default number of characters for the Long Text data field in an
Access table?
a. 3658
b. 4000
c. 54588
d. 65535
10. In the Design view of an Access table, the Field Properties pane appears
on the:
a. Upper half of the screen
b. Lower half of the screen
c. Right side of the screen
d. Left side of the screen
D. Answer the following.
1. Name the two views in Access 2013 that you can use to create a table.
_________________________________________________________________________
_________________________________________________________________________
2. List the various data types available in Access 2013.

_________________________________________________________________________
_________________________________________________________________________
_________________________________________________________________________
3. Mention the rules for naming a field.

_________________________________________________________________________
_________________________________________________________________________
_________________________________________________________________________
_________________________________________________________________________
4. Name the two parts of the Design view.
_________________________________________________________________________
_________________________________________________________________________
E. Write the one word answer for the following.
1. The alternate name given to a field to make the field name more
explanatory.
_________________________________________________________________________
2. The key field that contains unique data for each record.
_________________________________________________________________________
3. This group on the DESIGN tab of Access has the commands to switch
between the two views.
_________________________________________________________________________
4. This field property prevents a field from being blank.

_________________________________________________________________________

Chapter 4 Working with Tables Worksheet

Uploaded by

Copyright:

Available Formats

Chapter 4 Working with Tables Worksheet

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Chapter 4 Working with Tables Worksheet

Uploaded by

Copyright:

Available Formats

Sub: Computer

Ch 4 Working with Tables

A. Fill in the blanks with the correct words.

1. You can enter data in the _______________ view.

2. When you create a blank database, it has ______________ table(s) by

3. A _____________ key refers to one or more columns that uniquely

5. The maximum length of the Short Text data type is _____________.

6. To remove the primary key, click Primary Key in the _____________

7. The _________________ view is used to enter data into a table.

8. You can set _____________ values for fields in Access tables.

1. A database can contain more than one table. ______

3. It is mandatory to enter some information about the field in the Description

4. You cannot change the format of a field. ______

5. Once filtering is applied, you cannot remove it. ______

7. Access adds an ID field automatically to new tables in the Design view.

C. Choose the correct option.

1. Which of the following is an invalid field name?

3. Which property should be set so that it becomes mandatory to enter a value

6. The _________ property specifies how data will be displayed in Access.

D. Answer the following.

2. List the various data types available in Access 2013.

3. Mention the rules for naming a field.

E. Write the one word answer for the following.

4. This field property prevents a field from being blank.

You might also like