FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A query for a report can come from multiple tables.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

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.

There is 1 question to complete.
Previous
Next