Podcast
Questions and Answers
What does the term 'field' refer to in a database table?
What does the term 'field' refer to in a database table?
- Size of the table
- Name of the table
- Horizontal row of the table
- Vertical column of the table (correct)
‘DBMS’ stands for:
‘DBMS’ stands for:
- Drawing Board Management Software
- Dividend Based Marking System
- Data Base Management System (correct)
- Data Base Marking Software.
In a database table, what does a 'record' represent?
In a database table, what does a 'record' represent?
- Vertical column of the table
- Horizontal row of the table (correct)
- Name of the table
- Size of the table
What do 'Key fields' represent in the context of relationships between tables?
What do 'Key fields' represent in the context of relationships between tables?
What is required concerning data existence in a Primary key field?
What is required concerning data existence in a Primary key field?
What is the purpose of SQL in database management?
What is the purpose of SQL in database management?
What is the default file extension for MS Access (2007) files?
What is the default file extension for MS Access (2007) files?
Which of the following statements about secondary key fields is correct?
Which of the following statements about secondary key fields is correct?
What does the acronym SQL stand for?
What does the acronym SQL stand for?
In Microsoft Access (2007), what is the default file extension?
In Microsoft Access (2007), what is the default file extension?
What is the purpose of wizards in Microsoft Access?
What is the purpose of wizards in Microsoft Access?
In the context of Access tables, what does the term 'join line' refer to?
In the context of Access tables, what does the term 'join line' refer to?
Study Notes
Database Management System (DBMS) Basics
- DBMS stands for Data Base Management System.
Database Software
- MS Access is a Data Base Management Software.
Database Table Components
- A 'field' in a database table refers to a vertical column of the table.
- A 'record' in a database table refers to a horizontal row of the table.
Database Relationships
- Common fields used in a relationship between tables are called Key fields.
Primary and Secondary Keys
- Data in a Primary key field is required and must be unique.
- Data in a secondary key field is not necessarily required.
SQL
- SQL stands for Structured Query Language.
MS Access File Extension
- The default extension of an MS Access (2007) file is not specified in the text.
MS Access Wizards
- Wizards in MS Access are tools for simplifying the programme usage.
Database Table Relationships
- A 'Join line' in the context of Access Tables means a graphical representation of the relationship between tables.
Data Retrieval
- To retrieve select data meeting a specified criteria from two different tables of an Access database, we may make use of a Query.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of Database Management Systems (DBMS) in accounting with this exercise containing multiple choice questions. Questions cover topics such as DBMS definition, MS Access, and database table terminology.