Unit 18 - Database P1, M1
Database
Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.
MS Access is a database management system design by Microsoft. It offers user four important objects they are:
* Table
A Table is where you are organised and store data so you have to create the table before store any data. By creating table, you need to define few things, Fields name, Data type, and the Description.
* Fields Name
Fields name is the heading of column e.g. first name, last name and phone number.
* Data Type
Data type is the type of content and it decides the content can be input and the file size.
* Description
Description is use for explain what content should input to the user.
* Queries
A query is use for searching some specific record. It allow user to set conditions and then search the record which match the conditions. User also is able to make the search mix up with other table and sort the order of the result.
* Report
A Report is a summary of record. Everything you plain to print should put inside. Its purpose is for user to view information quickly and easily so display the result simply and efficiently is the main point.
* Form
Form is used for collect and edits information and transfers them to table. It is similar to application forms that allow user to fill in or delete their data easily and it also able to let user design own user interface. User can insert as much control as they like to build the user interface beautifully.
Database Features
Every database management system should have these feature to protect and ensure the data is safe and accuracy.
* Entities * Primary
Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.
MS Access is a database management system design by Microsoft. It offers user four important objects they are:
* Table
A Table is where you are organised and store data so you have to create the table before store any data. By creating table, you need to define few things, Fields name, Data type, and the Description.
* Fields Name
Fields name is the heading of column e.g. first name, last name and phone number.
* Data Type
Data type is the type of content and it decides the content can be input and the file size.
* Description
Description is use for explain what content should input to the user.
* Queries
A query is use for searching some specific record. It allow user to set conditions and then search the record which match the conditions. User also is able to make the search mix up with other table and sort the order of the result.
* Report
A Report is a summary of record. Everything you plain to print should put inside. Its purpose is for user to view information quickly and easily so display the result simply and efficiently is the main point.
* Form
Form is used for collect and edits information and transfers them to table. It is similar to application forms that allow user to fill in or delete their data easily and it also able to let user design own user interface. User can insert as much control as they like to build the user interface beautifully.
Database Features
Every database management system should have these feature to protect and ensure the data is safe and accuracy.
* Entities * Primary