Create a simple MIS management system with access

Your home CD, VCD must be a lot of it? Are you sure you don't get blamed for finding a CD that turns a drawer of dishes into a mess-you don't want to sort them out? such as: The film is domestic, or foreign, is the romance, or shootout, the star starring those business cards, which director of these films, etc. if you like, let's take advantage of Microsoft Access to create a home CD, VCD management MIS system.

1. Preparation--Identify the tables and fields that the database needs

Since the MIS system we are creating is a small management system, there is no need to build a few tables, just a single table. The fields of the table are: number, movie name, starring, directing, publishing company, type of film, whether or not to win. Where number is the primary keyword, which uniquely determines the field or field set for each record.

2. Creating a Database

(1) Create a database using the Database Wizard:

When you start Microsoft Access, a dialog box is automatically displayed with the option to create a new database or open an existing database. Click Database Wizard, and then click the OK button. Click OK in the new Empty Database dialog box, and then specify the name and location of the database, and click the Create button to start the newly created database. Then create a new table, and then fill in the corresponding field name and data type, and set the field size, index and other items, other than fill in or take the default value. Where the maximum set value for the field is 255 bytes, the data type has text, notes, numeric, date/time, Currency, AutoNumber, OLE Object, and so on, you can choose according to different requirements.

(2) Create a database without using a wizard

When you start Microsoft Access, the dialog box is automatically displayed with the option to create a new database or open an existing database, click Empty Database, and then click OK. If you have already opened the database or if the dialog box that appears when Access opens is closed, click the New Database button on the toolbar, and then double-click the empty Database icon on the Standard tab. Specify the name and location of the database and click the Create button.

3. Database basic Operations

The structure of the database has been created, and the next thing we need to do is to do a series of basic operations on the database. Add a record: Open the form in Datasheet view or Form view, click the New Record button on the toolbar, type the data you want, and then press the TAB key to go to the next field, and at the end of the record, press the TAB key to go to the next record.

Edit a record: If you want to edit the data in a field, click the field that you want to edit, if you want to replace the entire field's value, point to the leftmost field, and when the mouse changes to a plus sign, type the text you want to insert.

Note: If you type in an error, you can press the BACKSPACE key; If you want to cancel the change to the current field, press ESC, and if you want to cancel the change to the entire record, press ESC again before you move out of the field, and when you move from one record to another, Access saves the changes to the record.

Copy or move data: In other applications, such as Excel, Word, select one or more rows to copy or move. If you are copying data from Word, make sure that the records are already listed in the table before you select or are already separated by tabs, and if you paste data into a datasheet, make sure that the columns in the datasheet match the order of the data you want to copy or move, and if you paste the data onto the form, When the corresponding control name on the form is the same as the column name of the copied data, Access pastes the data onto the control with the same name. In Access, open the datasheet or form where you want to paste the record. If you want to replace an existing record, select the record you want to replace, and then click Paste Append or paste on the toolbar; if the record selector in the form is not available, to select the current record, click Select Record on the Edit menu. Command.

Delete Record: Click the record you want to delete, and click the Delete Record button on the toolbar.

4. Sorting, screening and querying of data

If you want to make the movie in your VCD database neatly arranged and convenient to search, it is very important to master the sorting, querying and filtering of the database.

Sort records:

In Form view or Datasheet view, click the field that you want to use to sort the records. Click the right mouse button and you can select the ascending sort or descending sort of the field. In a datasheet, you can select two or more adjacent fields to sort separately. Microsoft Access starts sorting records from the leftmost column that you select. When you save a form or datasheet, Microsoft Access saves the sort order.

To create a filter:

If you can easily locate and select an instance of a value that you want to filter records in a form, subform, or datasheet, you can use filter by selection. You can do this by clicking Filter By Selection in the Records submenu, filter.

Use Filter By Form if you want to select the desired value from the list, instead of browsing through the datasheet or all the records in the form, or if you want to specify more than one criterion at a time.

