Create a flower Shop order system with access

Task Name: Create Flower Shop Order System

Task Description: Te of the MM opened a flower shop, business special fire, recruit three of a coolie still a little busy. Many people order flowers by telephone or directly to the florist, and most customers want to send the flowers to a designated place at a specified time. Te with access to help mm customized a flower shop order system: Through this system, you can write down each customer's name, telephone number, address and the desired variety of flowers, the way to send flowers and time, place, etc. this system can automatically calculate the cost according to the variety and quantity of the customer order flowers, If you need to send a flower service will also add freight, and record the method of payment; it can be classified from different angles, such as the purchase of flowers, employees, flowers and other angles to show a period of time in the flower shop sales status, but also to help you quickly find out the flower shop in the stock of various flowers, Find out which flowers are about to be out of stock and go to order right away.

Task extension: The second part of this article, will focus on how to modify the database created by the template to meet different needs, interested readers can try to transform the system, so that it can be applied to the company sales, fast food, bookstores, supermarkets, shopping malls, stores and many other occasions.

One, 10 minutes to create a flower shop order system

Access comes with a lot of templates that involve many aspects of our work and life, and with these templates we can quickly build the applications we need.

First step: Start Access XP (or another version), and execute the file → new command to open the new file pane on the right. In this case, we'll use the template file that access has taken to quickly build the database, so in the new file pane, click Generic Template to open the Template dialog box, and click the Database tab on it. There are a variety of practical templates available in Access, here, double click the Order entry entry to enter the file name for the new database in the Open dialog box (in this case, the florist order. mdb), click the Create button, and then start the Database Wizard window to continue clicking the Next button ( Each step of the wizard can be prompted to do some personalized settings, such as: Add, subtract form items, select the form interface style, etc., and finally click "Finish", the system began to automatically create a database.

Figure 1

Step two: When the database is created, it opens for the first time. You will be prompted to enter some of your company's situations, click OK, and then enter your company's basic information in the dialog box shown in Figure 1, and then close it by clicking the "X" button in the upper-right corner to start the database's entry interface.

Small Tips

If you deselect the "Yes, start this database" item in the final step of the Template wizard, the database will not start automatically when it is created. You can also start this database on the shop Order: Database window, click Forms under Objects, and then double-click the Switchboard form on the right.

Figure 2