Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch.8 database - Coggle Diagram
Ch.8 database
now database
save time and space
take less time to complete business transactions
data sorting and filtering in access
sort
rearrange all the records in ascending or descending order according to a specified field
filtering
extract a subset of the records in the table according to specified criteria
from
provide more efficient interface
reports
can display data from tables or queries
queries
results are presented in a datasheet
SQL
ways to crate a query
query wizard
design view
SQL view
database object
table
froms
reports
queries
macros
module
database
is a collection of data related to particular topic or purpose
well organized
type
stock control of a shop
students records of a school
good database
effectively
accurately
efficiently
typical employee database
DBMS
Field
Record
Table
Database
key field
product code
order number
bank account number
old database
time consuming
input mask
helps prevent users from inputting invalid data
microsoft access
data type support by Microsoft access
text
memo
number
currency
autonumber
Yes/No
OLE object
Hyperlink
Data