ADMN 410 - MIS Exam 2 |Questions Solved
100% Correct| Verified Solutions
Database - ANSWER collection of data organized as meaningful information that can
be accessed, managed, stored, queried, sorted, and reported.
DBMS (Database Management System) - ANSWER a software system that provides the
tools needed to create, maintain, and use a database.
Access - ANSWER is the database management system included in the Office
2013 Professional suite and Office 2013 Professional Academic suite.
Table - ANSWER the object in which data, such as a person's name or product number is
stored.
Field - ANSWER columns display this, the smallest data element of a table
Record - ANSWER Each row in a table contains this, a complete set of all the fields
(data elements) about one person, place, event, or concept.
Form - ANSWER an object that gives a user a way of entering and modifying data
in databases.
Query - ANSWER is a question that you ask about the data in your database. For
example, how many of our customers live in Boston? the answer is shown in the
query results.
Report - ANSWER contains professional-looking formatted information from
underlying tables or queries.
, Datasheet View - ANSWER grid containing fields (columns) and records (rows), similar to
an excel spreadsheet.
Design View - ANSWER gives you a detailed view of the table's structure and is used to
create and modify a table's design by specifying the fields it will contain, the fields' data
types, and their associated properties.
Field properties - ANSWER define the characteristics of the fields in more detail.
Primary Key - ANSWER is the field (or combination of fields) that uniquely identifies
each record in the table.
Relationship - ANSWER is a connection between two tables using a field that is
common to the two tables.
Normalization - ANSWER grouping data into the correct tables.
Foreign Key - ANSWER is a field in one table that is also the primary key of
another table.
Enforce Referential Integrity - ANSWER access ensures that data cannot be entered
into a related table unless it first exists in the primary table.
One-to-many relationship - ANSWER established when the primary key value in
the primary table can match many of the foreign key values in the related table.
Queries (SQL Statements) - ANSWER can also insert, update, and delete data
100% Correct| Verified Solutions
Database - ANSWER collection of data organized as meaningful information that can
be accessed, managed, stored, queried, sorted, and reported.
DBMS (Database Management System) - ANSWER a software system that provides the
tools needed to create, maintain, and use a database.
Access - ANSWER is the database management system included in the Office
2013 Professional suite and Office 2013 Professional Academic suite.
Table - ANSWER the object in which data, such as a person's name or product number is
stored.
Field - ANSWER columns display this, the smallest data element of a table
Record - ANSWER Each row in a table contains this, a complete set of all the fields
(data elements) about one person, place, event, or concept.
Form - ANSWER an object that gives a user a way of entering and modifying data
in databases.
Query - ANSWER is a question that you ask about the data in your database. For
example, how many of our customers live in Boston? the answer is shown in the
query results.
Report - ANSWER contains professional-looking formatted information from
underlying tables or queries.
, Datasheet View - ANSWER grid containing fields (columns) and records (rows), similar to
an excel spreadsheet.
Design View - ANSWER gives you a detailed view of the table's structure and is used to
create and modify a table's design by specifying the fields it will contain, the fields' data
types, and their associated properties.
Field properties - ANSWER define the characteristics of the fields in more detail.
Primary Key - ANSWER is the field (or combination of fields) that uniquely identifies
each record in the table.
Relationship - ANSWER is a connection between two tables using a field that is
common to the two tables.
Normalization - ANSWER grouping data into the correct tables.
Foreign Key - ANSWER is a field in one table that is also the primary key of
another table.
Enforce Referential Integrity - ANSWER access ensures that data cannot be entered
into a related table unless it first exists in the primary table.
One-to-many relationship - ANSWER established when the primary key value in
the primary table can match many of the foreign key values in the related table.
Queries (SQL Statements) - ANSWER can also insert, update, and delete data
