35) All relational database management system (DBMS) products can process the ________ query language.
A) SQL
B) PHP
C) DB10
D) HTML
36) Which of the following statements is true about queries in Microsoft Access?
A) Only rows with value matches in all tables are shown by default if more than one table is selected.
B) Only rows having "Number" data type can be used to arrange the results of a query in ascending order.
C) Queries can include fields from only one table.
D) The query design option is present in the Database Tools tab.
37) Microsoft Access can process SQL.
38) Though Microsoft Access can be used to create and process queries, it does not provide a graphical interface for the queries.
39) To create a query in Microsoft Access, one must drag columns out of the required tables into the grid in the lower part of the query definition form.
40) By default, for queries of two or more tables, Microsoft Access shows only those rows that have value matches in both tables.
41) To create a report with data from two or more tables, we must use the ________.
A) Report Wizard
B) Navigation tab
C) Report Design
D) SharePoint lists
42) Which of the following tabs in Microsoft Access is used to generate reports?
A) Create
B) Data
C) Tools
D) Format
43) Which of the following statements is true of reports in Microsoft Access?
A) Reports can be created by using the sections in the Database Tools tab.
B) Report Wizard is required when data from more than one table is to be used.
C) Only the primary key's column width can be increased in a report.
D) A report cannot be used to present the sum or average of values stored in a database.
44) To create a report in Microsoft Access with data from a single table, we must use the Report Wizard.