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 used to ____
A
organize data
B
store data
C
print out data
D
display data on the screen
Explanation: 

Detailed explanation-1: -The table is the primary storage object for data in a relational database. In its simplest form, a table consists of row(s) and column(s), both of which hold the data. A table takes up physical space in a database and can be permanent or temporary.

Detailed explanation-2: -A relational database, or RDB, is a database which uses a relational model of data. Data is organized into tables. Each table has a schema which defines the columns for that table.

Detailed explanation-3: -Tables are used to organize data that is too detailed or complicated to be described adequately in the text, allowing the reader to quickly see the results. They can be used to highlight trends or patterns in the data and to make a manuscript more readable by removing numeric data from the text.

Detailed explanation-4: -A data store uses a relational database management system (RDBMS), working through JDBC, to store data as rows in a set of tables. This data is important when you are backing up or restoring a data store. The following table summarizes the purpose of each data store table.

Detailed explanation-5: -Within an Access database file, you can use: Tables to store your data. Queries to find and retrieve just the data that you want. Forms to view, add, and update data in tables.

There is 1 question to complete.