Quiz 4 Flashcards
(30 cards)
Which of the following is NOT a guideline for adding fields to a database table?
Link tables using foreign keys
An example of a ________ field is a field for sales associates’ bonus–.05 multiplied by quarterly sales.
Calculated
Storing the date of birth of clinic patients should be a ________ field
Constant
wo or more tables that contain duplicate data are an example of:
Data redundancy
Which of the following is NOT a way to create a table in Access
Typing a field name in a row in design view
Which of the following is FALSE about CamelCase notation
Field names should include spaces when the name is more than one word.
The value in a field with the ________ data type will be automatically increased each time a new record is entered
Auto number
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 a Web page. Sarah should apply a(n) ________ type.
Hyperlink
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. Jose should apply a(n) ________ data type.
OLE Object
The maximum size of the ________ data type is ________ characters
Short text 255
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?
Default Value
Referential integrity should be enforced in a database with related tables because it
helps ensure invalid data is not entered into a table.
The ________ group on the External Data tab has options that you can use to send a portion of a database to other applications.
Export
Which of the following statements is TRUE about how Access and Excel share data?
Access can import data from Excel, and export data to Excel.
If data from an Excel worksheet is imported into Access and no column headings exist, the data will import using
Field1, Field2, Field3, etc.
Which of the following statements best describes a one-to-many relationship between two tables?
A primary key in the first table matches several foreign keys in the second table.
Which of the following is NOT a type of relationship available in Access 2013?
Many to one
Which statement accurately describes the function of a query?
Queries allow a user to ask questions about data and then provide answers by providing subsets or summaries of data.
A ________ query is a type of query that displays on records that match criteria entered in Query Design view.
Select
Which of the following is TRUE regarding the running of queries and the size of a database?
The queries in larger databases may take longer to run than queries in smaller databases.
In a query, which of the following statements is TRUE regarding delimiters in the criterion of a field?
Number data types that use plain digits require no delimiter.
Which of the following statements is TRUE about data types and delimiters?
Different data types require different delimiters.
A(n) ________ operator, such as the greater than or less than symbol, can be used in a query criterion to limits the results produced by the query.
Comparison
Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12, 2010?
12/12/2010
