MS Access - Part 1
Microsoft® Access 2010 Test
Computer Application I
Chapters 1–3 (Part #1)
I agree to work independent and without help or assisting my fellow students. If I am caught cheating, I will accept the punishment deemed appropriate by Professor Sims and guidelines set forth by the Business Technology Department which includes but not limited to, a zero on the test for both parties.
_________________________________
______________________________________
Print Name
Sign Name
1. Raw data that has been organized so as to become useful is also known as
A) normalized
B) information.
C) facts.
D) a query. data. 2. Each table row contains all the categories of data pertaining to one entity and is called a
A) field.
B) database.
C) record.
D) query.
3. In Microsoft Access, all data is stored in one or more
A) macros.
B) forms.
C) tables.
D) queries.
4. The Access view that displays the table data in columns and rows is called
A) Datasheet
B) Data Object
C) Database
D) Design view. view. view. view. 5. A flat database
A) is not related to any other collection of data. B) must have less than five fields. 6. An Access record is saved when you
A) save the table in which it was created.
C) close the database.
7. The most common database objects are
A) tables, queries, and macros.
C) macros, tables, and forms.
8. The table Design view shows
A) the number of records in the table.
C) the structure of the table.
C) has no added data. D) cannot have a primary key.
B) press Save on the File tab on the
Ribbon.
D) move to the next record.
B) tables, forms, and reports.
D) tables, forms, and relationships.
B) the formatting applied to the table.
D) the relationships established for the table. 9. Which of the following is a good candidate for a primary key?
A) A car model in a Motor Vehicle Department database
B) A postal code in an address database
C) A student ID in a college registration
Computer Application I
Chapters 1–3 (Part #1)
I agree to work independent and without help or assisting my fellow students. If I am caught cheating, I will accept the punishment deemed appropriate by Professor Sims and guidelines set forth by the Business Technology Department which includes but not limited to, a zero on the test for both parties.
_________________________________
______________________________________
Print Name
Sign Name
1. Raw data that has been organized so as to become useful is also known as
A) normalized
B) information.
C) facts.
D) a query. data. 2. Each table row contains all the categories of data pertaining to one entity and is called a
A) field.
B) database.
C) record.
D) query.
3. In Microsoft Access, all data is stored in one or more
A) macros.
B) forms.
C) tables.
D) queries.
4. The Access view that displays the table data in columns and rows is called
A) Datasheet
B) Data Object
C) Database
D) Design view. view. view. view. 5. A flat database
A) is not related to any other collection of data. B) must have less than five fields. 6. An Access record is saved when you
A) save the table in which it was created.
C) close the database.
7. The most common database objects are
A) tables, queries, and macros.
C) macros, tables, and forms.
8. The table Design view shows
A) the number of records in the table.
C) the structure of the table.
C) has no added data. D) cannot have a primary key.
B) press Save on the File tab on the
Ribbon.
D) move to the next record.
B) tables, forms, and reports.
D) tables, forms, and relationships.
B) the formatting applied to the table.
D) the relationships established for the table. 9. Which of the following is a good candidate for a primary key?
A) A car model in a Motor Vehicle Department database
B) A postal code in an address database
C) A student ID in a college registration