1.What is Microsoft Access?
2.What is the file extension for an Access 2007 and later database?
3.Which object in Access is used to store data?
4.What is a field in a database table?
5.What is a record in a database table?
6.Which data type would you use to store a person's name?
7.What is a Primary Key?
8.Which view is used to modify the structure of a table?
9.What is the purpose of a Form in Access?
10.What is the purpose of a Query in Access?
11.What is a Report in Access used for?
12.Which data type is used to store monetary values?
13.What does the AutoNumber data type do?
14.How do you add a new record in Datasheet View?
15.What is the Navigation Pane in Access?
16.Which keyboard shortcut saves the current object in Access?
17.What is the Yes/No data type used for?
18.What is a database template in Access?
19.How do you delete a record in Datasheet View?
20.What is the Attachment data type used for?
21.What is Datasheet View?
22.What happens when you compact and repair a database?
23.Which data type would you use for a field that stores dates?
24.What is the maximum number of characters that Short Text can hold?
25.What is a blank database?
26.How do you rename a table in Access?
27.What is the Long Text data type used for?
28.What does the OLE Object data type store?
29.Which symbol indicates a Primary Key field in Design View?
30.What is the purpose of field properties in Access?
31.What is a Select Query?
32.What is a one-to-many relationship?
33.What is referential integrity?
34.What is a Foreign Key?
35.What is a Parameter Query?
36.What does the asterisk (*) wildcard represent in a query?
37.What does the question mark (?) wildcard represent in a query?
38.What is an Action Query?
39.What is an Update Query used for?
40.What is an Append Query?
41.What is a Make-Table Query?
42.What is a Crosstab Query?
43.What is an Inner Join?
44.What is a Left Outer Join?
45.What is a calculated field in a query?
46.What is the purpose of the GROUP BY clause in a query?
47.Which aggregate function counts the number of records?
48.What is a subform?
49.What is the Relationships window used for?
50.What is Cascade Update Related Fields?
51.What is Cascade Delete Related Records?
52.What is an Input Mask?
53.What is a Validation Rule?
54.What is the difference between Form View and Layout View?
55.What is a Lookup field?
56.What is the SQL View in queries?
57.What is the HAVING clause used for?
58.What is a many-to-many relationship?
59.What is a junction table?
60.What is the BETWEEN operator used for in queries?