Quiz 6

1) To change fields in some record, I would use a _____ query:
a) SELECT
b) CHANGE
c) MODIFY
d) UPDATE

2) To choose all records in the Books table, combined with information about the author from the author table, I would write:
a) Select * from Books, Author Where Books.Title = "Beginning Finnish"
b) Select * from Books, Author Where Books.AuthId = Author.AuthID
c) Select * from Books, Author Where Author="Waxman"
d) Select Title, Author from Books, Author Group By Title

3) An example of a calculated field would be:
a) =[Title] & [Author]
b) Books.Title
c) there is no such thing
d) the Expression Builder

4) A form-subform is:
a) a split form with the datasheet on the top and a columnar view of the same data on the bottom
b) usually columnar at the top and related fields from another table in a datasheet at the bottom.
c) A form that uses Sub-routines
d) nothing ... I made it up.

5) An Excel linked table is : __________________