Microsoft Office Tutorials and References
In Depth Information
Session 2.2
Key Terms
Caption property
composite key
data redundancy
data type
Database Wizard
Decimal Places property
Default Value property
Description property
Design view
editing mode
entity integrity
F1 key
F2 key
F6 key
Field Size property
import
maintain (a database)
navigation mode
null value
pencil symbol
propagate
properties
set (a property)
star symbol
update (a database)
Review Assignments
Data File needed for the Review Assignments: Elsa.mdb
Elsa needs a database to track data about the students recruited by NSJI and about the
recruiters who find jobs for the students. She asks you to create the database by complet-
ing the following:
Practice
Take time to practice
the skills you learned in
the tutorial using the
same case scenario.
1. Start Access, and make sure your Data Files are in the proper location.
2. Create a new, blank database named Recruits and save it in the Brief\Review folder
included with your Data Files.
3. Use Design view to create a new table using the table design shown in Figure 2-36.
Figure 2-36
Field Name
Data Type
Description
Field Size
Caption
Other Properties
SSN
Text
Primary key
30
Salary
Currency
Format: Currency
Default Value: (blank)
FirstName
Text
50
First Name
MiddleName
Text
30
Middle Name
LastName
Text
50
Last Name
4. Specify SSN as the primary key field, and then save the table as Recruiter .
5. Add the recruiter records shown in Figure 2-37 to the Recruiter table.
Figure 2-37
SSN
Salary
FirstName
MiddleName
LastName
892-77-1201
40,000
Kate
Teresa
Foster
901-63-1554
38,500
Paul
Michael
Kirnicki
893-91-0178
40,000
Ryan
James
DuBrava
 
Search JabSto ::




Custom Search