FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Tables are set up to contain columns and rows of information. In a database table, the columns are called ____
A
Cell
B
Field
C
Column
D
Record
Explanation: 

Detailed explanation-1: -The correct answer is Field. The columns in the tables are called fields. A field contains a specific piece of information within a record.

Detailed explanation-2: -A row, or record, is also known as a tuple. The columns in a table is a field and is also referred to as an attribute. You can also think of it this way: an attribute is used to define the record and a record contains a set of attributes.

Detailed explanation-3: -Fields are the components that provide structure for a table. You can’t have a table without fields. For instance, you can create an empty table that has fields defined but no rows (records). In databases, fields are used to maintain relationships between tables.

Detailed explanation-4: -At the top of each column in a table, a column designation/head is given to explain the figures of the column. This column heading is known as ‘caption’.

There is 1 question to complete.