If the focus is in a field in a form or datasheet, and you just need to enter the value you are searching for or an expression that you want to use as a guideline, you can do so by using input filter target. In the case of a more complex filter, you can use advanced Filter/Sort.

To create a query:

You can use queries to view, change, and analyze data in different ways. You can also use a query as a record source for forms and reports, and the most common type of query is a select query. The select query installs the specified criteria, gets the data from one or more tables, and displays it in the order you want.

How to: Click Query in the database view, press "New", select Design view, "OK", select table and query, add table, then press "Add", select "Field" in the "Select query" table, and determine sorting requirements, finally save the query, so that a select query is completed.

You can also create a query by selecting the Simple Query Wizard, the Crosstab Query Wizard, the Find Duplicates Query Wizard, and the Query Mismatch Query Wizard in new.

5. Report making

Maybe you want to print out your VCD database and check it out anytime. If you are the owner of the VCD store, then this will be the best publicity. The report functionality in Microsoft Access enables you to control the size and display of each object in a report, and to display the appropriate content in the way you want.

How to: Click Report Wizard, select the available fields in the Report Wizard dialog box, press Next, and then select the field sort, up to four fields to sort, next to select the layout of the report, and then press Finish.

There are other report design methods, such as automatic report (column table), Automatic report (table), Icon Wizard, Label Wizard, I will not say, you can try.

6. Share database with other software

(1) Database type conversion

In the past, different databases were often unable to share information that had been established with each other. If you used to use dBASE to build a database, but because of the advent of the Windows world, the boss in order to keep up with the fashion, the company no longer use the dBASE to build the database, and you will all the database created on the dBASE, all re-enter the database in Access 97 , when you hear the news, you must be crying days, helpless. Even if there are 1000 reasons to use Access 97, you are reluctant to change the database. As a matter of fact, Access 97 has already figured out a solution for this point, and Access 97 offers a number of ways to invoke, export, and so on to get you to do database conversion. You simply click Convert Database on the Tools menu Database Utility submenu, and then select the other type of database you want to convert, such as dBASE, where the database will be successfully converted from dBASE to Access 97.

(2) Call Access data in Word

You can save the output of a datasheet, form, or report in Rich Text Format (. rtf) files. Rich-Text Format files can retain formatted information such as fonts and styles, and can be opened with Microsoft Word and other Windows word processing programs or desktop publishing programs. As in the preceding example, in Microsoft Access, open the CD, VCD Management System database table 1, click Save As/export, save table 1 in Rich Text format, and then open the table 1.rtf at the location specified in the Microsoft Word file.

(3) Export Access data to Excel:

Click the name of the table or query you want to export in the Database window, as shown in the preceding example. Table 1, and then on the File menu, click Save As/export, in the Save As dialog box, click Save as an external file or database, and then click OK. In the Save as type box, click the spreadsheet format that you want. Click the arrow to the right of the Save in box to select the destination drive and folder for the export. In an existing spreadsheet, or enter a new file name in the File name box. Note that when you save to an existing spreadsheet, Access deletes and replaces the data in it, so be especially careful. F Click the Export button, Access will create the spreadsheet file that contains the table or query data. Field names in a table or query are placed in the first row of the spreadsheet.

7. Protecting the Database

(1) Encrypt or decrypt the database

Encrypting a database compresses the database file and makes it impossible to decrypt through a tool program or a word processing program. Database decryption is an encrypted reverse procedure.

Method: Starts Microsoft Access, but does not open the database. Click Encrypt/Decrypt database on the Security submenu of the Tools menu. Specify the database that you want to encrypt or decrypt, and then click the OK button. Specify the database name, drive, and folder after encryption or decryption, and then click OK. If you use an existing database name, drive, and folder, Microsoft Access automatically replaces the original database with the encrypted or decrypted version after the encryption or decryption is successful. However, if an error occurs, Microsoft Access retains the original database file.

(2) Set the password for the database

Method: Open the database and select the Exclusive check box. Click Open, and then click Set Database Password on the Security submenu of the Tools menu, enter the password, verify, and then click OK to complete the password for the database setup, and when you open the VCD library, prompt for the password.