|
Access Lesson #9
Objective: students will be able to insert and delete
records, sort records, and filter and find data.
-
Start>programs>Access>open an existing
database>OK>file name: dbSurvey.mdb>open
- (Inserting Records) Forms>Switchboard>Enter
Restaurant Data
- Restaurant Information>enter data for 5 ficticious restaurants
(name, address, city)>close
- Forms>Switchboard>Enter Customer Data
- Customer Information>enter data for 9 ficticious customers (last
name, first name, age, gender, area of residence, email, and restaurant
ID)>close
- (Deleting Records) Delete one of the records using
the delete record icon or edit>delete record
- (Sorting Records) Tables>tblCustomers>records>sort
ascending or sort descending
- (Finding Data) Edit>find>click on a field>write
in a key word>press find first>write in next key word>find
next
- (Filtering Data - Filtering by Form: if you want to choose
the values you are searching for from a list without scrolling through
all the records in a datasheet or form or if you want to specify multiple
criteria at once ) Records>filter>filter by form>choose
values>record>apply filter
- (Filtering Data - Filtering by Selection: if you want to choose
a specific value quickly or exclude a specific value) Records>filter>filter
by selection>choose values>record>apply filter OR right
click a field>filter excluding selection
- (Filtering Data - Filtering For Input: if you want to choose
a specific value quickly by typing in the value) right click
a field>filter for>type in value>press tab>filter for>type
in value>continue until you find what you are looking for
Copyright@2000(K. Kim). All Rights Reserved
|