Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch.8 Databases (well organise system) - Coggle Diagram
Ch.8 Databases
(well organise system)
8.1 Database Concept
save time and space
take much less time
realize that information
8.2 Using the DBMS
Data hierarchy
Field
Record
Table
Database
Create DBMS table
8.2.3 Key Field
unique to a specific record
Driver’s licence number
Student id_no
Bank account number
Product code
8.2.2 Designing a Database
Field
Field name (Key Field)
Data type
Field length
8.2.4 Input Mask
Help prevent users from
inputting invalid (無效) data
eg. tele_no Field length must be 8
8.3 Microsoft Access (eg. of DBMS)
8.3.3 Understanding Tables in Access
Two ways to create or edit the structure of a table
Datasheet View
Design View
Text (255<=x)
Memo (255<x<65536)
Number
Currency(貨幣)
AutoNumber
Yes/No
OLE object
Hyperlink
Date and Time
Six types of database
Table
Forms
Reports
Queries(Find sth. in tabes)
Macros (Use less)
Module (Use less)
8.3.4 Data Sorting and Filtering in Access
Rearrange
Extract
8.6 Queries
Structured Query Language (SQL)
SELECT field name(s) FROM table name(s) WHERE criteria;
SELECT field name(s) FROM table name(s) WHERE criteria ORDER BY field name(s);
Three ways to create a query
Query Wizard
Design View
SQL Views
8.5 Reports (General Reports)
easy-to-read layout
present summarized information
printing data more professional
produce professional reports easily
8.4 Forms
graphical user interface(GUI)
manipulate and display the data.
well-designed
clearer format
more attractive format
more efficient