Question

1.Create a Database in Access with the information

The database must include:

Database name: Monaco Enterprise  Mark Johnson #87451

Table name: Contacts

Delete the Primary key.

Fields name and data type are (remember to choose the data type):

Field Name	Data Types
Employee Name	Short text
Name	Short text
Last Name	Short Text
Work	Yes/No

2.Go to the “Datasheet View” and enter the data. * Remember to save the table.

3.Move the last name field after the employee name.

4.The (data) records are:

Employee ID: 1235

Rivera, Elena

No Work

Employee ID: 2230

Santiago, Paola

Yes Work

Employee ID: 1080

Cintrón, Carlos

No work

Employee ID: 2654

Santos, Roberto

Yes Work

Employee ID: 1274

Torres, Leonela

Yes Work

Employee ID: 6952

Burgos, Catalina

No Work

Employee ID: 2410

González, Yarelis

No Work

Employee ID: 4239

Pagán, Anahí

Yes Work

Employee ID: 2290

García, Luisa

No Work

Employee ID: 0063

Johnson, Mark

No Work

Answer 1

1)Open MS Access.
2) select create new database and name it Monaco Enterprise Mark Johnson #87451.
it will create Monaco Enterprise Mark Johnson #87451.accdb database.
3)create new table naming Contacts and create all the fields and their datatype.
4)click on primary key symbol it will delete primary key.
5)then save the table.
6)right click on table Contacts and select Datasheet View.
7)click on Last Name column and move to left near at the Employee Name.
8)then enter data on each fields.