Deck 5: Workshop 5: Advanced Tables

Question 1

Which of the following is NOT true about indexes?

A)Access automatically creates all indexes for your tables.
B)Indexes are created and used to increase performance.
C)An index in Access is similar to an index in a book.
D)By creating an index for a field or fields in a table,Access can quickly locate all the records that contain specific values for those fields without having to read through each record in the table.

Answer 1

A

Question 2

Which of the following is NOT a way to ensure data is entered properly?

A)Be sure to set constraints or rules on as many fields as possible.This will ensure that users are entering data the way you want it to be entered.
B)Restrict what data can be entered into a field that users have to enter exactly what you want them to or they will not be allowed to enter any data.
C)Verify that all restrictions will adequately accept every variant of accurate data.You do not want valid data excluded.
D)Remember that garbage in leads to garbage out.

Answer 2

B

Question 3

Which of the following is NOT true when considering which fields to index?

A)Indexes can slow down searches and queries,but they can accelerate performance when you add or update data.
B)You cannot index a field whose data type is an OLE Object,Hyperlink,Memo,or Attachment.
C)You should index a field when the data is generally unique and when there are more different entries than duplicate entries.
D)You should index a field when you plan to frequently search or sort it.

Answer 3

A

Question 4

Many databases contain a large amount of data.________ are created and used to increase performance.

A)Input masks
B)Indexes
C)Validation rules
D)Captions

Question 5

________ is/are used to verify that the correct value is entered in a field and prevents the user from leaving the current field until the problem is fixed.

A)Input masks
B)Data validation text
C)Data validation rules
D)Field validation rules

Question 6

A(n)________ stores the location of your records based on the field or fields that you select.

A)data type
B)format
C)index
D)property

Question 7

You can have Access check data as it is entered to help improve its accuracy and consistency by using ________.

A)input masks
B)custom formatting
C)data validation rules
D)data validation text

Question 8

Which of the following is NOT true about the Required data property?

A)If the Required property is set to Yes,and a user attempts to leave a field blank or removes a value from a required field when trying to save the record,Access will display an error message.
B)You can require that a value be entered in a field for all new records only if existing records have values in the field.
C)The Required property applies only to new records,not existing ones.
D)Data within Access fields can be required,ensuring that necessary information cannot be omitted from the database,either accidentally or deliberately.

Question 9

Which of the following is TRUE about input masks?

A)An input mask is one of the least common methods of controlling the way data is entered.
B)An input mask defines a pattern for how some data will be entered in a field.
C)You can manually create an input mask and use special characters to require part of the data to be entered,while other parts of the field are optional.
D)An input mask maximizes the likelihood that people will omit information or enter the wrong data by mistake.

Question 10

Custom number formats can have one to four sections with ________ separating each section.

A)colons
B)quotation marks
C)semicolons
D)forward slash

Question 11

You can use the ________ to customize the way numbers,dates,times,and text are displayed and printed by using predefined formats or custom formats.

A)Format property
B)Data Type property
C)single-field index
D)multivalued-field index

Question 12

When entering a validation rule,you need to begin an expression with ________.

A)an equals (=)sign
B)a colon (:)
C)a semicolon (;)
D)nothing

Question 13

You can use the ________ property in a field,ensuring that the field is not null.

A)Input Mask
B)Custom Input Mask
C)Caption
D)Required

Question 14

If you create a(n)________,Access will not let you enter a new value in the field if that value is already entered in the same field within another record.

A)custom format
B)input mask
C)single-field index
D)multiple-field index

Question 15

A(n)________ is like an alias.Once this property is established,every object you create will display this instead of the field name.

A)input mask
B)validation rule
C)field format
D)caption

Question 16

Which of the following is NOT true when defining multiple properties on the same field?

A)The Format property affects how the data is both displayed and stored.
B)If you save an input mask,the input mask is ignored when you define a format in the field's Format property.
C)The data in the table does not change,regardless of how you define the Format property.
D)When defining an input mask that differs from the Format property,the Format property takes precedence when the data is displayed.

Question 17

The Input Mask Wizard can be used in the table's ________ view.

A)Datasheet
B)Design
C)Print Preview
D)Both Datasheet and Design

Question 18

Which of the following is NOT a characteristic of using captions?

