Print Name __________________________
Signature __________________________
Visual FoxPro Lab A
a] Create a directory called Client; perhaps at the root of your own personal C drive or in a network folder.
b] Set the default location to your folder.
c] Create a database table, called Client.dbf; add 5 complete records to the database table. Your choice of info
d] Print a copy of all of the information about all of the clients. Using a pen, place an 'A' in the top right corner of the listing.
e] Print a copy of the name and phone number of all cleints.Using a pen, place an 'B' in the top right corner of the listing.
f] Exit FoxPro. Using a floppy disk, make a copy of folder Client. Using a second floppy disk, make a copy of folder Client. Always make at least two backup copies of all work done this semester. Do not leave a copy of your work in a public folder on a University Computer!
1 NAME
Character 26
No
2 NO
Numeric 4
No
3 NOMIN
Numeric 3
No
4 VENDOR
Character 16
No
5 DRAMMA
Logical 1
No
6 MYSTERY
Logical 1
No
7 COMEDY
Logical 1
No
8 HORROR
Logical 1
No
9 RATING
Numeric 2
No
10 NOTES
Memo 4
No
** Total **
60
-------------------------------------- Use the Video.DBF structure above for all questions! -------------------------------------
________________________________________________________________________________________
2] What is a database table:
________________________________________________________________
_______________________________________________________________________________________
3] DBMS is an acronym for _________________________________________________________________
4] What is a record? _______________________________________________________________________
5] How do exit FoxPro? ____________________________________________________________________
6] _________ (T/F) Database applications should always be created inside a directory/folder.
7] How do you make directory Video, at the root of the disk in the left (A) drive, the default directory?
_______________________________________________________________________________________
8] How do you make directory Client, at the root of the disk in the top(A) drive, the default directory?
_______________________________________________________________________________________
9] How does one create the database, called Video; it is in the default directory. ______________________
10] FoxPro database files have _____________ as an extension.
11] Name all five of the field datatypes that we shall use. __________________________________________
________________________________________________________________________________________
12] When one is using the crude data entry editor, the four valid entries for logical fields are _____________
13] When one is using the crude data entry editor, how does one get into the memo field? ______________
_______________________________________________________________________________________
14] How can you display all
of the information in all of the video records on the screen. (no pause)
_______________________________________________________________________________________
15] How can you display the
name, minutes in length, and number of all videos on the screen. (no pause)
________________________________________________________________________________________
16] How can you display the
name, vendor, and number of all videos on the screen. (no pause)
________________________________________________________________________________________
17] How can you print all of
the information in all of the video records.
________________________________________________________________________________________
18] How can you print the name, minutes in length, and number of all videos.
________________________________________________________________________________________
19] How can you print the
name, vendor, and number of all videos.
________________________________________________________________________________________
20] _________ (T/F) The command, USE VIDEO, attempts to open a database file, called Video.DBF, in the default directory.
21] _________ (T/F) When the database, Client.dbf, is opened in the current workspace, any other database open in the current workspace is automatically closed.
22] The database, Student.DBF is
open in the current workspace. How can you close this database?
________________________________________________________________________________________
23] How do you open the Client.dbf database in the current workspace? _____________________________
24] ____________ (T/F) Database structure and database layout are synonymous.
26] How does one display the database layout? (no pause) _______________________________________
27] How does one display the database layout? (pause) __________________________________________
28] How does one print the database layout? (no pause) __________________________________________
29] What does the command, display structure, produce? _______________________________________
________________________________________________________________________________________
30] What is the difference between the command, display structure, and the command, list structure?
________________________________________________________________________________________
31] Database Client.DBF is open in the current
work area. How does one close this database without opening another database
and without exiting FoxPro?
________________________________________________________________________________________
33] 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!
1] This assignment sheet totally completed. Read & sign the first page.
2] Either sign or place initials in top right corner of each page using!
3] Listings A and B
4] Keep the database Client. I will provide you a drop box in which to copy this file later