Question #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.
Question #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?
Question #3: In Access, which of these means condA has to be true and also either condB or condC
must be true?
Solution 1
SELECT *
FROM sample1
WHERE condA = "A" and (condB > 15 or condC > 100);
Solution 2
SELECT *
FROM sample2
WHERE condA = "A" and condB > 15 or condC > 100;
Question #4: True or False (and why) In Access, the database is made up of one or more
tables. The table structure that is laid out is the structure for the records you will put in the table.
The records in the table are made up of fields.
EXAMPLE I have a database table with the following layout:
softwareId
softwareName
developer
releaseNumber
softwareType (G for game, B for business, E for education)
freebuy (F or B)
Question #5: Using the software layout above, write a SQL query for a
particular developer AND a particular softwareType OR just a F in freebuy.
Question #6: Using the software layout above, write a SQL query for a
particular developer AND either a particular softwareType OR a F
in freebuy.
Question #7: You are working with Access and you want to keep the social security number, name, job code and pay rate for your employees. What is the name for each of these data items?
A/ field
B/ file or table
C/ record
D/ character
Question #8: You are working with Access. Looking at the data in the problem above: you want to store all of the information about a specific employee together. What is the name for storing these fields together as a unit?
A/ field
B/ file or table
C/ record
D/ character
Question #9: You are working with Access. Looking at the data in the problem above: you want to store all of the information about all of the employees of your company together. What is the name for storing this data together as a unit?
A/ field
B/ file or table
C/ record
D/ character
Question #10: A database in Access can be made up of a group of ________________________ that hold the collection of data. For
example there might be one holding inventory information and one holding customer information.
A/ tables
B/ columns
C/ variables
D/ none of the above