Lab 9 Homework

Home Up Lab 2 Homework Lab 3 Homework Lab 4 Homework Lab 5 Homework Lab 6 Homework Lab 7 Homework Lab 8 Homework Lab 9 Homework Lab 10 Homework

In class assignment for Week 11: 3/22/01  

To be done after Lab Tutorials 9 and 15 are done.

  1. Open the Employees3.mdb database.

  2. Create a custom query based on the employees table with the following fields:

EmployeeID,

Expression Name: FirstName & “ “ & LastName

DateHired

Salary

  1. Save it as qryExportSalaries

  2. Run it

  3. Export the query as a text file named EmployeeSals.txt 

  4. Make sure you use commas to delimit the fields

  5. Put a check in the box to put the field names on the first row.

  6. Try to import it as a text file.  Rename Expr1 to EmpName

  7. Assign the Key to EmpoyeeID

Results:

  1. Can you see any results?  Why or why not?

 

  1. Open the text file you exported in Notepad.  What do you see?

 

  1. What are the field delimiters, or are there any?

 

  1. What delimits the records?

 

  1. Export the query again as a Dbase III (dbf) file.

  2. Import this table into your access database. 

  3. In design view rename the field Expr1 to EmpName

  4. Rename it tblDBFSalImport.

  5. Create a simple report based on the Imported DBF file.

  6. Make the report sort by Salary.

  7. Change the format of the salary field to currency.

  8. Use a tabular style.

  9. Save it as rptDBFSalaries

  10. Make the title on the report “Imported DBF Salaries by YOUR NAME”, where YOUR NAME is your name.

  11. Preview the report to make sure the fields are properly formatted and Column Headings all show. If not go into design view and modify them.

  12. Print the report and hand it in with this completed sheet.

  1. Which import/export was the best?

  2. Explain your results.

 

Home Lab 2 Homework Lab 3 Homework Lab 4 Homework Lab 5 Homework Lab 6 Homework Lab 7 Homework Lab 8 Homework Lab 9 Homework Lab 10 Homework