Microsoft Office Tutorials and References
In Depth Information
an existing table in the database but provides an option to create no
relationship. You could create a relationship among people stored in a Contacts
table and the comments they make stored in a Comments table. If you do
create a relationship when adding the Application Part to your database,
you see the related field in the new table in addition to the fields listed in the
following list. You have five template choices:
✦ Comments: This template includes a Comments table with the fields ID,
CommentDate, and Comment.
✦ Contacts: This template includes a Contacts table with the fields ID,
Company, Last Name, First Name, E-mail Address, Job Title,
Business Phone, Home Phone, Mobile Phone, Fax Number,
Address, City, State/Province, Zip, Country, Web Page, Notes,
and Attachments, as well as the calculated fields ContactName
and FileAs. Additional database objects included are the
ContactsExtended query, ContactDetails form, ContactDS form,
ContactList form, ContactAddressBook report, ContactList
report, ContactPhoneBook report, and Label report. This template
is a good one to use if you want to store an address book in Access.
✦ Issues: This template includes an Issues table with the fields ID,
Summary, Status, Priority, Category, Project, OpenedDate,
DueDate, Keywords, Resolution, ResolvedVersion, and
Attachments, as well as an IssueDetail form and an IssueNew form.
✦ Tasks: This template includes a Tasks table with the fields ID, TaskTitle,
Priority, Status, Description, StartDate, DueDate, Attachments,
and Percent Complete, as well as the calculated field Active. Additional
database objects are a TaskDetails form and a TaskDS form. This
template can be part of a project-management database.
✦ Users: This template includes a Users table with the fields ID, Email,
FullName, and Login, as well as UserDetails and UsersMain forms.
When you’ve chosen the template you want to use, wait a second while Access
creates the table and any other objects. Then you can enter data or change
the objects, just as you could if you’d created the objects from scratch.
In the first part of this chapter, we show you a straightforward and familiar
way to enter data in a datasheet, thereby automatically creating fields that
you can rename to reflect the data. This method of entering and storing data
is familiar to anyone who has used Excel or any other spreadsheet program,
and it works well.
In Book I, we emphasize designing your database before you start entering
data. If you follow that advice, you may want to define fields and tables
before you enter any data at all. This section shows you how to define fields