Database System

note!Answer: D) All of the above
Access tables can be created in Design view, with the Table Wizard, or by entering data directly in Datasheet view.

note!Answer: D) Space bar
Pressing the Space bar toggles a focused check box on or off.

note!Answer: A) Field
A field holds a single data item, while a record is a complete set of fields.

note!Answer: C) Both of the above
VBA has standard modules and class modules, so both types apply.

note!Answer: B) Module
A module is a named unit that groups declarations, statements and procedures together.

note!Answer: A) Relation
In relational database theory, a table is called a relation.

note!Answer: A) Data types
The data type of a field determines what kind of data it can store.

note!Answer: B) F11
In Microsoft Access, F11 switches to the Database window from any other window.

note!Answer: D) Table
A table is the basic database object that stores records in rows and columns.

note!Answer: C) Foreign key
A foreign key is a field in one table that refers to the primary key of another table, creating the relationship between them.

note!Answer: A) One
Microsoft Access allows only one database file to be open at a time.

note!Answer: A) Only one
A crosstab query in Access takes its data from a single source, which is one table or one query.

note!Answer: B) Only one
An AutoForm is based on a single table or query, so only one can be included.

note!Answer: C) Query
A query is a request to retrieve specific information from one or more tables.

note!Answer: D) All of the above
Text box, list box and combo box are all display (bound or unbound) controls used on forms.

note!Answer: B) F5
F5 is the standard shortcut key for Refresh in Access and most Windows applications.

note!Answer: A) DR E.F CODD.1970
Dr. E. F. Codd proposed the relational model for databases in 1970.

note!Answer: C) field
In a database, each row is a record and each column is a field.

note!Answer: A) Data mining
Data mining analyzes large datasets to discover patterns and trends, such as customer buying habits.

note!Answer: D) All of the above
Traditional file systems suffer from data redundancy, difficulty in updating, and strong program-data dependence.