Part B: In Microsoft Access, create and populate the following three database tables, including foreign keys, using SQL. Save all queries in the database. Assume the ID for each table is the primary key. Assume all fields are required. Assume all fields that contain only numbers are numeric type. Save the database as Personnel.accdb. Once the tables have been created, encrypt the database with a password. Be sure the password is strong. It should be at least 16 characters in length, and contain at least one of each of the following: upper-case letters, lower-case letters, numbers, and special characters. Submit the Personnel.accdb file. Submit the password in the comments section of the assignment submission area.

Please see attachment.  I would like to have the actual file for Microsoft Access

 

Part B: In Microsoft Access, create and populate the following three database tables,including foreign keys, using SQL. Save all queries in the database. Assume the ID foreach table is the primary key. Assume all Felds are required. Assume all Felds thatcontain only numbers are numeric type. Save the database as Personnel.accdb. Oncethe tables have been created, encrypt the database with a password. Be sure thepassword is strong. It should be at least 16 characters in length, and contain at leastone of each of the following: upper-case letters, lower-case letters, numbers, and specialcharacters. Submit the Personnel.accdb Fle. Submit the password in the commentssection of the assignment submission area.EmployeesManagersDepartments

• 1496712579-Part B.docx

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 01:06 AM My Price 9.00

-----------

Attachments

file 1496712582-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer