USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Queries can only use data from one table at a time. A primary key field from one table appears in a second table.
Detailed explanation-2: -A simple SELECT statement is the most basic way to query multiple tables. You can call more than one table in the FROM clause to combine results from multiple tables.
Detailed explanation-3: -On the Create tab, in the Reports group, click Blank Report. A blank report is displayed in Layout view, and the Field List pane is displayed on the right side of the Access window. In the Field List pane, click the plus sign next to the table or tables containing the fields that you want to see on the report.
Detailed explanation-4: -True, Yes we can create a relationship between two tables of data, based on matching data in each table.