Access 2007 true false

Question

I have several questions in regards to Access 2007.

1. True or false
   1. In access 2007, when you use a template to create a new table in database view, you must set data type for the fields in the new table.
   2. You can’t use the look up wizard on access 2007 to alter existing values.
   3. In access 2007, when you create a new table in database view, you must define a primary key field. ( False, because a primary key is automatically created ??)

Answer 1

1.  False.  The template sets the data type of each column.  Bear in mind that the tables created by the templates are very simplistic and not correctly normalized, however.  This is a pointless, and potentially dangerous, feature in my view.

2.  True.  The lookup field wizard sets the data type of a column when you create it.  Essentially it creates a numeric foreign key column which references the surrogate primary key of a referenced table.  If the column already contains data it's values will probably be those which would be in a non-key column of the referenced table, most likely text values.  Note that the lookup field wizard should be avoided like the plague.  For reasons why see:

http://www.mvps.org/access/lookupfields.htm

3.  While the template tables automatically include an ID autonumber key, and if you build a table yourself Access will offer to create such a key if you don't do so yourself, it is almost invariably better to create the key yourself.  Bear in mind that the key might not be a single column, but a composite one of two or more columns, in which case you must define these as the key yourself.  In such a situation, even if you add an autonumber column as the primary key, the multiple columns are still a candidate key, in which case they must be defined as such by inclusion in a single unique index.

Answer 2

If you are an instructor teaching Access, then you should no the answer to those questions.

If you are reviewing slides someone else created then you probably shouldn't be teaching access 2007 any longer.

As someone who teaches a course in Access for a local university I would NEVER use those points in slides.

1. There is no such thing as "database" view. There is a datasheet view. And, while it is possible to create a table by just typing in values, I would never instruct people to use that method. Tables should ALWAYS be created using table design mode as it allows the user to properly define the fields by selecting datatypes, defining size, entering descriptions, captions, defaults, etc.
2. I recommend to my students NOT to create lookup fields on the table level, but rather to use list controls on forms. See the link Ken gave you.
3. If you do not define a primary key Access will prompt you to create one, in which case it automatically inserts an autonumber field named ID. As Ken advised, one should NOT let Access do this, but rather that you define you own PKs.

Access allows you to do many things that are not considered best practices. It behooves the instructor to make students aware of what those best practices are.

P.S. it is against the policy of this site to answer homework questions, its not a matter of responders to choose.

Answer 3

Why not just test each item?

Answer 4

No, this is not an assignment. I am only trying to see the questions that I have used for my power point access 2007 is functional (I am a trainer at a high school for access 2007-2010) . If you feel like it is a homework assignment then please don’t answer it.

Answer 5

Is this homework? We don't do people's homework for them.

Hint: you can't create a new table in "database" view.