Part 2: Work with a database Using the myco database in the Drop Box (myco.accdb

Question

Part 2: Work with a database

Using the myco database in the Drop Box
(myco.accdb is for Access users, myco.odb is for Open Office users)

Download it to the Assign subfolder

-Add 2 records to the Employee table

-Add a new field called Job Title to the Employee table
and give each employee a title

-Add a query that lists First Name, Last Name and Salary
of all Salaried employees (Salary > 0)  

-Add a report that lists First Name, Last Name and Hire Date of all Employees
sorted by descending Hire Date (the most recent first)

myco : Uatabase (Access 200/-20 -Microsoft Access Home Creat Extemal Daks Database Tools Fields Table New Totals Replace Ascending Selection . Descending Advanced . Remove Sort Y Toggle Fite a copy save Spelling view Paste Format Painter Filter ReneshXbett-BMore, SeletB 1 u Views All Tables EmployeesEmployeelD LastName FirstNameBirthDate HireDate A Cl pboard Sort&Filter; Re cords Find Text Formatting oc Address City State ZipHomePhone Extensiorn Employees:Table (206) 555-9857 5467 (206) 555-9482 3457 (206) 555-3412 3355 (206) 555-8122 5175 (503)-987-6789 7890 (503) 675-9876 7654 Nancy 2 Fuller 3 Leverling 4 Peacock 5 Buchanan 6 Syama 12/8/1968 2/19/1968 8/30/1963 9/19/1958 5/1/2002 507-20th Ave. Seattle 4/1/1992 722 Moss Bay B Kirkland 4/1955 10/17/2006 14 Garrett Hill Portland S0 $60,000 S0 50,000 S0 8/14/2006 908 w.C WA WA WA OR 10/8/2008 Coventry Hous Portlad OR 98401 98033 98052 97211 97206 Andrew 5/3/1993 4110 Old Redm Redmond Steve /2/1978 (New)

Explanation / Answer

1. Adding 2 records to table

insert into Employee values (7, "EmployeeFirstName", "EmployeeLastName", 2/3/1978, 3/4/1998, "Address" , "City", "State", 01123, 23948, 3423, "$45000");

2. Adding a new Field and assign value to the new filed

alter table Employee add JobTitle CHAR (20);

update Employee set JobTitle="Analyst" where EmployeeId not null;

3. Listing employees names whose salary > 0

select FirstName, LastName, Salary from Employee where Salary>0;

4. Order by HireDate descending

select FirstName, LastName, HireDate from Employee

Order by HireDate desc;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.