Chapter 1: An Overview of dBASE 5.0 for Windows
Getting Started
Chapter 1 provides students with an overview of Windows and dBASE 5.0. Student activities include learning how to start Windows and dBASE, identifying Windows and dBASE terminology, and recognizing Windows and dBASE screens. Students also use dBASE Help and Interactive Tutors to learn more about dBASE. All solutions are saved in the CHAPTER1 subdirectory.
Objective 1: Recognize Databases and Understand Their Purposes
Objective 2: Start dBASE 5.0 for Windows
Objective 3: Understand dBASE Windows
Objective 4: Use dBASE Help
Objective 5: Use Interactive Tutors
Objective 6: Exit dBASE
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	T (1) 	6.	F (5)
	2.	F (1) 	7.	T (1)
	3.	T (1) 	8.	T (4)
	4.	T (3) 	9.	F (4)
	5.	F (2) 	10.	F (1)
Multiple Choice Questions
	1.	a (1) 	6.	a (1)
	2.	c (1) 	7.	c (2)
	3.	b (4) 	8.	a (3)
	4.	d (1) 	9.	a (4)
	5.	c (1) 	10.	a (1,3)
Fill-in-the-Blank Questions
	1.	table (1,3)
	2.	bottom (3)
	3.	pass the mouse pointer over the button; the status bar displays a short description of the button (3)
	4.	Interactive Tutors (5)
	5.	buttons (3)
	6.	F1 (4)
	7.	Exit (6)
	8.	relational database, flat file, (1)
	9.	shortcut (3)
	10.	F4 (6)



Chapter 2: Creating a dBASE 5.0 Table
Getting Started
Chapter 2 gives students the opportunity to create dBASE tables. To provide the foundation for this activity, the chapter introduces and describes the various Table Records views and the Table Structure view. Students gain practice opening and closing tables and are presented with numerous terms the understanding of which is essential to success with dBASE. After creating, naming, and saving a database table structure; students modify, then print a table structure. All solutions are saved in the CHAPTER2 subdirectory.
Chapter Outline
	Objective 1: Open a dBASE Table
	Objective 2: Understand the Table Records Views
	Objective 3: Understand the Table Structure View
	Objective 4: Create a New Table
	Objective 5: Modify a Table Structure
	Objective 6: Print a Table Structure
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	T (intro)	6.	T (2)
	2.	T (2)	7.	T (3)
	3.	T (1)	8.	F (3)
	4.	F (2)	9.	F (3)
	5.	T (3)	10.	F (2)
Multiple-Choice Questions
	1.	b (3)	6.	b (3)
	2.	c (intro)	7.	d (3)
	3.	c (2)	8.	a (4)
	4.	a (2)	9.	d (2)
	5.	c (3)	10.	a (3)
Fill-in-the-Blank Questions
	1.	dbf (1)
	2.	structure (3)
	3.	Shift+F2 (1)
	4.	F2 (1)
	5.	double-headed arrow (5)
	6.	hand (5)
	7.	structure (5)
	8.	three (1)
	9.	right (3)
	10.	Browse (2)



Chapter 3: Entering and Editing Data
Getting Started
Chapter 3 provides students with directions for adding records to a table, moving among records and fields, editing records, deleting and blanking records, adjusting column widths, and finding and replacing records. In addition, numerous table records properties are introduced and methods provided for changing these properties (characteristics). Finally, students print dBASE tables. Several activities are provided for students to reinforce the concepts learned in the chapter. All solutions are saved in the CHAPTER3 subdirectory.
Note: Some records shown in the figures of this chapter do not exactly match the records in the ADDRESS.DBF. However, students will be able to see the illustrations of the various stacks.
Chapter Outline
	Objective 1: Add Records
	Objective 2: Move among Records and Fields
	Objective 3: Edit Records
	Objective 4: Blank and Delete Records
	Objective 5: Adjust Column Widths
	Objective 6: Set Table Records Window Properties
	Objective 7: Find a Record
	Objective 8: Print a Table
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	F (4)	6.	T (4)
	2.	T (4)	7.	F (6)
	3.	F (4)	8.	F (6)
	4.	F (5)	9.	T (3)
	5.	T (2)	10.	T (7)
