Introduction to Databases  
line decor
  
line decor
 
 
 
 

 
 
Exercise 11: CREATING A NEW DATABASE
 
Database Databases FILES store information in RECORDS. Each record is broken into FIELDS with each field containing a separate pieces of information.
  Fields can be of different types depending on the type of data they contain. Setting the correct field type is important as they help in sorting and searching the database.
   
 
 
TO DO - Making a New Database
Watch the New Database Movie 11 to CREATE a NEW DATABASE.

Make sure you use the following FIELD NAMES and FIELD TYPES.
 
Field Name Field Type
forename Text
surname Text
age Number
post code Text
phone number Number
 
 
 
 
Once you have created your NEW DATABASE, make sure you
 
Mark off Exercise 11 in your progress Grids
 
Next
 
 

 

 
 

 

'HOW DO I' MOVIES

Introduction to Databases Introduction to Databases
   
Simple Sorting Movie 1. Simple Sorting
   
Complex Sorting Movie 2. Complex Sorting
   
Simple Searching Movie 3. Simple Searching
   
Complex Searching 4. Complex Searching
   
Adding Records Movie 5. Adding Records
   
Deleting Records Movie 6. Deleting Records
   
Amending Records Movie 7. Amending Records
   
Changing Layouts Movie 8. Changing Layouts
   
New Column Layout Movie 9. New Column Layouts
   
New Form Layout Movie 10. New Form Layout
   
Create Detabase Movie 11. New Database
   
Working with Database Movie 12. Working with New Database.