A)Once captions are established,they cannot be changed,thus creating problems downstream.
B)Once this property is established,every object you create will display what the caption is instead of the field name.
C)You may be working with a database that someone else created-someone who did not understand the principles of good database design-thus requiring you to enter a caption.
D)Sometimes the field names may not be what you want to display on other database objects.

Question 19

Which of the following is NOT true in regard to data validation rules?

A)Data that does not follow data validation rules can negatively affect business processes.
B)Once you establish validation rules,they will be accurate for the life-time of the database.Thus,you do not need to periodically evaluate data validation rules.
C)Errors in data validation can lead to data corruption or security vulnerability.
D)The goal of using data validation rules is to force users entering data to safeguard the validity of the data.

Question 20

A(n)________ controls the way data is entered.

A)index
B)field format
C)filter
D)input mask

Question 21

By using the ________,you can divide the table created from an imported Excel spreadsheet into several tables as well as automatically create the relationships needed between them.

A)Import Wizard
B)Lookup Field Wizard
C)Table Analyzer Wizard
D)Expression Builder

Question 22

The ________ command is a common type of hyperlink that helps generate a link for sending e-mail.

A)Boolean
B)hyperlink
C)mailto
D)legacy

Question 23

Which of the following do advanced data types NOT allow for?

A)More efficient data entry.
B)Values cannot come from a table,query,or a value list.
C)It constrains what can be entered into a field,ensuring that typographical mistakes are avoided.
D)By avoiding data entry mistakes,your query results will be accurate.

Question 24

The ________ data type stores an integer that Access creates automatically as you add new records and can be categorized as sequential or random.

A)AutoNumber
B)Currency
C)Calculated
D)Number

Question 25

By creating ________,you can help improve the efficiency of the data entry process because it can display a user-friendly list that is either linked to another field in a related table or a value list.

A)lookup fields
B)calculated fields
C)attachment fields
D)hyperlink fields

Question 26

When filtering data,the ________ type could be used,which allows you to filter data in a form or datasheet.

A)Filter by Form
B)Filter by Selection
C)basic filtering
D)advanced filtering

Question 27

________ is very useful where you can view and print only the desired and required information from your database.

A)Formatting
B)Custom formatting
C)Sorting
D)Filtering

Question 28

Access adds ________ around field names to denote that the data will come from an existing field.

A)quotation marks
B)parentheses
C)square brackets
D)dollar signs

Question 29

Which of the following is NOT true about the first part of a custom Yes/No field?

A)This part contains the text to display in place of Yes,True,or On values.
B)The semicolon is used as a placeholder.
C)This section has no effect on the Yes/No data type.
D)A semicolon is required.

Question 30

Which of the following is NOT true about the third part of a custom Yes/No field?

A)This part contains the text to display in place of No,False,or Off values.
B)Custom formats can be defined with the exception of colors.
C)A semicolon is required between the second and third part.
D)This section has an effect on the Yes/No data type.

Question 31

A(n)________ is a value automatically entered into a field when a new record is created.

A)index
B)surrogate key
C)filter
D)default value

Question 32

Which of the following is NOT true about the second part of a custom Yes/No field?

A)This section has an effect on the Yes/No data type.
B)This part contains the text to display in place of Yes,True,or On values.
C)Custom formats can be defined with the exception of colors.
D)A semicolon is required between the first and second part.

Question 33

When enforcing referential integrity on fields with multiple values,you need to ensure that ________.

A)the primary key and foreign key fields have not had any data entered into them
B)the foreign key field has not had any data entered into it
C)the primary key field has not had any data entered into it
D)Referential integrity cannot be enforced on fields with multiple values

Question 34

If you use the ________ data type for pictures,a thumbnail of the image is displayed on any forms and reports built on the field.

A)OLE Object
B)Attachment
C)Document
D)Image

Question 35

When filtering data,the ________ type could be used,which displays only the rows in a table containing a value that matches a selected value in a row by filtering the Datasheet view.

A)Filter by Form
B)Filter by Selection
C)basic filtering
D)advanced filtering

Question 36

Which of the following is true regarding the AutoNumber data type?

A)A sequential AutoNumber will generate a random number that is unique to each record within the table.
B)AutoNumbers are a great method for ensuring that records are uniquely identified.
C)An AutoNumber is a field added to a table to serve as a foreign key that is unique and sequential when records are created.
D)A random AutoNumber is the most common and is the default setting in Access when selecting the AutoNumber data type.

Question 37

When using the Yes/No data type,the ________ is the default option to indicate that the option is selected.

