Font size
WorksheetsMS Access
Total questions: 15
Worksheet time: 16mins
is a relational database management system (RDBMS) that's part of the Microsoft Office suite, designed for creating and managing databases, especially for smaller-scale projects.
MS Access allows users to organize, store, and manipulate data efficiently, without extensive programming knowledge.
TRUE
FALSE
One main task of MS Access is to set up rules and restrictions over the type of data that can
be entered into the database.
TRUE
FALSE
One main task of MS Access is not to create forms to allow non-technical users to enter data,
search the database, and perform other tasks.
TRUE
FALSE
What are the four (4) steps in using Microsoft Access?
Pick four below.
Database Creation
Data Manipulation
Data Input
Query
Report
Which of the following step of Microsoft Access will this fall - After your database is created, the data of
every business day can be entered into the Access database.
Database Creation
Data Input
Report
Query
Which of the following step of Microsoft Access will this fall - This is a fancy term to basically describe the
process of retrieving information from the database.
Database Creation
Query
Report
Data Input
This type of data in Ms Access refers to date and time values for the years 100
through 9999.
Currency
Short Text
Date/Time
Date
This type of data of Ms Access refers to text or combinations of text and numbers,
including numbers that do not require calculating (e.g. phone numbers).
Numbers
Currency
Short Text
Auto Number
This type of data of Ms Access refers to lengthy text or combinations of text and
numbers.
Short Text
Auto Number
Long Text
Currency
This type of data of Ms Access refers to a unique sequential (incremented by 1) number or
random number assigned by Microsoft Access whenever a new record is added to a table.
Auto Number
Short Text
ID Number
Number
In Ms Access, it helps you combine data from two different tables. Each __________ consists of fields in two tables with corresponding data.
Query
Report
Connection
Relationship
MS Access uses table relationships to join tables when you need to use
them in a database object.
TRUE
FALSE
It is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.
Report
Data
Query
Relationship
This type of data in Ms Access refers to numeric data used in mathematical
calculations.
Number
Short Text
Long Text
Currency
