MS-Access Database Management System Overview Quiz

Study Flashcards Play Quiz

Questions and Answers

What is the definition of data?

A gathered body of facts

What is the primary purpose of a database?

To offer an organized mechanism for storing and retrieving related information

What does a database contain?

Any collection of data items in digital form

What is the definition of knowledge?

Purposefully used information Signup and view all the answers

What is the role of a database in relation to information?

Stores and retrieves related information Signup and view all the answers

In the context of a university database, what are known as entities?

Lecturers and students Signup and view all the answers

What is a database file?

The file containing the entire database and saved to the hard drive Signup and view all the answers

What is the primary advantage of a database system?

High speed of retrieval and fast online Signup and view all the answers

What is Microsoft Access?

A relational database management system (DBMS) Signup and view all the answers

Why might MS Access be chosen over SPSS and Excel?

Best for long-term data storage and/or data sharing Signup and view all the answers

What are the reasons for choosing MS Access over other DBMS?

Cheap and readily available, includes front-end tools for rapid application development Signup and view all the answers

What is the fixed length size for a date in terms of bytes?

4 bytes Signup and view all the answers

What is the main disadvantage of database systems?

Complex, difficult, and time-consuming to design Signup and view all the answers

What does a database system allow for?

The ability to operate on different data structures Signup and view all the answers

What are examples of DBMS applications?

MySQL - SQL Server (Microsoft) - DB2 (IBM) - Informix Signup and view all the answers

What is the role of MS Access?

Relational database management system (DBMS or RDBMS) Signup and view all the answers

What is the primary purpose of a database?

Storing and retrieving related information Signup and view all the answers

What is the difference between data and information?

Data is unorganized, whereas information is organized Signup and view all the answers

What does a database contain?

Anything that can be stored on a computer in binary form Signup and view all the answers

In the context of a university database, what are known as entities?

Courses and departments Signup and view all the answers

What is the role of a database in relation to information?

Storing and organizing related information Signup and view all the answers

What is the definition of knowledge?

Information evaluated and organized purposefully Signup and view all the answers

What is the file extension for database files in Microsoft Access?

.mdb Signup and view all the answers

What is a primary advantage of using a database system?

High speed of retrieval and fast online Signup and view all the answers

What is a primary disadvantage of database systems?

Substantial hardware and software start-up costs Signup and view all the answers

Which type of data is fixed length in terms of bytes?

Integer Signup and view all the answers

What is Microsoft Access primarily used for?

Long-term data storage and/or data sharing Signup and view all the answers

What is the role of Microsoft Access in relation to physical data and user application queries?

Interface provider Signup and view all the answers

What makes Microsoft Access a good prototype environment?

Easy to use interface Signup and view all the answers

Why might Microsoft Access be chosen over SPSS and Excel?

For long-term data storage and/or data sharing Signup and view all the answers

What is the size in bytes for the string 'Mohammed Ahmed Ali'?

$18 bytes Signup and view all the answers

What is the number of bytes for a date?

$4 bytes Signup and view all the answers

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

MS-Access Database Management System Overview Quiz

Access to a Library of 520,000+ Quizzes & Flashcards

Questions and Answers

What is the definition of data?

What is the primary purpose of a database?

What does a database contain?

What is the definition of knowledge?

What is the role of a database in relation to information?

In the context of a university database, what are known as entities?

What is a database file?

What is the primary advantage of a database system?

What is Microsoft Access?

Why might MS Access be chosen over SPSS and Excel?

What are the reasons for choosing MS Access over other DBMS?

What is the fixed length size for a date in terms of bytes?

What is the main disadvantage of database systems?

What does a database system allow for?

What are examples of DBMS applications?

What is the role of MS Access?

What is the primary purpose of a database?

What is the difference between data and information?

What does a database contain?

In the context of a university database, what are known as entities?

What is the role of a database in relation to information?

What is the definition of knowledge?

What is the file extension for database files in Microsoft Access?

What is a primary advantage of using a database system?

What is a primary disadvantage of database systems?

Which type of data is fixed length in terms of bytes?

What is Microsoft Access primarily used for?

What is the role of Microsoft Access in relation to physical data and user application queries?

What makes Microsoft Access a good prototype environment?

Why might Microsoft Access be chosen over SPSS and Excel?

What is the size in bytes for the string 'Mohammed Ahmed Ali'?

What is the number of bytes for a date?

Studying That Suits You

More Quizzes Like This

MS Access: Introduction to Database Tables

Mastering MS Access: Efficient Searching and Data Retrieval

MS Access: Reports and Macros

MS Access Database Management