Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch.8 Database - Coggle Diagram
Ch.8 Database
Data types supported by Microsoft Access:
text
memo
number
currency
auto number
yes/no
OLE object
hyperlink
date
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.
Six types of database objects
table
forms
reports
queries
macros
module
Two ways to create or edit the structure of a table
Datasheet View
Design View
8.2 Using the Database Management System (DBMS)
Data hierarchy can be divided into
field
record
table
Database
Designing a Database
data type
text
date
number
The data type of each field helps us enter the data.
key field
examples
Driver’s licence number
Student identification number
Bank account number
Product code
Order number
input mask
Help prevent users from inputting invalid data
Three ways to create a query:
query wizard
a quick way to build a simple query
design view
a graphical tool that can be used to create query
sql view
a text-input interface for writing SQL statement
8.1 database concept
8.1.1 Revolution of Information Management
searching or sorting process of information stored in a manual filing system
8.1.2 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