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)

abie Tools myco: batabase tAccess 200-210- Microsoft Access Home Create External Dat Database ToolsFields Table ab Replace Calibri K Y Descending ,Selection. GeNee Totaling A Cut New Totals eFind Descending Advanced- lussave uyspelling Remoue Sort Toggle Filter All,"X Delete,More copy ew Paste Filter Refresh Format Painter Sort & Filter Records Views All Tables Employees Clipboard Find Text Formatting Employees EmployeeID-LastName FirstName BirthDate HireDate HomePhone- Extension (206) 555-9857 5467 (206) 555-9482 3457 (206) 555-3412 3355 (206) 555-8122 5175 (503)-987-6789 7890 (503) 675-9876 7654 Salary Address 5/1/2002 507 - 20th Ave. Seattle 8/14/2006 908 w. Capital Tacoma 4/1/1992 722 Moss Bay B Kirkland State Zi 98122 98401 98033 98052 97211 97206 city DavolioNancy 2 Fuller 3 Leverling 4 Peacock 5 Buchanan Steve 6 Syama 12/8/1968 2/19/1968 8/30/1963 9/19/1958 4/4/195510/17/2006 14 Garrett Hill Portland 7/2/1978 WA WA WA WA OR OR Employees : Table Andrew anet Margaret $0 $60,000 $0 $50,000 $0 5/3/1993 4110 Old Redm Redmond Michael 10/8/2008 Coventry Hous Portlamd (New abie Tools myco: batabase tAccess 200-210- Microsoft Access Home Create External Dat Database ToolsFields Table ab Replace Calibri K Y Descending ,Selection. GeNee Totaling A Cut New Totals eFind Descending Advanced- lussave uyspelling Remoue Sort Toggle Filter All,"X Delete,More copy ew Paste Filter Refresh Format Painter Sort & Filter Records Views All Tables Employees Clipboard Find Text Formatting Employees EmployeeID-LastName FirstName BirthDate HireDate HomePhone- Extension (206) 555-9857 5467 (206) 555-9482 3457 (206) 555-3412 3355 (206) 555-8122 5175 (503)-987-6789 7890 (503) 675-9876 7654 Salary Address 5/1/2002 507 - 20th Ave. Seattle 8/14/2006 908 w. Capital Tacoma 4/1/1992 722 Moss Bay B Kirkland State Zi 98122 98401 98033 98052 97211 97206 city DavolioNancy 2 Fuller 3 Leverling 4 Peacock 5 Buchanan Steve 6 Syama 12/8/1968 2/19/1968 8/30/1963 9/19/1958 4/4/195510/17/2006 14 Garrett Hill Portland 7/2/1978 WA WA WA WA OR OR Employees : Table Andrew anet Margaret $0 $60,000 $0 $50,000 $0 5/3/1993 4110 Old Redm Redmond Michael 10/8/2008 Coventry Hous Portlamd (New