Rhianna
1.What is Microsoft Access used for
A. Writing documents
B. Used to create spreadsheets
C. Used to create Databases
D. Used to create and present Powerpoints
C. Used to create Databases
6. Name the Data Type in Microsoft Access.
Auto Number, Memo, Currency.
11. A DBMS is a selection of programs that allows the user to input, arrange, and choose data from a database.
A. Facts
B. Opinion
A. Facts
16. What is a Data Field?
A. a column of data values.
B. is a set of data values, of the same data type, in a table.
C. a field of numbers.
D. None of the above
B. is a set of data values, of the same data type, in a table.
2. Which Does NOT belong in the set.
A. External Data
B.Table
C.Page Layout
D. Create
C.Page Layout
7. In Microsoft Access you have intersections. What is the intersection of a row and a column in MS A?
A cell
12. A primary key is also known
A. Primary Keyboards
B. Primary Board
C. Super Keys
D. Keys
A. Primary Keyboards
17. Name three disadvantages of using a Database.
Cost
Security
Complexity
3. Which is one has the correct information
A. Database is an organized collection of data held in a computer, especially one that is accessible in various ways.
B. Microsoft Access was originally created in the year of 2015.
C. There are only three versions of Microsoft Access
A. Database is an organized collection of data held in a computer, especially one that is accessible in various ways.
8. Which of the following is not a type of MS Access database object?
A. Table
B. Form
C. Worksheet
D. Modules
C. Worksheet
13. A database fields is referred to as
A. columns
B. an attribute
C. Both A and B
D. only a
C. Both A and B
18. What is a Data Management System?
A. is a request of data results, and action on data.
B. A DBMS is a selection of programs that allows
the user to input, arrange, and choose data from a database.
C. it is a set of data values , of the same data types.
D. is the collection of data held in a computer .
B. A DBMS is a selection of programs that allows
the user to input, arrange, and choose data from a database.
4. T-SQL expands on the SQL standard to include Procedural programming and local variables etc.
A. True
B. False
A. True
9. What enable the user to automatically insert numbers into a sequential or random number?
Auto number
14. Which one is the disadvantages of a database.
A. Significant time savings
B. More handy information
C. Capacity to connect data
D. All of them
All of those are advantages of database.Their NO disadvantages.
19. Explain More handy information which is an advantage of database.
More handy information – Creating and running a query can be done easily to seek
for distinct answer or record from the database.
5. Name one (1) function of the query.
1.It makes it easier to view data in your access database.
2. Add data to your access database.
3.Change data to your database.
4. Delete data in your access database.
5. You can use a query to answer a simple question, to perform calculations, to combine data from different tables.
10. A ............... is a group of data saved in a table.
A. Record
B. Field
C. Cell
D. Table
A. Record
15. Name two (2) items that a database consists of.
Fields, Records, Data Types,
Tables, Queries, Primary Keys
20. What is table in Microsoft Access?
A table is a named relational database data set that is arranged by rows and columns.