Please choose the course you would like to do using the browser below.
-
-
| Campus |
|
| Category |
|
| Course |
|
-
| Category |
|
| Course |
|
| Course | Access Learning CDs |
| Level | Introduction |
| Version | 2003 |
| Duration (days) | N/A |
| Fee | $315 |
 |
-
| Traineeships |
|
|
|
|
-

Provider: 1816
Access Learning CDs 2003 Introduction |
| |
| Course aim |
| This course aims to develop skills using Microsoft Access to produce and databases to an Introductry level. |
| Course outline |
The CD course covers:
Introduction • Relational Databases • Flat System • Relational System • Database Components
Database Objects • Tables • Queries • Forms • Reports • Macros • Modules • Data Access Page
Database Planning • Naming Conventions • Convention Examples • Database Design • Plan Purpose • Plan Tables • Plan Fields • Field Names - Plan Relationships
Examining Access • Starting Access • Table View • Switching Views • Query View • Forms View • Report View • Create New Database • Database Wizard
Creating Tables • File Format Considerations • Create Table • Data Type • Description • Assign Primary Key • Saving • Using the Table Wizard
Text Field Properties • Field Size • Format • Caption • Default Value • Required • Allow Zero Length • Numbered Text Fields • Input Mask
Number Field Properties • Number Field Size • Format Date • Validation Rule • Validation Text • Validation Data • End Date Validation Rule |
|
|