Course outline
Introduction to Databases• Relational database concepts and terminology
• Creating a database
• Displaying object properties
Creating a Table
• Defining the table structure
• Defining field types and properties; creating a primary key
Editing Table Data
• Entering and editing records
• Table navigation techniques
• Customising table layout
• Previewing and printing data; scaling the preview window
Querying Data
• Creating ‘Select’, ‘Action’ and Parameter and Crosstab queries
• Entering criteria
• Creating calculated fields
• Querying multiple tables
Forms
• Creating forms using Form Wizards
• Changing the design of forms
• Creating list and combo boxes for data entry
• Creating calculated fields
Reports
• Creating reports using Report Wizards
• Changing the design of reports
• Sorting and grouping data
Restructuring a Table/Object Management
• Inserting and deleting fields; renaming and re-arranging fields
• Changing data types and field properties
• Renaming, deleting, and copying objects
Opening, Converting and Saving Databases
• Opening and Converting databases in previous versions
• Saving databases in previous version
