WorksheetsPython with Data Science Set 1
Total questions: 20
Worksheet time: 10mins
What is the default file extension for a Microsoft Access database file?
.xls
.doc
.accdb
.mdb
Which data type should be used to store large text in Access?
Short Text
Long Text
Memo
Number
Which of the following is not a valid Access data type?
Currency
Date/ Time
OLE Object
What type of data is stored using the “AutoNumber” datatype?
Random Characters
Sequential Numbers
Currency Values
Yes/ No Data
Which data type allows you to store a true/false value?
Boolean
Yes/ No
Date/ Time
Short Text
What is a primary key in a table?
A field that allows duplicate values
A unique identifier for each record
A foreign key
A field that contains the largest number
In Microsoft Access, which of the following is used to link two tables together?
Query
Foreign Key
Primary Key
Form
Which view allows you to modify the structure of a table in Access?
Datasheet View
Design View
Layout View
Print View
What does setting a field as "Required" do in a table?
Ensures the field accepts only unique values
Prevents the field from accepting null values
Converts the field into a primary key
Automatically generates values
Which of the following field properties defines the maximum amount of characters in a Short Text field?
Field Size
Data Type
Indexed
Default Value
What is the purpose of a query in Microsoft Access?
To input data into a database
To print data in a report
To search for specific data in the database
To edit the table structure
Which query type allows you to retrieve data from multiple tables simultaneously?
Crosstab Query
Append Query
Update Query
Select Query
What does a parameter query do?
Allows input from the user when the query is run
Summarizes data from different tables
Sorts data automatically
Deletes data from a table
Which of the following is a feature of an action query?
Retrieves data
Edits data structure
Deletes or updates data in a table
Filters data
A query can use criteria to:
Link tables together
Sort the output of a query
Filter the data returned
Automatically update a form
What is the primary purpose of a form in Access?
To store data
To display data for printing
To allow users to enter and modify data
To create reports
Which view allows you to design and modify the structure of a form?
Layout View
Form View
Design View
Report View
What is the main function of a report in Access?
To input data into the database
To query the database
To summarize and print data
To delete records
Which view is used to see what the report will look like when printed?
Print Preview
Layout View
Datasheet View
Design View
What is a macro in Microsoft Access?
A code used to create tables
A series of actions that automate tasks
A set of data types for tables
A tool used for generating reports
