ACCESS learning Diary
ACCESS learning Diary
1. ACCESS objects
A) a table is the basic object of a Database. Other objects are generated based on it.
B) query: You can search for required records based on the index, filter records as required, and join several fields to form a new table.
C) The form provides a convenient window for browsing, inputting, and changing data.
D) reports: Data Classification summary and printing.
E) macro: execute a series of operations in batches.
F) module: functions are similar to macros, but they are more refined and programmed.
2. Six objects and three types
A) tables and queries: data sources and basics
B) forms and reports: used for display and printing
C) macros and modules: Mainly used for control.
D) supplement: access data through data access pages (a web page)
A) Table concept:
I. Table attributes; Table records; Table components;
Ii. Operations on records: projection and selection;
Iii. A connection can be established between tables;
B) Table Design Principles
I. The table functions should be single (in line with the paradigm)
Ii. Unique fields;
Iii. Unique record (no identical record exists)
Iv. Function relevance (excluding irrelevant attributes)
V. Field Independence: modifying a field does not affect the data of other fields (the solution is usually to split the table)
C) create a database (using a template, using the Wizard to create a table, and using the table designer to create a table ;)