1 What data type is used for the Contact First Name field 2

1.

What data type is used for the Contact First Name field? _______________________________

2.

What data type is used for the Opened field? _________________________________________

3.

What is the Field Size of the City field? _____________________________________________

4.

What is the Field Size of the State Abbrev field? ______________________________________

5.

What is the Field Size for the Number of Employees field? ______________________________

6.

In Field Properties, what is the Default Value for the Number of Employees field? ___________

7.

What is the Company ID for the fifth record (“5 of 21”) in the table? _____________________

8.

What is the Company Name for the 20

th

record (“20 of 21”) in the table?___________________

9.

How many records are in the Companies table? ______________________________________

10. How many records can one form display? ___________________________________________

11. How many records are in the Companies table now? ___________________________________

12. How many fields are in the Companies query? _______________________________________

13. How many records are in the Companies query? _____________________________________

14. How many fields are in the New York Companies query? ______________________________

15. How many records are in the New York Companies query? _____________________________

16. How many Companies printed on your report? _______________________________________

17.

List the database object that allows you to view just one record at a time? ________________________

18. List the database object that allows you to use criteria to display only specific records? ______________

19. List the database object that lets you print your data with customized layouts?

___________________

20. What does the acronym DBMS stand for? ___________________________________________

Solution

20)Answer:

DBMS. Stands for \"Database Management System.\" In short, a DBMS is a database program. Technically speaking, it is a software system that uses a standard method of cataloging, retrieving, and running queries on data