Learning records for Access databases

Overview

The Access database is an associated database management system published by Microsoft that can be used to store and analyze data and develop two of times.

The object structure of an Access database includes tables, queries, forms, reports, and controls, macros, and so on.

* Table objects are used to store data.

* Query objects are used to find and retrieve the required data.

* Form objects are used to view, add, and update data in a table.

* Report objects are used to analyze or print data in a particular layout.

The design of the first chapter table

A database is a collection of multiple associated tables that represent a topic. So the design of the table is the basis of building a database.

In one table, the names of the column headers for each column are called "Fields"; Information for other locations in each column is called "field values"; All information for each row is collectively referred to as "records." How many rows there are, how many records there are, and how many fields there are in each column.

The following points should be noted in table design:

Set the data type of the field appropriately.

Each table should define a primary key and foreign key (if there is a foreign key). The primary key is mandatory, unique, and can no longer be changed.

Reasonably set the index in the table, in addition to the primary key field, minimize the use of the index.

By setting the properties of a field and so on, the data is enforced at the very bottom of the database system, such as the prohibition of repetition (by no repeating index), whether it is required, the size of the field, and so on.

Carefully set other non-data restrictive properties of the field, such as format, scale, input mask, caption, display control, and so on, if the control is a combo box, list box, you should also set its row source, column width and other properties.

The relationship between tables is established through the relational view interface, and the implementation referential completion property of each relationship should be selected to guarantee the integrity and validity of the data in the associated table.

Chapter II Design of the query

Query is the function of statistical summarization of data. Each query object is essentially an SQL statement.

Essentials of Form Design

Key points of report design

Report, which is the final output that provides the data. The rows of the report for access can be arbitrary, and the columns (fields) are fixed.

Pending

Common functions, such as login module, user Management module, Rights Management module, automatic upgrade module, common custom function, etc.

Getting Started, Programming basics, Database basics, Functional module cases, complete system security

What is the difference between using the development of the Alliance Software Rapid Development Platform and general Access development?

such as data and program separation (divided into background database and foreground client), default to non-binding form, try to avoid other databases such as "OLE Object" or "attachment" do not support or have a large performance impact on the field data type, and so on.

The reason is that when you are based on an access background database, you can set the formatting of fields, input masks, headings, default values, and so on, and then, when you use the Wizards of Access or the automatic builder of the quick development platform to create forms, you can inherit them directly and apply them automatically in the properties of the control. And if you switch to a different background database, the field will not have these extended properties, you need to after the form is created, then go to one of the modified control properties, it will be more cumbersome, a lot more work.

Learning records for Access databases