|
| |
In class assignment for Week 11: 3/22/01
To be done after Lab Tutorials 9 and 15 are done.
-
Open
the Employees3.mdb database.
-
Create
a custom query based on the employees table with the following fields:
EmployeeID,
Expression Name: FirstName &
“ “ & LastName
DateHired
Salary
-
Save
it as qryExportSalaries
-
Run
it
-
Export
the query as a text file named EmployeeSals.txt
-
Make
sure you use commas to delimit the fields
-
Put
a check in the box to put the field names on the first row.
-
Try
to import it as a text file. Rename
Expr1 to EmpName
-
Assign
the Key to EmpoyeeID
Results:
-
Can
you see any results? Why or why
not?
-
Open
the text file you exported in Notepad.
What do you see?
-
What
are the field delimiters, or are there any?
-
What
delimits the records?
-
Export
the query again as a Dbase III (dbf) file.
-
Import
this table into your access database.
-
In
design view rename the field Expr1 to EmpName
-
Rename
it tblDBFSalImport.
-
Create
a simple report based on the Imported DBF file.
-
Make
the report sort by Salary.
-
Change
the format of the salary field to currency.
-
Use
a tabular style.
-
Save
it as rptDBFSalaries
-
Make
the title on the report “Imported DBF Salaries by YOUR NAME”, where YOUR
NAME is your name.
-
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.
-
Print
the report and hand it in with this completed sheet.
-
Which
import/export was the best?
-
Explain
your results.
|
