RDBMS midterms Flashcards
is a collection of data that is stored in a computer system.
Database
Databases allow their users to
Enter
Access
Analyze
Stores its lists of data in tables, which allow you to store even more detailed information.
Database
The thing that really sets databases apart from any other way of storing data is
Connectivity
is able to understand how lists and the objects within them relate to one another
Relational Database
Databases in Access are composed of four objects:
tables
queries
forms
reports.
single piece of information from a record.
Field
a set of fields.
Database Record
unit of information
Record
unique identifier for each record
Primary key
are used for entering, modifying, and viewing records.
Forms
are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database.
Queries
offer you the ability to present your data in print.
Reports