1. Six types of objects of ACCESS
a) Tables are the basic objects of the database, and several other objects are generated based on it.
b) Query: You can find the required records according to the index; you can filter records as required; and connect several fields to form a new table.
c) The form provides a convenient window for browsing, entering and changing data.
d) Report: Data classification summary, printing.
e) Macro: equivalent to batch processing, performing a series of operations
f) Module: The functions are similar to macros, but they are more refined and programmed.
2. Six types of objects, three types
a) Tables and queries: The source and basis of data
b) Forms and reports: used for display and printing
c) Macros and modules: mainly used for control.
d) Supplement: Accessing data through data access pages (a kind of web page)
a) Concept of table:
i. �
ii.
iii. �
b) Table design principles
i. �
ii.
iii. Record uniqueness (there is no exact same record)
iv.
v. �
c) Create a database (through templates; create a table using a wizard; create a table using a table designer;)
a) Tables are the basic objects of the database, and several other objects are generated based on it.
b) Query: You can find the required records according to the index; you can filter records as required; and connect several fields to form a new table.
c) The form provides a convenient window for browsing, entering and changing data.
d) Report: Data classification summary, printing.
e) Macro: equivalent to batch processing, performing a series of operations
f) Module: The functions are similar to macros, but they are more refined and programmed.
2. Six types of objects, three types
a) Tables and queries: The source and basis of data
b) Forms and reports: used for display and printing
c) Macros and modules: mainly used for control.
d) Supplement: Accessing data through data access pages (a kind of web page)
a) Concept of table:
i. �
ii.
iii. �
b) Table design principles
i. �
ii.
iii. Record uniqueness (there is no exact same record)
iv.
v. �
c) Create a database (through templates; create a table using a wizard; create a table using a table designer;)