Module 2.1
Task 2 - Creating A New Database


A.M.D.G.

When you create a new database you first define your fields and field types. Then you can enter the information in a blank table.
  • Using the Start Menu, launch Microsoft Access
  • Choose to create a new, blank database called Task 2
  • Choose to create a new table in design view
  • Create the following fields

  • Save this table and close it. You need not define a primary key
  • Double click Table1 to start entering information
  • Enter information for yourself and nine classmates. If necessary, use email to obtain information from your classmates

Answer the following questions in your jotter.

1. The fields above can contain text, numbers and date/time. List the other data types available.

2. Describe two ways of moving from field to field using the keyboard.

3. How would you add another field to this database?

4. What happens if you try to enter text in a number field?

5. What happens if you try to enter a number in a text field?