Exam 1: Access 1: Creating Advanced Queries and Enhancing Table Design

To avoid the display of a security warning when opening a database, place the database ____.

Case Based Critical Thinking Questions Case 5-2 Marie works for a busy pediatrician's office. The practice has a sophisticated database for all records and information that pertain to the practice. The doctor for whom she works is participating in an academic study, and she needs a report that lists the patient's name, date of birth, and the names of parents or guardians. The doctor would like to see the patient's full name in the format Lastname, Firstname even though they are separate fields in the database. She would also like to see the data for the fields Mother, Father, and Guardian, regardless of whether or not data is actually entered in those fields. Based on the doctor's requirements for the report, Marie must create a query on which to base the report. Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [LastName] ", " [FirstName] . This expression is an example of ____.

A summarized record for each unique field value is displayed in a crosstab query.

When creating an input mask, the ____ input mask character is used to indicate that the following character will be a literal display of that character.

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

A nonnull field is a field that contains any data at all, including a single space.

The ____________________ aggregate function returns the average of the field values.

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

When creating a find unmatched query using the query wizard, Matching fields will be joined automatically if a ____________________ is already defined between the two selected objects.

Case Based Critical Thinking Questions Case 5-1 Carlos has developed a database for his organic farm.The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants. Carlos needs to decide which cooking demonstrations to offer next month. He would like to offer his five most popular demonstrations. Which method would be best for Carlos to use to find this information from his database?

A Social Security Number which appears in the format 123-456-7891 is an example of a(n)____.

A select query that finds duplicate records in a table or query is a ____________________ query.

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

When using the IIF function, each part of the function is separated by a colon . ____________________

When using the IIf function, a condition is tested, and if the condition is false , the first value of the condition is returned by the function. ____________________

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

The standard naming convention prefix tag for a query used to identify the object type is ____.