USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format the data.
|
|
|
enter data.
|
|
|
query the data.
|
|
|
create forms.
|
Detailed explanation-1: -The table structure is created in Design View of a table and to enter data we use Datasheet View.
Detailed explanation-2: -Answer: Table structure is formed before creating a table.
Detailed explanation-3: -Explanation: The structure of a table can be viewed using the DESCRIBE TABLE NAME command.-Provides a description of the specified table or view. For a list of tables in the current schema, use the Show Tables command.
Detailed explanation-4: -It consists of columns and rows. In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.
Detailed explanation-5: -Access allows you to display many of its objects in multiple viewing modes. Datasheet view displays the data in your tables, queries, forms, and reports.