USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Determine what information to include
|
|
Discuss the database with users
|
|
Gather the information
|
|
Input data
|
Detailed explanation-1: -In the Open dialog box, select the database that you want to open, and then click Open. On the Create tab, in the Tables group, click Table. A new table is inserted in the database and the table opens in Datasheet view.
Detailed explanation-2: -A schema describes the logical structure of a database. There are three levels of schemas.
Detailed explanation-3: -Relational Database Model. A Relational Database management system refers to the various software systems used to maintain Relational Databases (RDBMS). The data in this type of Database Model is organized in two-dimensional tables with rows and columns, and the relationship is maintained by storing a common field.
Detailed explanation-4: -On the Design tab, in the Query Type group, click Make Table. The Make Table dialog box appears. In the Table Name box, enter a name for the new table.