Analyze the Results
Three tables
were used
to gather the data into the Receipt. What does that look like
in the Receipt table? Double click tblReceipt to open it and look at
the data.
This is what a table
should look like: numbers, numbers, numbers.
Databases like to eat
numbers: it’s much faster than parsing words one letter at a time.
Memo to self:
Your users don't need to see the numbers! Highlight all of the
ID fields, right click and select Hide Columns.
Default Values:
When you created the Receipt table you set the field property for
the Date to be the current date by using the code =Date(). Did it
work with your sample data?
