ACCESS 2019 DATABASE ASSIGNMENT

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 20) 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?

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