Microsoft Office Tutorials and References
In Depth Information
Creating a Table in Design View
Figure 2-8
SigningDate fi eld after modifying the format
Short Date format
specified for the field
date picker
field values appear
unchanged, but the
format is applied
Although no change is apparent in the worksheet—the SigningDate field values
already appear with the Short Date setting (for example, 2/9/2013), as part of the
default General Date format—the field now has the Short Date format applied to
it. This ensures that only date field values, and not time or date/time values, are
allowed in the field.
8. Click the Close ‘Contract’ button
on the object tab to close the table.
According to his plan for the Belmont database, Oren wants to track information
about the invoices the fi rm sends to its customers. Next, you’ll create the Invoice table
for Oren—this time, working in Design view.
Creating a Table in Design View
Creating a table in Design view involves entering the fi eld names and defi ning the
properties for the fi elds, specifying a primary key for the table, and then saving the table
structure. Oren documented the design for the new Invoice table by listing each fi eld’s
name, data type, size (if applicable), and description, as shown in Figure 2-9.
Figure 2-9
Design for the Invoice table
Field Name
Data Type
Field Size
Description
Other
InvoiceNum
Text
4
Primary key
Caption = Invoice Num
ContractNum
Text
4
Foreign key
Caption = Contract Num
InvoiceAmt
Currency
Format = Currency
Decimal Places = 2
Caption = Invoice Amt
InvoiceDate
Date/Time
Format = mm/dd/yyyy
Caption = Invoice Date
InvoicePaid
Yes/No
Caption = Invoice Paid
Format = Yes/No
You will use Oren’s design as a guide for creating the Invoice table in the Belmont
database.
Search JabSto ::




Custom Search