MS ACCESS 10 Flashcards
What is database
It is an combined collection of logical related records in the form of tables.
What is dbms?
It is a set of computer program that controls the creation, maintenance and the use of database in the computer.
What is database objects?
These are various components of ms access
What is data type
It is format in which the data is accepted
FIELD
It is a column arranged vertically in a table that stores information of the same type
Form
It is a customised screen for viewing, entering, modifying and deleting data in a table or query
Primary key
It uniquely identifies each record in the table.
Query
It is a question pertaining to data with a specific answer to it
Record
It includes complete information pertaining to a particular record arranged horizontally in a table.
Report
It is the representation of data in a printed format
Table
It is a collection of related information in the form of rows and columns.
What is Microsoft access
Microsoft access 2010 is a database program used for storing information in the form of tables, queries, forms, reports, etc.
How is DBMS USEFUL?
A DBMS is useful in the following aspects: reduces data redundancy, facilitates file sharing, controls data insecurity, enforces standards.
How can a new database be created?
A new database can be created either using a blank database or sample templates.
How can tables be created
Tables can be created either in data sheet view or design view in MS ACCESS 2010.