1) Before using a database management system (DBMS), a user should create a(n) ________.
A) data model
B) database
C) identifier
D) attribute
2) Which of the following is the first activity to be performed while creating a database using Microsoft Access?
A) naming the database
B) assigning field names
C) creating field description
D) creating a table
3) Which of the following statements is true of naming a new database in Microsoft Access?
A) A user must type the name of the new database in the blank provided under File Name.
B) A user must select the name of his new database from the drop down list provided next to the File Name.
C) Microsoft Access opens the new database with the default name, database 1.
D) Microsoft Access requires a user to name the new database before selecting a Blank desktop database.
4) Microsoft Access opens a new database by creating a ________.
A) new Word document in the cloud
B) default Microsoft spreadsheet named A1
C) default table named Table
D) shared storage space in the server
5) In Microsoft Access, different attributes are referred to as ________.
A) identifiers
B) keys
C) entities
D) fields
6) In Microsoft Access, the description of fields is used to ________.
A) document the details of each field
B) define rules for how each field should behave
C) define how the fields should behave in case of exceptions
D) specify the data types of the fields
7) Which of the following is a valid entry for field size if the data type of the field is Number?
A) Alphanumeric
B) Special characters
C) Long integer
D) Character
8) Which of the following statements is true about a primary key in Microsoft Access?
A) Only one field in a table can be marked as the primary key.
B) The attribute which is italicized is the primary key.
C) A primary key should have its Required Field property set to No.
D) A foreign key can be used as one of the fields for a primary key.
9) Before using any database management system (DBMS), a user should create a data model based on users' requirements.
10) In Microsoft Access, an underlined attribute is a primary key and an italicized attribute is a foreign key.