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
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.