Multiple Choice Questions
	1.	a (2)	6.	b (3)
	2.	c (2)	7.	c (2)
	3.	a (3)	8.	b (6)
	4.	b (5)	9.	b (6)
	5.	b (7)	10.	a (6)
Fill-in-the-Blank Questions
	1.	recall (4)
	2.	see the deleted records (4)
	3.	record number column (4)
	4.	pack (4)
	5.	status bar (2)
	6.	Delete Records (4)
	7.	Zap (4)
	8.	Browse (5)
	9.	expression (6)
	10.	Freeze (6)



Chapter 4: Creating and Using Indexes, Sorts, and Queries
Getting Started
Chapter 4 provides students opportunities to create and use dBASE indexes, sorts, and queries. Directions for modifying queries are also presented. Instructions for using the AND and the OR filters are included in Chapter 4, as well as guidelines for using wild cards in query designs. Finally, students learn to create multi-table queries. All solutions are saved in the CHAPTER4 subdirectory.
Chapter Outline
	Objective 1: Understand and Create Indexes
	Objective 2: Understand and Create Sorts
	Objective 3: Understand and Create Queries
	Objective 4: Save and Name a Query
	Objective 5: View Query Results
	Objective 6: Print Query Results
	Objective 7: Modify a Query
	Objective 8: Create Multi-Table Queries
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	T (3)	6.	T (2)
	2.	T (3)	7.	F (4)
	3.	T (3)	8.	T (8)
	4.	T (1)	9.	F (8)
	5.	F (3)	10.	F (9)
Multiple-Choice Questions
	1.	a (4)	6.	d (4)
	2.	a (intro)	7.	b (4)
	3.	d (1)	8.	b (5)
	4.	a (2)	9.	d (5)
	5.	d (4)	10.	d (8)
Fill-in-the-Blank Questions
	1.	child (9)
	2.	AND (8)
	3.	? (8)
	4.	parent (9)
	5.	QBE (5)
	6.	MDX (1)
	7.	field name (1)
	8.	table (4)
	9.	Filters (4)
	10.	OR (8)



Chapter 5: Creating and Using Forms
Getting Started
Chapter 5 provides students the opportunity to create and use dBASE forms. Student tutorials provide activities for creating and modifying forms using the Form Expert and the Form Designer tool. Directions are also provided for printing forms. All solutions are saved in the CHAPTER5 subdirectory.
Chapter Outline
	Objective 1: Understand Forms
	Objective 2: Create, Save, and Open a Form
	Objective 3: Use the Form Designer Tool
	Objective 4: Work with a Form
	Objective 5: Print a Form
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	T (2)	6.	T (3)
	2.	F (1, 4)	7.	F (1)
	3.	T (3)	8.	F (4))
	4.	T (1)	9.	T (1)
	5.	F (1)	10.	F (1)
Multiple-Choice Questions
	1.	a (1)	6.	a (3)
	2.	d (1)	7.	d (3)
	3.	b (1)	8.	d (3)
	4.	a (1)	9.	c (3)
	5.	d (2)	10.	a (3)
Fill-in-the-Blank Questions
	1.	Layout, Order (3)
	2.	double-headed arrow (3) 
	3.	One to Many layout (1)
	4.	before (1)
	5.	controls (3)
	6.	> (2)
	7.	W (2)
	8.	Form Design (3)
	9.	WFM (2)
	10.	Layout (3)



Chapter 6: Creating and Enhancing Reports and Labels
Getting Started
Chapter 6 provides students the opportunity to create dBASE reports and mailing labels. Student tutorials provide activities for creating, modifying, and printing reports and mailing labels. All solutions are saved in the CHAPTER6 subdirectory.
Chapter Outline
	Objective 1: Understand dBASE Reports
	Objective 2: Create a New Report
	Objective 3: Preview, Save, and Name a Report
	Objective 4: Modify a Report Design and Print a Report
	Objective 5: Create Mailing Labels
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	T (1)	6.	T (3)
	2.	F (4)	7.	T (4)
	3.	T (1)	8.	T (4)
	4.	T (2)	9.	T (4)
	5.	T (2)	10.	T (2)
