ITEC36 MIDTERM Flashcards
It is a DBMS from Microsoft.
Microsoft Access
What is the file extension of MS Access 2007 above version of Microsoft?
.accdb
It provides all the data definition, data
manipulation, and data control features
that you need to manage large volumes of
data.
MS Access
It is an object that is used to define and store data.
Tables
It is an object that provides a custom view of data from one or more tables.
Query
It is a way of searching for and compiling data from one or more tables.
Queries
It is an object used for data input or display of control of application execution.
Form
It is an object designed for formatting, calculating, printing, and summarizing selected data.
Report
This object is a structured definition of one or more actions that you want Access to perform in response to a defined event.
Macro
It is an object containing custom procedures that you code using Visual Basic.
Module
It is used to set the data types, insert or delete fields, and set the Primary Key.
Design View
It is used to enter and view the data for the records.
Datasheet View
It is an element of a table that contains a specific item of information.
Data
It determines what kind of data the field can store.
Data Type
It is a alphanumeric data up to 255 characters.
Short Text
It is a data type with large amounts of alphanumeric data, sentences and paragraphs – 64,000 characters.
Long Text
It is a data type used for numeric data.
Number
It is a data type used for monetary values.
Currency
It is a data type used for unique value generated by Access for each new record.
AutoNumber
It is a data type used for date and time.
Date/Time
It is a data type used to display pictures, graphs, or other ActiveX objects from another Windows-based application.
OLE Object
It is a data type used to link address to a document or file on the Internet.
Hyperlink
It is a data type used to attach files such as pictures, documents, spreadsheets, or charts.
Attachment
It is a data type used to create an expression that uses data from one or more fields.
Calculated
It generally refers to the suppression of details of data organization and storage.
Data Abstraction
It is a collection of concepts that can be used to describe the structure of a database.
Data Model
It is a category of data models that uses concepts such as entities, attributes, and relationships.
High-level or Conceptual Data Model
It represents a real-world object or concept.
Entity
It represents some property of interest that further describes an entity.
Attribute
It represents an association among the entities.
Relationship
It provides concepts that describe the details of how data is stored on the computer storage media.
Low-level or Physical Data Model
It provides concepts that may be easily understood by end users but that are not too far removed from the way data is organized in computer storage.
Implementation or Representational Data Model
It defines the statements to implement the database schema.
DDL (Data Definition Language)
It provides operations that handle user requests.
DML (Data Manipulation Language)
It is a user interface which allows for the ability to input queries to a database without using the query language itself.
DBMS Interface
it is a collective system of components that consist of software, hardware, people, techniques and data.
Database Environment
It is a type of database architecture which includes the DBMS is the only entity where the user directly sits on the DBMS and uses it.
Tier 1
It is a type or database architecture where programmers access the DBMS by means of an application.
Tier 2
It is most widely used architecture to design a DBMS.
Tier 3
It is a conceptual model that represents the information structure of a problem domain in terms of entities and relationships.
ER Model
What is the symbol for entity in entity relationship diagram?
Rectangle
What is the symbol for attribute in entity relationship diagram?
Eclipse
What is the symbol for relationship in entity relationship diagram?
Diamond
It is a type of attribute which cannot be divided further.
Simple Attribute
It is a type of attribute that are made of more than one simple attribute.
Composite Attribute
It is a type of attribute that contain more than one values.
Multi-value Attribute
It is a type of attributes that do not exist in the physical database.
Derived Attribute
This are the set of statements, that are used to define and manipulate a database.
Database Languages
It represents the logical configuration of all part of a relational database. It can exist both as visual representation and as a set of formulas known as integrity constraints that govern a database.
Database Schema
It refers to the content of a database at a moment in time.
Database State or Snapshot
