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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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...

Q:

What data type is used for the Contact First Name field? q , What data type is used for the Opened field?

Q:

This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of an array of objects as a class data...

Q:

Hey guys sorry for the picture quality but it was the only way to give you the information needed. Need help, thank you! Everything below is all that was given to us for the assignment In this...

Q:

IFSM 461: Systems Analysis and Design Precision Electronic Parts, Inc. Case Study Introduction This case study will be used for a series of staged assignments. It should be thoroughly read and...

Q:

IFSM 461: Systems Analysis and Design Precision Electronic Parts, Inc. Case Study Introduction This case study will be used for a series of staged assignments. It should be thoroughly read and...

Q:

Stage 1: Preliminary Investigation Report Before you begin this assignment, be sure you have read the Case Study and all assignments for this class, especially Stage 4: Final System Report. Purpose...

Q:

Please explain and show me how to do this on Access. Thank you! I posted this question before, and the person who answered did not answer the full question and did not answer it correctly, I have...

Q:

IFSM 461: Systems Analysis and Design Precision Electronic Parts, Inc. Case Study Introduction This case study will be used for a series of staged assignments. It should be thoroughly read and...

Q:

Your assigned task is to write the code for the "insert_name_list(...)" subprogram, whose prototype is shown below and is defined in the name_list.h header file. void insert_name_list(sNAME_LIST...

Q:

In a Gallup poll of 1,018 adults in the United States, it was found that 22% smoked cigarettes in the past week. Identify the sample, the population, the sample statistics and the population...

Q:

Find the indicated vector. 5 Let u =(-4,-8), v = (6,2). Find 13 u 12 13 V.

Q:

Journalize transaction: July 3 purchased cleaning supplies for $830 on account

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

4. Design a management development program for first-level supervisors in a mass-market retail company. What courses and experiences do they need?

Q:

LO1 Identify why performance management is necessary.

Q:

3. How does the overtone of military-style training impact Walmarts employment brand? Would this appeal to particular segments of the labor force? How might it impact the companys ability to recruit...