SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Oct 2017 My Price 10.00

Please help me with this assignment I have attached the details of it below

MICROSOFTACCESSPROJECTBackground Information:The Board of Directors has accepted your recommendations for the newdesktop and laptop computers to install, and you have been given the authorization to proceed.Tokeep track of the installations you have performed, you will use an Access database. The database willkeep track of each employee, and identify the computer that is assigned to them. Your company has2,000 employees, but for this assignment you only will create a database to track the employees in theHuman Resources department.Requirements:Create a new, blank database and save it as AccessProject-LastName-FirstName.accdb (whereLastName-FirstNameshould be replaced with your last and first name). Pay attention to thelocation where you are saving the file so that you can locate it later.Switch to Design View so that you can begin adding fields to a table. When you are prompted tosave the table, useHR_COMPUTERSas the table name.Delete the default ID field from the table.Add the following fields to the table. Information about what each field will store is listed initalics, and should not be part of the field name:oEmployee ID(A random letter, followed by a 6-digit number uniquely identifying eachemployee)oFirst Name(Employee’s first name)oLast Name(Employee’s last name)oOffice Location(Employee’s office location – identified by a 3- or 4-digit room number)oPhone(Employee’s office telephone number)oEmail Address(Employee’s business e-mail address)oComputer Type(Type of computer – either desktop or laptop)oComputer Serial Number(11-character alphanumeric unique serial number found oncomputer)Set an appropriate data type for each field.Add an appropriate description for each field.Set the Employee ID field as the primary key.Set appropriate field sizes for each field. For example, the Office Location field might have a fieldsize of 3 or 4, because office locations are identified by a 3- or 4-digit room number.Use the information above to help determine the correct field sizes. For fields such as FirstName, Last Name, and Email address, you should decide on an appropriate field size that is nottoo large, but will adequately store your employees’ information.Make the necessary changes so that each field is required, and does not allow any zero lengthstrings (if appropriate).
Background image of page 1

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Oct 2017 09:10 AM My Price 10.00

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

Not Rated(0)