Access to create a simple MIS Management System (1)

MIS Management SystemIt is also a very practical management system, which can put a lot of things in order to facilitate your search. Next we will take the CD and VCD in your family as an example, we will introduce how to establish a MIS Management System to make these things organized.

Access to create a MIS Management System:

1. Preparation-determine the tables and fields required by the database

Because the MIS system we want to create is a small management system, it is not necessary to create several tables, just one table. The fields in this table include: Number, film name, leading role, Director, distribution company, film type, and whether or not to win the award. The "Number" is the primary keyword that uniquely identifies the field or field set of each record.

2. Create a database

1) Use the Database Wizard to create a database:

When Microsoft Access is started, a dialog box is displayed, showing the options for creating a database or opening an existing database. Click Database Wizard, and then click OK. In the create blank database dialog box, click OK, specify the name and location of the database, and click Create to start the new database. Create a new table, enter the corresponding field name and data type, and set the field size, index, and other items. Do not fill in other items or take the default value. The maximum value of a field is 255 bytes. The data types include text, remarks, values, date/time, currency, automatic number, and OLE object. You can select the value based on your requirements.

2) do not use the Wizard to create a database

When Microsoft Access is started, a dialog box is displayed, showing the options for creating a database or opening an existing database. Click "null Database" and then click "OK ". If the database is already opened or the dialog box displayed when Access is opened is closed, click the "create database" button on the toolbar and double-click the empty database icon on the "common" tab. Specify the database name and location, and click "CREATE.

3. Basic Database Operations

After the database structure is created, what we need to do next is to perform a series of basic operations on the database. Add record: Open the corresponding form in the "data table" view or "form" view, click the "New Record" button on the toolbar, type the required data, and press the TAB key to go to the next field, at the end of the record, press the TAB key to go to the next record.

Edit record: If you want to edit the data in a field, click the field to be edited. If you want to replace the value of the entire field, point to the leftmost field. When the cursor changes to the plus sign, click the field, enter the text to insert.

Note: If you enter an error, press the BACKSPACE key. If you want to cancel the changes to the current field, press the ESC key. If you want to cancel the changes to the entire record, press ESC again before removing this field. When you move from a record to another record, Access will save the changes to this record.

Copy or move data: in other applications, such as Excel or Word, select one or more rows to copy or move. If you copy data from Word, make sure that the records have been arranged in the table or are separated by tabs before selection. If you paste the data to the data table, make sure that the columns in the data table are in the same order as the data to be copied or moved. If you paste the data to the form, and the corresponding control name on the form is the same as the name of the copied data column, access will paste the data to the control with the same name. In Access, open the data table or form to which you want to paste the record. If you want to replace the existing record, select the record to replace, click the append or paste button on the toolbar. If the record selector in the form is unavailable, select the current record, click the "select record" command in the "edit" menu.

Delete record: Click the record to be deleted and click the delete record button on the toolbar.

4. Sort, filter, and query data

If you want to make the videos in your VCD database neatly arranged and easy to query, it is very important to know how to sort, query, and filter the databases.

Sorting records:

In the form view or data table view, click the field to be used to sort records. Right-click the field to select the ascending or descending order of the field. In a data table, you can select two or more adjacent fields for sorting. Microsoft Access sorts records from the leftmost column selected. Microsoft Access saves the sort order when saving the form or data table.

Create filter:

If you can easily find and select an instance in a form, subform, or data table that you want to filter the values in a record, you can use "filter by selected content ". Click "filter" in the "record" submenu to "filter by selected content.

If you want to select a value from the list and do not want to browse all records in the data table or form, or you want to specify multiple criteria at a time, you can use "filter by form ".

If the focus is in fields of a form or data table, and you need to enter the searched value or the expression that uses the result as the criterion, you can use "input filter target ". For more complex filtering, you can use "Advanced filtering/sorting ".

Create query:

You can use different methods to view, change, and analyze data through queries. You can also use query as the record source for forms and reports. The most common Query type is query. SELECT query to install the specified criterion, obtain data from one or more tables, and display the data in the desired order.

Specific Operation: click "query" in the database view, press "new", select design view, "OK", select table and query, add table, and then press "add ", select "field" in the "SELECT query" table, confirm the sorting requirements, and save the query. In this way, a SELECT query is complete.

You can also select the simple query wizard, cross tabulation query wizard, duplicate query wizard, and query mismatch wizard in "New" to create a query.