Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases - Coggle Diagram
Databases
Using the Database Management System (DBMS)
Designing a Database
examples of fields in a typical employee database
Identity card number of an employee
Text
Mobile phone number
Text
Date of birth
Data
Salary
Numeric
Key Field
Driver’s licence number
Student identification number
Bank account number
Product code
Order number
Database Management System(DBMS)
Field
Record
Table
Database
Input Mask
Help prevent users from inputting invalid data
Microsoft Access
Microsoft Access
A very robust and powerful DBMS
Easy to set up a database
An Access database contains various database objects and is stored in a single file.
Database Objects in Microsoft Access
Table
Forms
Reports
Queries
Macros
Module
Understanding Tables in Access
The Datasheet View
Design View
Text
Memo
Number
Currency
AutoNumber
Yes/No
OLE object
Hyperlink
Data Sorting and Filtering in Access
Sorting
Filtering
Database Concept
Revolution of Information Management
The searching or sorting process of information stored in a manual filing system such as a filing cabinet could be time consuming
Databases
Typical applications of databases
Personal phone book
Video or CD catalogue
Property list of an estate agent
Employee records of a company
Animal records of a vet clinic
Stock control of a shop
Club membership of a club house
Student records of a school
Queries
Structured Query Language(SQL)
=
<
<=
=
<>
Between X and Y
Is Null
And
Or
Not
create a query
Query Wizard
Design View
SQL View
Forms
A graphical user interface used to manipulate and display the data.
Reports
For printing data in a professional and easy-to-read layout