This two day course explores the concept of a relational database, enabling the delegate to design and build a sample application. Viewing data, interrogating and producing simple reports is also covered. Delegates need only have user knowledge of Windows 95/98/2000 or NT.
Getting Started The Approach Work Area, Accessing a Database
Creating a Database Create a New File, Define Fields, Manipulating Fields, Add Save & Edit Records
Forms Create New Forms, Add & Modify Fields, Enter & Edit Data
Reports Create a New Report, Adjust Fields, Add Footers, Create Form Letters & Labels, Print
Find & Sort Create a Find Request, AND & OR Criteria, Data Type, Sort Keys, Modify Sort Order
Join How & Why?, Types of Relationships, Create a Relationship, Unjoining Files
Macros Create a Macro, Save & Run, Command Button Macros