Database Creation and Query Quiz

Which application is used to create and manage databases?

• Microsoft Word

• Microsoft Excel

• Microsoft Access

• Google Sheets

Which view is used to create Fields and set Data Types?

• Datasheet View

• Design View

• Form View

• Layout View

What data type should "MovieID" have so the computer generates the next value?

• Short Text

• Date/Time

• AutoNumber

• Number

Which field in the JamesBond database is mostly likely to use the "Date/Time" data type?

• MovieTitle

• ReleaseDate

• MainActor

• Rating

What is the data type for the "Rating" field in the JamesBond database?

• Short Text

• Date/Time

• AutoNumber

• Number

Why are the settings in the table Design View page important?

• To make the table look nice

• To ensure the data is stored or formatted properly

• To add more fields to the table

• To delete unnecessary fields

What should you do after making changes in the table Design View?

• Close the program

• Print the table

• Change back to "datasheet view"

• Delete the table

What are the two main methods to add data to a database?

• Manual Entry and Exporting Data

• Manual Entry and Importing Data

• Importing Data and Exporting Data

• Manual Entry and Copying Data

Which method of adding data to a database involves typing directly into the database?

• Importing Data

• Exporting Data

• Manual Entry

• Copying Data

What is a disadvantage of manual entry?

• It is useful for entering larger selections of data.

• It is very fast and efficient.

• It can take quite a lot of time and it's easy to make mistakes.

• It is done by copying data from a different source.