Please enable JavaScript.
Coggle requires JavaScript to display documents.
databases - Coggle Diagram
databases
microsoft access
table
forn
report
query
marco
Understanding Tables in Access
datasheet review
Display the table organised in rows and columns.
l Work like a spreadsheet and you can input data directly into the table.
design view
Display the underlying structure of the table.
l You can inspect and modify the data type and description of each field.
creating and modify the structure table
data type
text
memo
number
currency
auto number
yes/no
ole object
hyper link
sorting and filering
Sorting
rearrange all the records in ascending or descending order according to
a specified field.
extract a subset of the records in the table according to specified
criteria.
filtering
forms
A graphical user interface used to manipuate and display the data.
well-design form has the fields displayed in a clearer and more
attractive format than the Datasheet View.
Provide more efficient interface
reports
DBMS
field
key field
The data in a key field is unique to a specific record.
The key field should not be anything with a chance of duplication
record
table
databases
database concept
very time consuming
take much less time
saving space and time
Databases
Typical applications of databases:
l Personal phone book
l Video or CD catalogue
l Property list of an estate agent
l Employee records of a company
l Animal records of a vet clinic
l Stock control of a shop
l Club membership of a club house
l Student records of a school