Multiple-Choice Questions
	1.	b (4)	6.	b (4)
	2.	d (4)	7.	a (4)
	3.	a (4)	8.	a (3)
	4.	c (4)	9.	d (4)
	5.	c (5)	10.	d (4)
Fill-in-the-Blank Questions
	1.	Untitled Report #X (3)
	2.	3 (1)
	3.	Insert Database Field (2)
	4.	eight (3)
	5.	handles (4)
	6.	Del (4)
	7.	Insert Database Field dialog box (4)
	8.	Window (4)
	9.	File, Print, Report Definition (4)
	10.	Ctrl + + (2)



Chapter 7: Using the Command Window
Getting Started
Chapter 7 introduces the Command window, which is used to type dBASE commands rather than to use the various dBASE menus. Students learn to perform through the Command window the activities they have learned to do previously using dBASE menus. In addition, commands that are not available through the menus are introduced. All solutions are saved in the CHAPTER7 subdirectory.
Chapter Outline
	Objective 1: Understand the Command Window
	Objective 2: Create, Save, Name, Modify, and Open a Table
	Objective 3: Add, Insert, Delete, and Blank Records
	Objective 4: Move among Records
	Objective 5: Create an Index and a Sort
	Objective 6: Create a Query, Form, and Report
	Objective 7: View and Print Records
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	T (1)	6.	T (4)
	2.	T (1)	7.	F (6)
	3.	F (1)	8.	T (7)
	4.	F (3)	9.	F (7)
	5.	T (3)	10.	T (4)
Multiple-Choice Questions
	1.	d (2)	6.	c (3)
	2.	c (5)	7.	b (4)
	3.	a (7)	8.	b (5)
	4.	c (5)	9.	c (5)
	5.	a (6)	10.	d (3)
Fill-in-the-Blank Questions
	1.	Input (1)
	2.	DELETE (3)
	3.	PACK (3)
	4.	GOTO TOP (4)
	5.	CREATE FORM EXPERT (6)
	6.	Input (1)
	7.	status bar (4)
	8.	MODIFY STRUCTURE (2)
	9.	CREATE QUERY (6)
	10.	Results (1)



Chapter 8: File Management Activities Using the Command Window
Getting Started
Chapter 8 provides directions for using the Command window to perform file management commands that are not available through the dBASE menus. Students learn to copy tables and table components; rename and erase tables; turn off the dBASE bell; and use the DISPLAY, LIST, DIR, and UPPER commands. All solutions are saved in the CHAPTER8 subdirectory.
Chapter Outline
	Objective 1: Copy dBASE Tables, Specific Records, and Table Structures
	Objective 2: Rename and Erase dBASE Tables
	Objective 3: Execute Miscellaneous File Management Commands
Answers to Checking Your Skills
Note: Numbers in parentheses refer to the objective being addressed.
True/False Questions
	1.	F (intro)	6.	F (1)
	2.	T (1)	7.	F (2)
	3.	T (1)	8.	F (2)
	4.	T (1)	9.	T (3)
	5.	T (2)	10.	F (1)
Multiple-Choice Questions
	1.	a (1)	6.	a (2)
	2.	c (1)	7.	c (3)
	3.	d (1)	8.	b (3)
	4.	b (2)	9.	d (3)
	5.	c (2)	10.	d (3)
Fill-in-the-Blank Questions
	1.	COPY (1)
	2.	*.* (3)
	3.	COPY STRUCTURE (1)
	4.	ERASE (2)
	5.	Alert (2)
	6.	TRIM() UPPER() (3)
	7.	SET BELL OFF (3)
	8.	DISPLAY FILES (3)
	9.	FILES (3)
	10.	USE TITLE2 (1)