A)-1
B)check box
C)zero
D)1

Question 38

If you create a field in a table that combines the first name and last fields from the same table,you need to use the ________.

A)Calculated data type
B)multivalued field property
C)Text data type
D)OLE Object data type

Question 39

Access can also store images inside a database field by using the ________ data type.

A)OLE Object
B)JPEG Object
C)Image Object
D)Figure Object

Question 40

Access can store e-mail addresses inside a database field by using the ________ data type.

A)E-mail
B)Attachment
C)OLE Object
D)Hyperlink

Question 41

Indexes are created and used to decrease performance.

Question 42

Data validation text prevents bad data from being entered and consequentially stored in your database.

Question 43

The Caption property helps control the way data is entered.

Question 44

Custom input masks can be customized by either changing a predefined mask or manually changing the Input Mask property.

Question 45

When creating a multiple-field index,the index name is typed on multiple lines.

Question 46

Custom formats can be customized by manually changing the Format property where you want the format applied.

Question 47

You can use the Required property to specify whether a value is required in a field,ensuring that the field is left blank,or in database terms,is null.

Question 48

A Lookup field is used to replace a number such as an ID (or other foreign key value)with something more meaningful,such as a name.

Question 49

A caption is like an alias.A caption does not change the actual field name,just the way users see it.

Question 50

When entering numbers or currency into a validation rule,do not enter symbols such as commas or a dollar sign.

Question 51

If some field values contain data with a consistent pattern,you should define an input mask.

Question 52

The Yes/No data type allows you to set the Format property to either the Yes/No,True/False,or On/Off predefined formats or to a custom format for the Yes/No data type.

Question 53

Default values can be used in all fields except AutoNumber or OLE Object data types.

Question 54

By ensuring your data is consistent and accurate,you are enhancing the usability of your data.

Question 55

A Calculated data type allows you to display the results of a calculation in a read-only field.

Question 56

After creating a Lookup Field,you need to rename the Lookup Field label because Access does not use appropriate names.

Question 57

A field's data type is the most important property because it determines what kind of data the field can store.Advanced data types allow for more efficiency in data entry.

Question 58

A default value is a value automatically entered into a field when a new record is created.

Question 59

By creating lookup fields,you can help improve the efficiency of the data entry process.

Question 60

The purpose of a multivalued field is to replace the display of a number such as an ID (or other foreign key value)with something more meaningful,such as a name.

Question 61

An ideal surrogate key is short,alpha-numeric,and never changes.

Question 62

You can attach images,spreadsheet files,documents,charts,and other types of supported files to the records in your database,much like you attach files to an e-mail message.

Question 63

You can enter different characters,such as placeholders,separators,literal characters,and colors,in the ________ of a field to create a custom format.

Question 64

A(n)________ can display a user-friendly list that is either linked to another field in a related table or a value list.

Question 65

You can create your own type of formatting,called ________.

Question 66

If you create a(n)________,Access will not let you enter a new value in the field if that value is already entered in the same field within another record.

Question 67

You can create a(n)________ index for a combination of fields with a maximum of 10 fields.

Question 68

The ________ property is like an alias.

Question 69

Be careful not to overdo ________ or you may end up blocking data that is valid,yet unanticipated.The goal is to force users entering data to safeguard the validity of the data.

Question 70

When a table contains repeating information in one or more fields,such as a city or state,you can use the Table Analyzer Wizard to move the data into related tables.This process is called normalization.

Question 71

A(n)________ controls the way data is entered.

Question 72

A(n)________ refers to fields within the same record and is used when you need to validate the values in one field against the values in another field in the same record.

Question 73

________ are created and used to increase performance.

Question 74

The ________ Principle means that inconsistent or inaccurate data leads to inconsistent or inaccurate output.

Question 75

The ________ property allows you to enter the error message when data is entered in a field that does not meet the validation rule.

Question 76

________ prevent bad data from being entered and consequentially stored in your database.

Question 77

When importing data,the Table Analyzer Wizard is unable to restructure all the imported data properly.

Question 78

A filter is a permanent display of data.If you want to filter the records on the basis of the same criteria again and again,you can just re-open the filter.

Question 79

When Access creates new tables in the Table Analyzer Wizard,it is looking for a way to maximize storage space in the analyzed table by storing data more efficiently.

Question 80

If all the field values contain data with a consistent pattern,you should define a(n)________.