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)