Microsoft Office Tutorials and References
In Depth Information
Session 2.2
Session 2.1 Quick Check
Review
1. What guidelines should you follow when designing a database?
2. What is the purpose of the Data Type property for a field?
3. For which three types of fields can you assign a field size?
4. You use the property to specify how a field name appears in
datasheets, forms, and reports.
5. In Design view, which key do you press to move between the Table Design grid and
the Field Properties pane?
6. A(n) value, which results when you do not enter a value for a field,
is not permitted for a primary key.
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
Session 2.2
Adding Records to a Table
You can add records to an Access table in several ways. A table datasheet provides a sim-
ple way for you to add records. As you learned in Tutorial 1, a datasheet shows a table’s
contents in rows and columns. Each row is a separate record in the table, and each col-
umn contains the field values for one field in the table. If you are currently working in
Design view, you first must change from Design view to Datasheet view in order to view
the table’s datasheet.
Elsa asks you to add the two records shown in Figure 2-16 to the Position table. These two
records contain data for positions that have recently become available at two employers.
For hands-on practice of
key tasks in this session,
go to the SAM 2003
Training Companion CD
included with this text.
Records to be added to the Position table
Figure 2-16
PositionID
2021
2017
Wage
9.50
15.00
HoursPerWeek
30
20
Openings
1
1
ReferredBy
Sue Brown
Ed Curran
StartDate
6/30/2006
9/21/2006
EndDate
9/15/2006
11/1/2006
PositionTitle
Waiter/Waitress
Tour Guide
EmployerID
10155
10149
To add the records in the Position table datasheet:
1. If you took a break after the previous session, make sure that Access is running and that
the Position table of the Northeast database is open in Design view. To open the table in
Design view from the Database window, right-click the Position table, and then click
Design View on the shortcut menu.
Access displays the fields you defined for the Position table in Design view. Now you need
to switch to Datasheet view so that you can enter the two records for Elsa.
2. Click the View button for Datasheet view on the Table Design toolbar. The Table win-
dow opens in Datasheet view. See Figure 2-17.
Search JabSto ::




Custom Search