A relational database is ________________.

Group of answer choices

2 or more databases that share data points with each other

2 databases with the same primary key

a database with relevant content

2 databases in the same Access project.

Flag question: Question 2

Question 210 pts

What field type would be the best for a integer based primary key?

Group of answer choices

Autonumber

Number

Short text

Long number

Flag question: Question 3

Question 310 pts

When naming a table what prefix would you use?

Group of answer choices

tbl

Table

dataSet

Mr.

Flag question: Question 4

Question 450 pts

Match the field types to the value they store.

Group of answer choices

Short text

[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.

Yes/No

[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.

Autonumber

[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.

Number

[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.

Date/Time

[ Choose ] A numeric value. Any integer value between -1024 to 1023 A unique number which is automatically generated for every record. A string of alphabetical characters ranging from 0 to 2.4 billion A value that is either yes or no. A number generated based off of other data in the record An alphanumeric value up to 255 characters A date/time value.

Flag question: Question 5

Question 510 pts

Which of the following field names matches the naming conventions for Access?

Group of answer choices

LastName

last_name

lastName

lastname

Flag question: Question 6

Question 610 pts

Why are primary keys used in data database management?

Group of answer choices

To maintain data integrity.

To save hard drive space.

As a checksum.

To verify the database is working properly.