Overview
Students will learn what a relational-database management system is; how to create tables, forms, queries, and reports; and data-entry techniques. They will also learn good database design techniques.
Prerequisites
None.
Performance-Based Objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
- Define database terminology and identify Paradox objects.
- Create a table structure by using the Table Expert and the Create Table dialog box.
- Update and maintain tables by adding, editing, locating, and deleting records, and by restructuring a table.
- Create, modify, and use a form, and change form properties by using the Form Design window.
- Sort fields, select records, and perform calculations on data by creating and using queries.
- Create reports by using the Report Expert and a data model.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Hardware/Software Requirements:
You will need:
- a Pentium 166 MHz processor or equivalent.
- 64 MB of RAM is the recommended minimum for Windows 2000 Professional; in addition, you should have 8 MB of RAM for each application running simultaneously. (Note: Memory requirements may differ for other operating systems.)
- 600 MB of free hard-disk space.
- Either a local CD-ROM drive or access to a networked CD-ROM drive.
- A two-button mouse, an IntelliMouse, or compatible pointing device.
- VGA or higher-resolution monitor; Super VGA recommended.
- An installed printer driver. (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
- 28.8 kbps modem or faster.
- An Internet connection with access to the World Wide Web may be necessary to complete some tasks in the book. (Note: Internet access may require payment of a separate fee to a service provider; local charges may also apply.)
- A Custom Setup of Corel WordPerfect Office 2002 Professional, see the Class Requirement section for details.
- A Web browser, such as Microsoft Internet Explorer.
- Windows 2000 Professional. This course was written using the Windows 2000 Professional operating system with Service Pact 2 installed. Using this course with other operating systems or configurations may affect how the activities work. (Note: The manufacturer states that WordPerfect 10 will work with Microsoft Windows 95b (OSR2) Microsoft Windows 98, Microsoft Windows 2000, Microsoft Windows NT 4.0 with SP6 or later, or Microsoft Windows ME. For best results on Windows XP, you should download and install the latest Service Packs from the Corel Web site.)
Course duration
1 Day(s)
Course outline
Lesson 1: Overview of Paradox 10
- Topic 1A: Introduction to Database Concepts and Terminology
- Topic 1B: An Introduction to Paradox 10
- Topic 1C: Database Planning and Design
Lesson 2: Creating Tables
- Topic 2A: Examining Tables
- Topic 2B: Planning the Table Design
- Topic 2C: Creating a Table by Using the Table Expert
- Topic 2D: Creating a Table by Using the Create Table DialogBox
Lesson 3: Entering Data and Modifying Table Design
- Topic 3A: Adding Records to a Table
- Topic 3B: Finding and Editing Records
- Topic 3C: Deleting and Copying Records and Values
- Topic 3D: Modifying a Table Structure
- Topic 3E: Using the Project Viewer to Manage Files
Lesson 4: Creating and Using Forms
- Topic 4A: Creating and Modifying a Form
- Topic 4B: Changing the Properties of Form Objects
Lesson 5: Using Queries
- Topic 5A: An Orientation to Query Concepts
- Topic 5B: Selecting and Sorting Fields
- Topic 5C: Editing Table Data by Using Live Query View
- Topic 5D: Introduction to Using Calculations in Queries
- Topic 5E: Introduction to Multi-table Queries
Lesson 6: Creating and Using Reports
- Topic 6A: Creating a Report by Using the Report Expert
- Topic 6B: Creating Reports by Using a Data Model
- Topic 6C: Modifying a Report Design
Appendix A: Paradox Experts
|
