Here is some sample data to input
Forename: Theepan
Surname: Jeyaseelan
Address 1: 123 High Road
Address 2: East Ham
Address 3: London
Telephone: 02081231234
Fax: 02081231234
Email:
After you have inputted the data, click on the save button
When you have done this, you can check if the data saved by going back to the main menu, and going to the SEARCH FOR CUSTOMER ORDERS function
And when this box appears
Type in Theepan
And if the data information appears, then the test was successful
Setting up the database
Before live use, you must already have some data in the stock section, so that when an order is made, the stock can be selected from a list.
To Input stock Data
Click on the Main Menu
Then Click the ADD STOCK button
When this form appears, click the ADD NEW STOCK ITEM button
Then insert the information accordingly and the stock information will be stored
Backing Up Instructions
Backing up when database is not running
In the case where there is a problem with the system and you have to backup the databasem, you will have to copy the database Microsoft access file from the directory where the database was installed
The default directory where the database is installed when you first installed the database, is
C:\Program Files\Furniture Emporium Database\database.mdb
To backup the database you will have to copy the database.mdb file to the relevant backup
device eg. Floppy Disk
Backing up when database is running
When Microsoft access is open, and you want to backup the database onto eg. floppy disk or a zip disk
Click on file, export
Choose the directory
Then click on SAVE ALL and the database will be saved
Trouble Shooting
Problems with Microsoft access
Problem 1
.
Solution
Microsoft Access displays this message when it can't open the source file for an OLE object. Check to make sure that:
- The application needed to edit the file is installed on your computer.
- You have enough memory to run the source application. Close other applications to free up memory.
- If the application that you're trying to open is already running, make sure that it doesn't have any open dialog boxes.
- If it's a linked object, make sure that someone else doesn't already have it open.
-
If it's a linked object on a form, make sure that the name of the source file hasn't changed or that the source file hasn't been moved. To see the name of the original file, click the object, and then click OLE/DDE Links on the Edit menu. The original file name appears in the Links box. If the file has been renamed or moved, click the link in the Links box, and then click Change Source to reconnect the link.
Problem 2
.
-
Open the form in or the report in .
- Click the icon.
-
On the Edit menu, point to the appropriate Object command (for example, point to Worksheet Object for a Microsoft Excel object), and then click Convert.
-
In the Convert dialog box, clear the Display As Icon check box.
Problem 2