/
Database Basics and Access Objects
Save to my account
Sign up
Database Basics and Access Objects
Database Basics and Access Objects
Study
1
Question
What is a database as defined in this material?
Answer
A collection of related data about a subject stored in a computer system
2
Question
What is a database package?
Answer
Software that organizes and stores related data for easy retrieval
3
Question
List some objects that can exist in a database.
Answer
Tables, Forms, Queries, Reports, Macros, Modules
4
Question
What is a table in a database?
Answer
A structure that stores records forming part of a related group
5
Question
What is a record in a table?
Answer
A group of related fields about a single entity
6
Question
What is a field in a database context?
Answer
An area reserved for a single piece of data for each record
7
Question
What is a tuple as used in databases?
Answer
A series of elements with a known number of items (a row example)
8
Question
What does data refer to in database terms?
Answer
The information stored in table fields
9
Question
What is a field definition?
Answer
Attributes describing a field (name, data type, size, description)
10
Question
What is a primary key?
Answer
An attribute that uniquely identifies each record
11
Question
What is a composite key?
Answer
A primary key made from multiple fields to ensure uniqueness
12
Question
What is a candidate key?
Answer
Any field or combination of fields that could serve as a primary key
13
Question
What is a foreign key?
Answer
A key that is a primary key in a different table to link tables
14
Question
What data type stores numbers only?
Answer
Number
15
Question
What data type stores text and numbers as text?
Answer
Text
16
Question
What data type is used for dates and times?
Answer
Date/Time
17
Question
What data type stores monetary values?
Answer
Currency
18
Question
What does a Yes/No data type create in a field?
Answer
A checkbox indicating yes when selected
19
Question
What is a one-to-many relationship?
Answer
One record in a table linked to many records in another table
20
Question
What is a many-to-many relationship?
Answer
Many records in the primary table linked to many in another via a linking entity
21
Question
What is a one-to-one relationship?
Answer
One record in a primary table linked to exactly one in another table
22
Question
What is a query in database terms?
Answer
An instruction to find and return a subset of data
23
Question
What is a Select Query used for?
Answer
To find and display a subset of data
24
Question
What is a Delete Query used for?
Answer
To delete a record or set of records
25
Question
What is an Update Query used for?
Answer
To edit or update data in a group of records
26
Question
What is the purpose of a database?
Answer
To store related data about a subject in an organized way
27
Question
What are the core objects used to interact with data in Access?
Answer
Tables, Forms, Queries, Reports
28
Question
What is the relationship between a record and a field?
Answer
A record is composed of related fields
29
Question
What is the purpose of a Form Wizard?
Answer
To create a data entry form quickly
30
Question
Why is a primary key important?
Answer
Ensures each record can be uniquely identified