2 Tutorial Maintain and Modify Tables
Review Assignment pages 2.36 to 2.37
Supplemental Instructions
There
All
is no "student disk"
files needed are provided via links on web pages
We
will never "print" anything
objects will be graded
Underlying
Supplemental
instructions modify the review exercises so they are consistent with our development standards and network locations
Setup
Create
...
folder: Files from Web
to Tutorial 2 page, save Elsa.mdb
Classwork/BA271/Tutorial/
Download
Navigate
Open
Access
Select
"create a blank database" option Save database as Recruits
Step 3
Create
Table by using Wizard
Employees table
Select
Fields:
SSN, Salary, FirstName, MiddleName, LastName Rename SSN before you click Next.
Name
the table Recruiter
the "No" option on primary key
Select
Complete
the wizard using the defaults Select middle option "Enter data"
Step 4 enter data
892-771201 901-631554 893-911078 40,000 Kate 38,500 Paul 40,000 Ryan Teresa Michael James Foster Kirnicki DuBrava
Step 5
Open Note:
SSN
Recruiter in Design view
field: primary key, indexed, input mask Name fields: have captions Last Name: foreign key indexed
Step
a: move Salary after LastName
Step 5 (cont'd)
Step
b: Add BonusQuota
Between
LastName and Salary Name: BonusQuota Type: Number Description: Number of recruited students needed to receive bonus Properties:
Field
size: byte Decimal places: 0 Caption: Bonus Quota
Step 5 (cont'd)
Step
c: Format Salary for:
Commas,
no $, no decimals Use "Standard"
Save
Step 6: Update
Add
BonusQuota:
DuBrava: Foster:
60 60 Kirnicki: 50
Add
new record:
Sonia, Lee, Xu, 50, 39250
899-40-2937,
Step 7
Set
Compact on Close option
Step 8
To
copy data from another application into a table:
The
columns must be in the exact same order The matched columns must have the same data type Open the Recruiter Employees table in the Elsa database
Open
the Recruiter table, select an entire row for insert, then use Edit | Paste
Use
Edit | Select All then Edit | Copy
Step 9
Compact
Tools
& Repair the database
| Database Utilities | Compact and Repair
Steps 10 & 11
Open Open
Recruiter in design mode
MiddleName field and delete
Select select
Recruiter in view mode
all columns Choose Format | Column Width... from the main menu
Choose
the Best fit option
Caution:
only resize what is displayed Save the table
Step 13
Select
the Table object, then select the "New"
"Import Table" from the dialog window
option
Select
(Insert Table...