Exploring Microsoft Office

When designing a database, all of the following statements are true EXCEPT:

Which statement accurately describes the function of a query?

Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?

Which of the following query criteria would be used to produce results for Date / Time fields containing a date of December 12th, 2010?

When defining a field, the field ________ property determines how much physical storage space the field requires.

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?

Ryan needs to organize the data in a table so that it displays in a summarized format. He should use the ________ view for this purpose.

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?

In a query, which of the following statements is true regarding delimiters in the criterion of a field?

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

Which of the following would be the best choice for a primary key?

Sarah is working in a database that stores resort vacation information. She needs to design a field that will allow a user to link to an external website. The data type she should apply to this field is:

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is:

The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field.

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Marla is working in a database that stores customer purchases. She needs to find customers in the New York area that have purchased over $5000 worth of goods. Which query operator would Marla use in a query to find this information?

The ________ is a special character that is used to represent one or more characters in the criterion of a query.

In Access, a query criterion use to locate a blank field is:

Which of the following is true regarding the running of queries and the size of a database?

All of the following are acceptable field names EXCEPT: