Microsoft Office Tutorials and References
In Depth Information
To Create an Additional Table
The JSP Recruiters database contains two tables, the Client table and the Recruiter table. You need to create
the Recruiter table and add records to it. Because you already used the default table that Access created when you
created the database, you will need to ﬁ rst create the table. You can then add ﬁ elds as you did with the Client table.
The ﬁ elds to be added are Recruiter Number, Last Name, First Name, Street, City, State, Postal Code, Rate, and
Commission. The data type for the Rate ﬁ eld is Number, and the data type for the Commission ﬁ eld is Currency.
The data type for all other ﬁ elds is Text. The following steps create the Recruiter table.
• Click Create on the Ribbon to
display the Create tab
• Click the Table button on the
Create tab to create a new table
Could I save the table now so I can
assign it the name I want, rather
You certainly can. Be aware,
however, that you will still need to save
it again once you have added all
your ﬁ elds.
add new ﬁ eld
new table open
in Datasheet view