|
Burgos Limited Liability Co. Universal Help
Splash Screen
This is the first screen that will appear when the database is opened. It will appear for five (5) seconds and then will disappear and the main switchboard will show.
Main Switchboard
HOUSE INFORMATION: HOUSE MASTER The House Master allows the user to input a new house record into the database, modify an existing record, or delete a record.
1. Clicking on the “Add New” button will allow user to add a new house record: Address: Enter address City/State/Zip: Enter City, State, and Zip Code. Choose State from drop-down list designated by the down arrow. If your state is not included in drop-down list, then enter two-letter abbreviation for state. Date of Purchase: Enter date when house was originally bought Date of Sale: Enter date when house was sold if applicable Purchase Price: Enter price house was originally purchased for Expense Budget: Enter the amount of money employees will be able to spend on remodeling jobs. Appraisal Value: Enter the amount of what house should be worth according to realtor.
2. Clicking on the “Print” button will print house record that is displayed on screen
3. Clicking on the “Delete” button will delete displayed house record. A warning message will display saying that the record cannot be retrieved if deleted. Click OK or CANCEL.
4. Clicking on the “Exit” button will close the House Master Form EMPLOYEE INFORMATION: EMPLOYEE MASTER The Employee Master allows you to add a new employee record into the database, modify an existing record, or delete a record.
1. Clicking on the “Add New” button will allow user to add a new employee record: First Name/Last Name: Enter the new employee’s first and last name Address: Enter the employee’s address City/State/Zip: Enter City, State, and Zip Code. Choose State from drop-down list designated by the down arrow. If state is not included in drop-down list, then enter two-letter abbreviation for state. Pay Rate: Enter employee’s hourly pay rate Salary Amount: Salary amount is a fixed rate of $1000.00
2. Clicking on the “Print” button will print employee record that is displayed on screen
3. Clicking on the “Delete” button will delete displayed employee record. A warning message will display saying that the record cannot be retrieved if deleted. Click OK or CANCEL.
4. Clicking on the “Exit” button will close the Employee Master Form EXPENSE DETAIL: REMODELING MASTER
1. Clicking on the “Add New” button will allow user to add a new purchase record: House Address: From the drop-down list designated by the arrow choose the address for which a job needs to be done. Each house is represented by a specific number. Employee-Buyer: From the drop-down list designated by the arrow choose the employee that will be doing the job from the designated house. Each employee is represented by a specific number. Date of Purchase: The date is set to today’s date by default, but the user can change the date if necessary. Description: Enter a brief description of the purchase to be made. Vendor: From the drop-down list designated by the arrow choose the vendor where the purchase will be made. Each vendor is represented by a specific number. Section: From the drop-down list designated by the arrow choose the section of the house in which the work will be done. Each section is represented by a specific number. Amount: Enter the total amount of the purchase.
2. Clicking on the “Print” button will print purchase record that is displayed on screen
3. Clicking on the “Delete” button will delete displayed purchase record. A warning message will display saying that the record cannot be retrieved if deleted. Click OK or CANCEL.
4. Clicking on the “Exit” button will close the Purchase Master Form
Select the desired report to view: House Information: Shows the address of each house along with its city, state, and zip Expenses Detail Per House: Displays for each house the section that was to be remodeled, the employee that did the remodeling, the vendor that the item(s) were purchased from, and how much was spent. Expenses Detail Per Section: Displays for each section the address of the house, the employee that worked on that section of the house, and how much was spent. Cost Comparison Chart: Shows on a bar graph the total amount of expenses paid for each section of the house. Expenses Per House Chart: Report that shows by each address the expenses for each section of that house repaired and the bar graph displays the totals for each section. Sale of Houses: This report displays the profit or loss for each house sold, its original purchase value, and its appraisal value.
Clicking on “Exit” will send user back to Reports Switchboard Click on the “X” in the top right hand corner of each report to close that report.
Select the desired report to view: Employee Information: Report that displays employee’s name, address, and phone number Payroll Detail: Report that shows weekly payroll for each employee. Employees are hired to get paid by their hourly rate or by salary for the week. Salary is fixed at $1000.00 per employee. Each employee has a different hourly rate. Profit/Loss Per Employee: This report displays how the profits are split between the owners of Burgos Limited Liability Corporation. Total Payroll Paid: This report shows up to the date of the last paycheck how much gross pay each employee has earned and it shows the date that each employee was hired.
Clicking on “Exit” will send user back to Reports Switchboard Click on the “X” in the top right hand corner of each report to close that report.
The user may choose to back up all tables or back up an individual table. Clicking on “MORE…” will display more tables to back up.
Backup All Tables: Clicking on this will open up a message. Clicking on “YES” will begin backup. Clicking on “NO” will close that form.
After backup is completed a message box will display alerting the user that the tables have been backed up, and then click OK. Open the database objects window under “Tables” to verify that tables have been copied.
All the other backups will back up each individual table. It may seem as if nothing has happened, but open the database objects window under “Tables” to verify that tables have been copied.
The “EXIT” button on the “BACKUP TABLES” screen will take user back to the “MAINTENANCE” Switchboard. The “EXIT” button on the “MORE…” screen will take user back to the “BACKUP TABLES” screen. Note: There is no message to alert user to proceed with backing up the individual table.
Follow instructions contained in the message box. Clicking on the “EXIT” button will close the form. User can backup database to desired drive.
Follow instructions contained in the message box. Clicking on the “EXIT” button will close the form.
|
|
© 2005 by Alejandra Vargas & Timothy Perry |
