Print Name ___________________________
Signature ____________________________
Print Name ___________________________
Signature ____________________________
Search Employee Screen Lab
Individual/Team (1-2 Persons) Assignment
10 Points
Set Netscape Margins
[ Left = 1; Right = .2; Top = .6; Bottom =
.6; Select Document Title, Location, Page Number, Page Total Black
Text l]
1] Either use your Employee Screen Lab from the previous
assignment or create a new one. If you are working as a team, select the
best designed screen from the earlier assignment. You may download and
decompress the Employee files into directory A:\Employee {You may do on
C:\Temp\Employee}
2] If you can not easily write the code for buttons add,
delete, next, and previous [code.prg] , I would suggest that you download
Employee.zip file above
and recreate the screen from scratch; you need the practice.
3] If you can not easily write the code for Start.prg,
I would suggest that you download Employee.zip
file above and recreate the screen from scratch; you need the practice.
4] If you can not easily add and link buttons on the
Employee screen form, I would suggest that you download Employee.zip
file above and recreate the screen from scratch; you need the practice..
5] Your application shall be in a directory/folder called
Employee on floppy disk A. Create a Start Program as illustrated in lecture.
The following line of code must be able to launch your application
{Don't forget to add Set Order To Name to
your Start.prg}
6] Create a good compound index that will allow
the user to find people as illustrated below:
7] On the line below, write the code to create a good compound
index to work with the screen above
See FoxProE.html#Compound
Indexing for help! {Hint - Don't forget about Upper/Lower/Proper}
_______________________________________________________________________________________________
8] Place all of the button code in a file called Code.PRG
Include buttons Next, Previous, Add, Delete, Exit, Search By
Name. The search by name button must bring up a window in which the user
can enter a name; it must include an example.
9] What is a good caption for the Search Button? _________________________________________________
10] What is a good name for the procedure to link with
the search button? ______________________________
11] What is the Valid Event code for your search button?
___________________________________________
12] What are the three reasons for creating indexes? (a)
_____________________________________________
(b) ________________________________________ (c) __________________________________________
13] Professionally design the screen.
-
Use excellent prompts; they should be clear and meaningful!
-
Put your name and the name of the database in the screen
title bar!
-
Make the screen easy to read.
-
Use colors that would be desirable in an environment where
the user might be using the application eight hours a day!
-
Have some type of aesthetically pleasing button layout with
some type of symmetry or format!
-
Use space judiciously!
-
Center the screen
14] Print the status to a file called Status.TXT
15] Exit FoxPro. Start FoxPro from the Start button. Enter
the following into the command window to make sure that your program successfully
launches your Employee application
16] Start Paint Shop Pro. Start the screen capture
program. Do a screen capture of your database screen. Print the screen
capture! Using a pen, label this listing with an "A" in the top right corner.
See either of the following if necessary.
Install Paint
Shop Pro Tutorial
Screen Capture Tutorial
17] Exit FoxPro and start/launch Microsoft Word. Set
the margins [L = 1", T = .5", B = .5", R = .5"]
18] Load file Status.TXT into Word. Set font for
all to courier or new courier; select a size that is readable and that
will fit well on the screen. Print a copy. Using a pen, label this listing
with an "B" in the top right corner.
19] Load file Start.PRG into Word. Set font
for all to courier or new courier; select a size that is readable and that
will fit well on the screen. Print a copy. Using a pen, label this listing
with an "C" in the top right corner.
20] Load file Code.PRG into Word. Set font
for all to courier or new courier; select a size that is readable and that
will fit well on the screen. Print a copy. Using a pen, label this listing
with an "D" in the top right corner.
21] Make at least two back-up copies per team member
of this folder on other disks! See either of the following if necessary.
Windows 95/NT Tutorial
22]- You will
have one soon!
-
A] An Student.DBF has fields First and Last. Write the code
to produce a quality index for this application.
-
B] What is the name of the index file created from problem
A
-
C] Screen.SCX is the screen form for the student application.
It and all other files related to this project may be found in directory
C:\Student. Write a good Start program that would do all that is necessary
to start the screen with the master index created in problem A.
-
D] Write the code for Procedure SearchByName
23] Those Labs labeled "Individual Assignment" are
to be done separately by each individual. Using a pen, each individual
is to print print his/her name at the top of this document in the space
provided and sign it. Those Labs labeled "Team
Assignment" may be done as a team or individually. Using a pen, each
individual on the team is to print print his/her name at the top of this
document in the space provided and sign it. Submit only one copy of team
assignments!
Include the following in your wire-band binder:
A] Divider
B] Copy of this assignment sheet. Print name and sign!
C] Listings A, B, C, D (in order)
D] One of the disks containing the Employee Application