Grocery Product Price Comparison Database
Budget: £20 – £250 GBP
Brief for Your Access Developer:
Project Overview:
"I need a Microsoft Access database for comparing supplier prices for grocery product. I want to track different suppliers offering the same products so I can easily compare prices and make purchasing decisions."
Main Requirements:
1. Core Data Structure:
grocery product
Supplier details (name, contact info, pricing)
Pricing data (unit price, minimum orders, lead times)
Product categories and specifications
2. User Interface Needed:
Data entry form with dropdown menus for:
Supplier selection
Product categories
Standard product names
Search functionality to find specific products/suppliers quickly
Comparison view to see multiple suppliers for the same product side-by-side
3. Key Features:
Dropdown menus instead of typing (reduces errors)
Ability to add new suppliers and products easily
Price comparison calculations (show cheapest option)
Export capability to Excel for reports
Simple navigation between records
Sample Data Structure:
Specific Deliverables:
Fully functional Access database (.accdb file)
User-friendly data entry form
Basic reports for price comparisons
Simple user guide for adding/editing data
Budget/Timeline Question:
"What would you charge for this, and how long would it take?"
Project Overview:
"I need a Microsoft Access database for comparing supplier prices for grocery product. I want to track different suppliers offering the same products so I can easily compare prices and make purchasing decisions."
Main Requirements:
1. Core Data Structure:
grocery product
Supplier details (name, contact info, pricing)
Pricing data (unit price, minimum orders, lead times)
Product categories and specifications
2. User Interface Needed:
Data entry form with dropdown menus for:
Supplier selection
Product categories
Standard product names
Search functionality to find specific products/suppliers quickly
Comparison view to see multiple suppliers for the same product side-by-side
3. Key Features:
Dropdown menus instead of typing (reduces errors)
Ability to add new suppliers and products easily
Price comparison calculations (show cheapest option)
Export capability to Excel for reports
Simple navigation between records
Sample Data Structure:
Specific Deliverables:
Fully functional Access database (.accdb file)
User-friendly data entry form
Basic reports for price comparisons
Simple user guide for adding/editing data
Budget/Timeline Question:
"What would you charge for this, and how long would it take?"