Question
1. What data type is used for the Contact First Name field? _______________________________ 2. What data type is used for the Opened field? _________________________________________ 3.
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? ___________________________________________
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started