Exploring Microsoft Office

Computing

Quiz 2 :
Access: Presentation Development

Quiz 2 :
Access: Presentation Development

Showing 1 - 20 of 97
Next Quiz
arrow
When designing a database, all of the following statements are true EXCEPT:
Free
Multiple Choice
Answer:

Answer:

B

arrow
Which statement accurately describes the function of a query?
Free
Multiple Choice
Answer:

Answer:

A

arrow
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?
Free
Multiple Choice
Answer:

Answer:

A

arrow
Which of the following query criteria would be used to produce results for Date / Time fields containing a date of December 12th, 2010?
Multiple Choice
Answer:
arrow
When defining a field, the field ________ property determines how much physical storage space the field requires.
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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.
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
In a query, which of the following statements is true regarding delimiters in the criterion of a field?
Multiple Choice
Answer:
arrow
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:
Multiple Choice
Answer:
arrow
Which of the following would be the best choice for a primary key?
Multiple Choice
Answer:
arrow
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:
Multiple Choice
Answer:
arrow
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:
Multiple Choice
Answer:
arrow
The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field.
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
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?
Multiple Choice
Answer:
arrow
The ________ is a special character that is used to represent one or more characters in the criterion of a query.
Multiple Choice
Answer:
arrow
In Access, a query criterion use to locate a blank field is:
Multiple Choice
Answer:
arrow
Which of the following is true regarding the running of queries and the size of a database?
Multiple Choice
Answer:
arrow
All of the following are acceptable field names EXCEPT:
Multiple Choice
Answer:
Showing 1 - 20 of 97
Next Quiz