Category : Dbase (Clipper, FoxBase, etc) Languages Source Code
Archive   : DB4LESS1.ZIP
Filename : DB4BASTC.PRN

6O
PA 2A EÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ DESIGNING DATABASES WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF


P EÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿F
P E³COURSE INFORMATION³F
P EÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙF

P EThe information that follows in this course is designed toF
P Etake the student through the steps necessary to become anF
P Eefficient user of dBase IV in the shortest possible time. dBaseF
P EIV is a new system for creating and maintaining databases. It hasF
P Eits roots in earlier versions of dBase and much of it will beF
P Efamiliar to those who already know one of the previous versions.F

P EThe materials presented in DESIGNING DATABASES WITH DBASE IVF
P Eare designed for managers and first-time system designers. In itF
P Eis taught the concepts of systems analysis and design and the useF
P Eof the Control Center to create complete systems withoutF
P Eprogramming. ADVANCED DATABASE DESIGN WITH DBASE IV is designedF
P Efor those who have mastered the implementation of simple systemsF
P Eand wish to build relational systems including SQL and customF
P EdBase coding. There is emphasis on the Developer's EditionF
P Efeatures and usage.F

P EThese courses are designed to be taught in both hands-on andF
P Electure formats. In the lecture format the course will be taughtF
P Ein 2 days. In the hands on format it will be taught in 5 days.F
P EThe additional time for the hands-on students will allow ampleF
P Epractice problems to master the use of dBase IV before the end ofF
P Einstruction.F

P EThe data diskette contains the files used during thisF
P Ecourse. All examples shown during the course can be recreated atF
P Ea later time using these files.F

P ELicenses for the use of the course materials for trainingF
P Ewithin your company or organization are available from theF
P Esponsors of this seminar. Please contact them for additionalF
P Einformation.F

P EThese course materials including Manuals, Diskettes andF
P EHandouts were written by Bruce Troutman and are owned andF
P Ecopyrighted by:F

P EInterco International, LtdF
P E1170 Weldstone CourtF
P EAtlanta, GA 30305F
P EUSAF

P E(404) 392-0184F

P ELicences are granted for the personal use of students whoF
P Eattend courses offered by an authorized training facility. NoF
P Ereproduction or other use of the materials may be made withoutF
P Ethe written consent of Interco International, Ltd. dBASE IV is aF
P Etrademark of Ashton-Tate.

PEA 2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ DESIGNING DATABASES WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF

P EÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»F
P Eº TABLE OF CONTENTS ºF
P EÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼF


P EINTRODUCTION FOR USERS AND MANAGEMENT SUMMARYF

P EINTRODUCTION AND OVERVIEWF

P EHistory, Market Strength, Support 1F
P EdBase IV - The next generation 2F
P EWhat's new in dBASE IV? 2F
P EKey Strengths and Limitations 3F
P ESignificance of SQL 3F
P EInstallation 5F

P EDATABASE TOOLS AND TECHNIQUESF

P EDefinitions 6F
P EElements of Database Design 8F
P EOverview of example: Job Cost System 9F

P EDefine Phase 10F

P EDesign Phase (Worksheets) 13F

P ECreate Phase 21F
P EControl Center 21F
P EHelp System 22F
P EData Files and Indexes 23F
P EQueries 24F
P EScreen Forms 25F
P EReports 26F
P ELabels 26F
P EMenu Programs 27F

P EUse Phase 29F
P EFile Menu Usage 29F
P EAdding 30F
P EChanging 31F
P EBrowsing 32F
P ERetrieval Examples 33F
P ELists - Programming Dept 33F
P EReports - Phone List 34F
P ELabels 35F

P EMANAGING DATABASE SYSTEM DEVELOPMENTF

P ESpeed vs Cost vs Maintenance Decisions 37F
P EDevelopment with Developer's Edition 39F
P ERuntime and Compiler Considerations 39F
P ETraining Considerations 40F
P EManaging Programmers 40F

P ECONVERTING DBASE IVF
P EConversion Requirements 41F
P EWho Should Convert? 41

PEA 2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ DESIGNING DATABASES WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF

P ESYSTEM DESIGN, CREATION AND IMPLEMENTATIONF

P EDATABASE DESIGN TECHNIQUESF

P EGoals 44F
P EChecklist for Database Design 45F


P EDefine Phase - System Definition 46F
P EStep by Step Instructions 46F
P EItems Worksheet 48F

P EDesign Phase - System Design 50F
P EStep by Step Instructions 50F
P EData File Worksheet 53F
P EQuery Worksheet 54F
P EScreen Form Worksheet 55F
P EReport Worksheet 56F
P ELabel Worksheet 57F
P EMenu Worksheet 58F

P ECreate Phase 60F
P EComparison with dBase III Assist 60F
P ECatalogs 60F
P EContext-Sensitive Help 61F
P EStep by Step Instructions 62F
P EControl Center 65F
P ECreate Catalog 66F
P EData Files and Ordering 67F
P EQueries 68F
P EScreen Forms 69F
P EReports 70F
P ELabels 70F
P EMenus 71F
P ESample Program Listing 75F

P EUse Phase 77F
P EStep by Step Instructions 77F
P EMenu Usage 78F
P EData EntryF
P EAdding New Records 79F
P EChanging Existing RecordsF
P EEdit 80F
P EBrowse 81F
P ERetrievalF
P EQueries with Query By Example 82F
P ESimple Lists 82F
P EReports 83F
P ELabels 84F

P EModify Phase 87F
P EStep by Step Instructions 87

PEA 2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ DESIGNING DATABASES WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF

P ECOURSE SUMMARY 89F

P ECOURSE EXAMPLE PROBLEMS 90F

P EREFERENCEF
P EFunction Keys 91F
P EFile Extensions 92F
P EFile Structures 93F

P EEXTRA WORKSHEETSF

P EINDEX

PEA 2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ DESIGNING DATABASES WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼ
@