Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch.8 Databases - Coggle Diagram
Ch.8 Databases
-
8.6 Queries
-
Must be written in a format that Access can interpret, i.e.(SQL)
The syntax of SQL statements are shown below:
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);
-
-
-
-
8.1 Database Concept
The searching or sorting process of information stored in a manual filing system such as a filing cabinet could be very time consuming.
Switching from a manual filing system to an electronic one can save time and space on information management
-
8.4 Forms
-
A well-designed form has the fields displayed in a clearer and more attractive format than the Datasheet View.
-