Further Details
INTRODUCTION
· Database Basic Concepts
· Database Object Overview
· Database Object Overview
USING TABLES
· Field Names vs Records
· Navigating around a table
· Entering Data
· Deleting Records
· Modifying the datasheet
Moving Columns (Fields)
Hiding/Unhiding Fields
CREATING TABLES
· Defining Field Names
· Selecting Data Types
· Using Descriptions
· Modifying Field Properties
· Using Primary Keys
· Attaching a photo or file to a record
SELECT QUERIES
· What is a query
· Designing a Query
· Using Criteria
· Sorting Results
· Creating a Calculation
· Setting the format property of a calculated column
Simple Forms
· What is a Form
· Why use a Form
· Creating a Form using the wizard
· Making simple formatting changes
· Adding a Form Header
· Adding a Calculation
· Moving and Resizing Objects
· Understanding Properties of a Form
Simple Reports
· What is a Report
· Why use a Report
· Creating a Report using the wizard
· Making simple formatting changes
· Moving and Resizing Objects
· Understanding Properties of a Form
Guide price
£150 |
