|
Access Lesson #1
Objective: students will be able to create a table
in design view.
- Start>programs>Access>blank database>file name: dbSurvey.mdb>create
- Table>new>design view
- Last Name>text
- First Name>text
- Age>Number>Lookup Wizard>I will type in the values that
I want.>13,14,15,16,17,18,19>next>finish
- Gender>Text>Lookup Wizard>I will type in the values that
I want.>Male, Female>next>finish
- Area of Residence>Text>Lookup Wizard>I will type in the
values that I want.>Altamont, Ambleside, Bayridge, Bowen Island,
British Properties, Caulfield, Cedardale, Chelsea Park / Panorama
Village, Cypress Park Estates, Cypress Park / Sandy Cove, Deer Ridge,
Dundarave, Eagle Harbour, Gleneagles, Glenmore, Lions Bay, Park Royal,
Sentinel Hill, Upper Caulfield, Westmount / West Bay, Whytecliff /
Horseshoe Bay>Description>What area in West Vancouver do you
live in?
- Email>text>field size>50
- Close>save as>tblCustomers>Do you want to create a primary
key now?> yes>file>save
Copyright@2000(K. Kim). All Rights Reserved
|