Access 2013 provides two methods of creating a new blank desktop database and creating an Access application. To create a new blank desktop database, you first create a database on the local computer, and then create the tables and other objects of the database.

Open database file

Open database objects: In Access 2013, when you open a database file, the navigation pane on the left side of the window saves each database object. All database objects can be opened, browsed and modified through the navigation pane.

Close database

Method to create a table: When opening a new blank desktop database, Access will automatically create an empty table with the default name of "Table 1" and select the "File" Save command. If you need to create a new table, the user can click " Create a "Table" button to add a new table named "Table#". The "#" is the next unused number automatically listed in sequence.

How the table is viewed: Common table operations are performed in design view and datasheet view.

Short text: can store up to 256 characters.

Long text: Access 2013 provides two properties: "Append only" and "Format text". Long text can store up to 1GB of characters in Access.

Number: Numeric data type is used to store data that needs to be calculated, including byte type, integer type, long integer type, single precision type, double precision type, synchronous copy ID and decimal, etc.

Date/Time: Used to store date and time.

Currency: The currency data type is used to represent currency values. Rounding is prohibited during calculation and occupies 8 bytes of width.

Automatic numbering: The automatic numbering data type is used to automatically insert a unique sequence number (incrementing by 1 each time) or random numbering into each record when adding a record.

Yes/Negative: Used to store data that can only be one of two values, such as yes/no, true/false, etc.

OLE Object: OLE is the abbreviation of object embedding and linking.

Hyperlink: Hyperlink data is used to store hyperlink addresses, which can store email and other addresses.

Attachments: The attachment data type allows users to attach images and other files to records, just like attachments to emails.

Calculated fields: Calculated fields are used to store calculation results and are not data types.

Lookup and relationships: Users can create lookup fields through the "Lookup Wizard" dialog box under Lookup and Relationships, and can look up values ​​in other tables or queries.

Primary Key: A primary key is a field or a combination of fields that uniquely identifies a record in a table. A table can only have one primary key. Primary keys do not allow NULL values ​​and must always have a unique value.

"Field Size" attribute: The "Field Size" attribute is used to set the size of the space occupied by stored data. This property can only be set for two types of fields: "Short Text" and "Number".

"Format" property; the "Format" property is used to set how the data is displayed. For fields of different data types, the format choices are different. The "format" attribute only affects the way data is displayed and has no effect on the data in the table.

"Input Mask" attribute: The "Mask Input" attribute is used to set the input format of data.

"Title" attribute: The title is another name for the field. The title and field name can be the same or different.

"Default value" attribute: used to specify the default value for new records. After you set a default value, when you enter a record, the default value is automatically entered into the corresponding field of the new record.

Validation Rules and Validation Text properties: The Validation Rules property is used to set expression rules that must be followed when entering data. Use the "validation rule" attribute to limit the value range of the field, ensure the rationality of the input data, and prevent illegal data input. The "validation text" attribute is used in conjunction with the "validation rule". When the entered data violates the "validation rules", the system will use the set "validation text" to give a prompt message.

Add a new field: In the design view, if the new field you want to add appears behind the existing one, just enter the new field name directly in the blank row of the "Field Name" column.

Delete fields: In Design view, you can delete unnecessary fields in the table. Click in the row where the field that needs to be deleted is located, click "Table Tools/Design">"Tools">"Delete Row" button, or select the "Delete Row" command in the right-click shortcut menu, in the opened dialog box Click the "Yes" button to delete the corresponding field.

Modify field: If you need to modify the field name, you can double-click the field name to modify it directly, or delete the field name and re-enter a new field name.

Move fields: If you need to change the display order of fields, you can select the fields you want to change and drag them to the desired location.

Input of general data types; for short text, long text. Number, date/time, currency, yes/no and other types of fields can be entered directly into the table. There is no need to enter fields of type "Auto Number", it will be completed automatically when adding records. When adding a record, if a field is set with a "default value", the field in the new record will be automatically populated with the "default value".

OLE object data type input: Fields with OLE object data type selected cannot be input directly in the datasheet view. Data can be input by inserting objects.

Concept; sorting refers to rearranging records in a table according to the values ​​of one field or multiple fields. If the values ​​of the sorted field are arranged from small to large, it is called "ascending order"; if the values ​​of the sorted field are arranged from large to small, it is called "descending order". There are different sorting rules for different field types.

Concept; filtering refers to an operation that displays only those records that meet certain conditions and hides records that do not meet the conditions.

Four filtering methods; shared filter, filter by selection, filter by form and advanced filter/sort.

Design datasheet view format

Adjust table row height and column width

Hide columns/unhide columns

Freeze/unfreeze columns

The concept of table relationship; a table relationship is a relationship established between fields of two tables. Through table relationships, data between database tables can be linked to form "useful" data that can be used in objects such as queries, forms, and reports.

There are three types of table relationships; one-to-one relationship, one-to-many relationship, and many-to-many relationship.

Referential integrity; setting referential integrity performance ensures the validity of the relationship between records in related tables and ensures that related data will not be accidentally deleted or changed. Therefore, referential integrity checks should generally be implemented when establishing table relationships.

The establishment and maintenance of table relationships are carried out in the "Relationship" window. Click the "Database Tools" > "Relationship" > "Relationship" button to open the "Relationship" window.