Quiz #2

You should read chapter #1 - questions will be about Access and from the text

Remember if you do not have the text, most of chapter #1 is available at Amazon if you look up the book and then look at what is inside. Please read chapter #1 one way of the other.
The and why must only be answered if the answer is false.

Problem #1: True or False (and why): In Access, the field(s) labeled as the primary key must contain data and the data must be unique. No two primary keys can have the same value.

Problem #2: True or False (and why): If two things in an Access query are in an OR relationship, they both have to be true to meet the criteria?

Problem #3: In the user interface in Access, if you have a situation where condA has to be true and in addition either condB or condC has to be true, how would you enter the conditions on the query.

Problem #4: If you are using SQL in Access and you have a sitation where condA has to be true and in addition either condB or condC has to be true, how would you write it in Access SQL.

Problem #5: The assignment operator is the _____________ in many modern programming languages.

Problem #6: True or False (and why): A database is made up of tables, a table consists of a group of related records, the data in a record is stored in fields.

Problem #7: True or False: Grocer Rule: When programming and developing you should not use embedded spaces when you give something a name.

Problem #8: True or False (explain): The select statement below would be resolved to show records where the student's major is CI or both the student lives in MA and the major is BU.
SELECT idno, name, major, state, gpa
FROM studenttable
WHERE major = "CI" and state = "MA" or major = "BU";

Problem #9: Looking at the SQL in #8, explain how you would have coded the logic if you were using the user interface.

Problem #10: True or False (and why): A table is a data structure that holds information in columns and rows. A row represents a record and a column represents a field.