background image
92
ACC
4
Employee Database
15. Resavethetable.
16. Carefullyproofreadyourworkforaccuracyandformat.
17. PrintacopyoftheEMPLOYEEStableifrequiredbyyourinstructor.
18. CreateaNEWquerythatshowstheemployeeswithfilingstatusof"Married."
19. Showonlytheemployeesocialsecuritynumberandlastname.
20. SavethequeryasMARRIEDEMPLOYEES.
21. PrinttheMARRIEDEMPLOYEESqueryifrequiredbyyourinstructor.
22. UsingtheMARRIEDEMPLOYEESquery,createaNEWreport.
23. Useallavailablefields,andsortbylastnameinascendingorder.
24. Titlethereport"EMPLOYEESWITHMARRIEDFILINGSTATUS."
25. Printacopyofthereportifrequiredbyyourinstructor.
For Evaluation Purposes Only