a) A comprehensive A C C e s S application will at least involve the following three basic Access object types:
i. Table is used to store the data you or others to add data to the database.
II. Forms are used to display and enter data, control the opening and closing of other forms, and printing the report.
III. Reporting details information, summary information, or all of them are printed.
b) Menu: "Tools" à "relationship" can set the interval relationship
c) ACCESS form:
d) access report
e) Access module: Contains VBA processes and functions (public, any form or report can be accessed)
EG: Isloaded ("Form Name") à Check if the form is opened (0 / -1)
To be a perfect relational database management system (RDBMS), an application must have the following four basic functions, each of which has its own expression (or view):
1: Data organizations (creation and operation of the table)
2: Table links and data extraction (query, temporary table, etc.)
3: Data input and editing (Form implementation)
4: Data representation (report)
f) Database utility (some need to be executed without opening the database)
Compression and repair (preferably compress and repair into new databases, preventing database accidental damage can not be recovered)
Add a cut panel form (no new)
Create a .mde file (compiled VBA code, source file is not available, users will no longer modify the design objects)
g) Table: An Access database can contain 32768 (2 ^ 15) objects, can open 1024 (2 ^ 10) table at the same time
Query: A query can get data from 16 tables simultaneously
Form
Report, macro, module, relationship, page
h) RDBMS Differences from spreadsheets: To make more efficient large amounts of data processing design, it is easier to link multiple tables to reduce data redundancy (only required key ID, etc.), reduce data copy
i) Design Table field name: Cannot be repeated, up to 64 characters, can be included in the middle, "no"! "and" [] "data type, description, primary key, field size, format (not affecting the value itself, Just display mode), precision (Decimal type is unique, specifying how many bits represents a value, default 18), scale (Decimal unique, decided counting number), decimal number, input mask, title, default, valid value Sexual rules, valid text, required field, allow 0 length, index, new value (automatic number type unique)
j) Field Type Text: Default, Maximum 255 characters (After the length of the design, if the input data is exceeded, the extra) Remarks: Maximum 65535 characters (can not be a key field) Digital: Set one according to the field size property Suitable type Auto number: (long integer), the method depends on the new value attribute (up to 2 billion or so) Yes / no: Logic (Boolean) field (True: -1, false: 0), can be indexed, but Can't be a key field currency: currency, fixed format (decimal 4) Date / Time: OLE object (large object): can include resources such as bitmap, vector map (can not index and do key fields) Super link: (Text Field length varies, the system automatically goes at the end space) Access field can be a null value (not 0, nor a blank text), but no input K) understands "reference integrity"
l) "primary key": uniqueness, create multi-field primary keys and corresponding indexes
Index: Accelerate search processes based on index fields, Disadvantages: When updating additional indexes, slowing the speed of the input operation
Each table can create up to 32 indexes, which can contain up to 5 multi-field indexes, and a multi-field index can contain up to 10 fields.
Open the Index dialog box, create multi-field composite index
