... incident * Crime code There are many different sizes of fields I have chosen in each of the tables it really depends on the data type. For example if the data type is "text" then the field size is always 50, on the other hand if the data type is "number or "auto number" then the field size will always be long integer. How I put my plan for tables and relationships onto access Here are screenshots of what I did to set up my tables, similar to a step by step. I set up the primary key by choosing the field "ID" because it I unique key, I right clicked and selected "primary key". Setting up a relationship These are some screenshots of what I did to set up my relationships I went of "tools" then "relationships" A new window called the Show Table appeared on the screen then I Selected each table name in turn, clicking ...

See this essay or coursework document in full right now