Unformatted text preview: o We made a “producer” table that connected with film . o We included a lot of additional queries and reports that we thought would be significant for the user. Assumptions of Validation Rules: o We used 25 for our field size as our standard size for most of the tables o For our list of actors and actresses, we required that they had to be >0 and <450 in weight and >0 and <100 in height (inches). o For donations, we put that the amount as to be greater than or equal to 0. Stuff that didn’t work: o When we made a query for our “Mailing List of Donors and their donations,” the report did not show up the donors’ last name and date of donation in the order you specified. However, when we sorted in our query, the order worked. o We had a problem in reporting an event calendar for March 2011 so we just created a blank report, and then we used the ‘add existing fields’ button to insert the event name and the event dates....
View Full Document
- Winter '11
- main menu, Professor Barry Floyd, ‘add existing fields