Database System

note!Answer: A) Sub form sub report
The Subform/Subreport tool in the toolbox displays data from a related table inside a form or report.

note!Answer: A) Transparent
In Access, the BorderStyle property set to Transparent makes a control's border invisible.

note!Answer: A) Table
Each table name must be unique within a database so that it can be identified.

note!Answer: A) datasheet view
Datasheet view lets you create a table by typing data directly into its rows and columns.

note!Answer: A) primary key
A primary key is a field whose value uniquely identifies each record in a table.

note!Answer: A) text
The Text data type stores letters, numbers, and special symbols.

note!Answer: A) memo
The Memo data type stores up to 65,535 characters, while Text is limited to 255.

note!Answer: B) Select
A Select query is the most common query type. It retrieves records from one or more tables and displays them.

note!Answer: C) Parameter
A Parameter query displays its own dialog box asking the user for criteria when it runs.

note!Answer: C) crosstab
A crosstab query summarizes and restructures data, calculating sums, counts, or averages in a grid.

note!Answer: C) expression
An expression combines operators, values, and fields to produce a result.

note!Answer: A) Cross tab Queries
Crosstab queries summarize and analyze data in a row-and-column format, which makes them best for analysis.

note!Answer: C) Oracle
Oracle is a database management system. MS Word, MS Excel, and Lotus 1-2-3 are not.

note!Answer: B) Make Table Query
A Make Table query selects data from one or more tables and creates a new table from the results.

note!Answer: A) Bound Control
A bound control is linked to a field in a table or query, so it displays that data.

note!Answer: C) Summary Section
Access report sections are Report Header, Page Header, Detail, Page Footer and Report Footer. There is no Summary section.

note!Answer: D) None of the above
Access can import dBase files, Excel spreadsheets and comma-delimited text files, so none of these is excluded.

note!Answer: D) All Of Above
A table can be viewed in Datasheet, Design, PivotTable and PivotChart views.

note!Answer: D) Lookup Wizard
The Lookup Wizard creates a combo box field that gives a drop-down list of values.

note!Answer: A) Database Window
The Database Window is the central control panel listing all objects in an Access database.