ACCESS Practice 1

1
ACCESS Practice 1
2
Lesson 1. Using Forms

• Form
• A graphic object that can display and accept data
  for related tables
• Execute the setup file in the CD
• Open the Access DB file Sweetlil.mdb in
  Access2000 SBS Practice folder (p.29)
• Follow the steps as in p.3148

3
The steps in p.3137

• Data input
• Use Chocolate Preferences form
• Use TAB key to move to next field
• Use record move buttons (?,?) to move between
  records
• Use new record button (? ) to enter a new
  record
• Use Bonbons form
• Use combo box to select an input data

4
The steps in p.3840

• Data search
• Use Customer Review form
• Click a specific field for search to find a
  record. E.g. Last Name field
• Click the icon of binocular field glasses for
  search form
• You may use wild card characters()
• corresponds to any number of any characters
• ? corresponds to any character
• EX) Nman Newman, Newmann, Neumann,
• ?ouse douse, house, louse,
• You can search by
• Matching in all contents in a field
• Matching in part of contents in a field
• Matching in beginning of a field

5
The steps in p.4147

• Data editing
• Data editing task is similar in word processors
• Insert (p 42)
• Copy (p 43)
• Add a new record (p 44)
• Cancel edited work (p 44)
• You can change all data that meet some condition
  at once (p 47)

6
Lesson 2. Tables and Subforms

• A database contains many tables.
• Basket Details, Baskets, Bonbons, Box Details,
• See p.54
• Open Baskets table and follow the steps as in
  p.5556
• Change size of row or column
• A form can contain subform(s)
• a form or subform can be linked to a table.
• So, multiple tables can be linked in a form
• Follow the steps as in p.5761

7
subforms
From table Bonbons
Linked to table Baskets
Linked to table Basket Details
8
The steps in p.5760

• Insert a new record into the main form using new
  record input button (?)
• Insert several new records into the subform after
  moving to the first field of the subform (use
  TAB key)

9
The steps in p.6061

• You can see a whole table by using Data sheet
  menu
• You can adjust the width of each column for
  better inspection