info5 - The Access assignment requires you to use a...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
The Access assignment requires you to use a database consisting of 5 tables. The access assignment requires you to create and execute 10 queries not related to any form. The access assignment requires you to create NO form. The access assignment requires you to create ONE report. Which of the following will not print on each page of a multi-page Access report? – Report header Which of the following will not print on the last page of a multi- page Access report? – Report header Primary and foreign keys A table typically has only one primary key and may have any # of foreign keys. A foreign key in one table is typically the primary key in a related table. TABLE DESIGN Field Data Type Text Any field that does not fit criteria for one of the other data types. This includes not only text, but also formatted numbers like ZIP codes and phone numbers. Memo Text descriptions longer than 255 characters. Number Quantities; values that will have mathematical calculations performed on them. Date/Time
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This essay was uploaded on 04/17/2008 for the course INFO 209 taught by Professor Ammons during the Spring '07 term at Texas A&M.

Ask a homework question - tutors are online