Studied by 0 people
Looks like no one added any tags here yet for you.
Data elements that describe instances in a class, very much like fields in a database table; characteristics, properties, or adjectives that describe each class.
Using redundant servers in multiple locations to host virtual machines.
Describes the data fields in each database record such as field description, field length, field type (e.g., alphanumeric, numeric), etc.
A shared collection of logically related data for various uses.
The person responsible for the design, implementation, repair, and security of a firm’s database.
A computer program that creates, modifies, and queries the database. Specifically, the DBMS is designed to manage a database’s storage and retrieval of information.
A centralized database that collects data from throughout the firm. Commercialized information system that integrates and automates business processes across a firm’s value chain located within and across organizations.
The primary key of a table must have data values (cannot be null).
Attribute that allows database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.
Forms are utilized by users to enter data into tables and view existing records
Organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.
Macros are defined by Access users to automate processes such as opening a specific form.
Some Microsoft applications come with modules built in that will be automatically added onto Access.
Access pages allow data to be entered into the database in real time from outside of the database system.
An attribute or a combination of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table.
Query in Access is a tool used to retrieve and display data derived from records stored within the database.
The data value for a foreign key must either be null or match one of the data values that already exist in the corresponding table.
Stores information in the form of related two-dimensional tables.
are used to integrate data from one or more queries and tables to provide useful information to decision makers.
A computer language designed to retrieve data from a relational database.
Note 
Flashcard (237)