Closed

MS Access 2013 Database with forms and reports

I need database application on MS Access 2013 for Inventory, Sales, Purchases, Expenses, Commissions, etc… No VB or interface is required I’ll be using the program on MS Access directly and I should have full access to the tables, so please no need for high priced bids only reasonable bids are welcomed.

The program shall be custom designed, or if you have a read program then it should be modified according to my requirements as following:

Store:

1- Product code (Auto Generated and unique)

2- Product name

3- Quantity

4- Cost price

5- Sale price

6- Product’s profit percentage

7- Product’s total cost

8- Total store value

Suppliers:

1- Supplier code (Auto Generated and unique)

2- Supplier name

3- Supplier phone

4- Supplier Address

Vendors:

1- Vendor code (Auto Generated and unique)

2- Vendor Name

3- Vendor phone

4- Date of entry (start date) (Auto Generated)

Customers:

1- Customer code (Auto Generated and unique)

2- Customer name

3- Customer phone

4- Customer address

Sales (Invoice):

1- Invoice number (Auto Generated and unique)

2- Date and time (Auto Generated)

3- Customer name

4- Customer phone

5- Customer address

6- Vendor name

7- Product code

8- Product name

9- Quantity

10- Product Price

11- Product’s total price

12- Total of invoice

Expenses:

1- Date

2- Description

3- Amount

Vendor’s commissions payment:

1- Payment date (Auto Generated)

2- Vendor name

3- Commission Period from **** to

Forms:

1- Form for product entry in store

2- Form for supplier entry

3- Form for vendor entry

4- Form for invoice with the ability to add customer’s date in customers table through the invoice form itself

5- Form for expenses entry

6- Form for vendor’s commissions payment (When I open this form I should see the commissions due for the vendor which is 7% of his total sales, and I should be able to select the vendors individually or more than one vendor or to select hem all)

Reports:

1- Report of vendor sales with the ability to select the vendors individually or more than one vendor or to select hem all for any period from *** to *** which I could set manually, the report should show the vendor name the dates the sold products and quantities; total sales amount and his commission for the sales which is 7% and detailed commissions balance showing the total amount paid from the start and the outstanding amount up to the report date.

2- Sales report for any period that can be set manually.

3- Profit report for any period that can be set manually after cutting the expenses that was paid during the specified period and the ability to choose whether to cut the commissions deserved to vendors for the specified period or not and whether it is paid to the vendor or not.

Skills: Database Programming, Microsoft Access, Software Architecture, SQL, Visual Basic for Apps

See more: what is a form in access, uses of forms in ms access, types of forms in ms access, how to create a form in access 2016, how to create a data entry form in access 2016, access database form, what is a report in access, difference between form and report in ms access, reports forms disappeared access 2007 database, edit forms reports database mysql, futures price scrap access nymex database, creating forms reports ms access, ms access close database specific time vba, ms access good database web based application, ms access gym database, ms access risk database, ms access roofing database, ms access sample database shop, outsourcing ms access db database, access database forms reports

About the Employer:
( 59 reviews ) Minia, Egypt

Project ID: #17926590

33 freelancers are bidding on average $103 for this job

illuminesoft

We have successfully finished over 520 projects in last 18 years. ID : 17926590 Greetings, We are interested to work on this project, please find my comments inline with yours, 1)I need database application on More

$361 USD in 14 days
(332 Reviews)
7.6
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As More

$55 USD in 10 days
(89 Reviews)
7.4
mail2vimalarora

Hello, I am ready to discuss project with you. Being highly experienced in working on MS Access projects of various complexities involving forms, reports, vba etc. and based on that I can help in developing access More

$45 USD in 3 days
(154 Reviews)
6.2
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project MS Access 2013 Database with forms and reports. I can assure you the quality job. I have good experience in Database Programming, Microsoft A More

$140 USD in 3 days
(40 Reviews)
6.1
royalcalif

I would like to discuss little bit more about the project to calculate appropriate cost. Please pm me. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accurac More

$30 USD in 1 day
(71 Reviews)
5.8
sysdesigner13

Hi, bro! I've read your requirement. I have rich experience with database management in MS Access. I have finished many project like this. I'm confident in your project and I promise to do your project in time. More

$58 USD in 2 days
(55 Reviews)
5.5
Altantsetseg

Dear Sir/Madam My name is Alta and i am from Mongolia. From your project declaration, I believe I can complete it successfully. I've been experienced in programming including MS Access since 2000. During 2006-20 More

$311 USD in 3 days
(18 Reviews)
4.8
fastlabindia

Greeting!. Yours work is one of the tasks that can be done very perfectly by us. We work within your budget, Within your deadline. We are highly experienced Post Graduate Engineers, IT, ITES, Software, Infrastructure P More

$30 USD in 10 days
(6 Reviews)
3.7
$77 USD in 3 days
(5 Reviews)
3.5
mukesh30march

hello i read instruction that is given in this project please provide more detail for the project i have done more than 5 projects i will provide 5 star rating work thanks

$100 USD in 10 days
(15 Reviews)
3.6
dionisiotumbaga

Hi, I am interested in this project. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

$70 USD in 2 days
(5 Reviews)
3.1
citijayamala

1. I am an expert in MS Access, Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool fo More

$200 USD in 3 days
(4 Reviews)
2.9
$333 USD in 10 days
(6 Reviews)
3.2
emanfa04

I can work with MsAccess >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

$72 USD in 10 days
(2 Reviews)
1.8
cwiclk

Hello, I am with a degree in computer science and 12+ years’ experience in Software industry as Senior Software Engineer. In my carrier I have involved with understanding customer requests for ERP applications, D More

$72 USD in 4 days
(3 Reviews)
2.9
AMTSolutions

Dear Sir/Madam, I have 20 years experience with Microsoft Access and will be happy to work on your project. I have developed many projects using Access as the front and back end. I have developed solutions for Custome More

$30 USD in 3 days
(1 Review)
1.7
abedzena2017

I am honored to have done this work to you I have sufficient experience in this area You can communicate with me to accomplish this task with ease لقد قمت بعمل عدة برامج لاحد الاخوة المصريين .. يرجى التواصل حتى اتمكن More

$100 USD in 3 days
(2 Reviews)
1.9
Orientwork

Hey, how are you? i can do your work perfectly and fast, just give me a chance, you'll be satisfied for sure. please check my portfolio link provided in proposal, if you like it then award me the project and lets start More

$50 USD in 7 days
(2 Reviews)
1.7
ppejkovski

Dear sir/madam I went throughout your requirement, you have explained needed tables, that is excellent since you know what is exactically needed. For the required reports i think that is best to build more than 3 re More

$50 USD in 3 days
(1 Review)
0.8
BorisSchalk

Hello How are you? I have read your job description. I'm a ms access expert with 10+ years experience. And I mastered MS Access database and VBA programming, querying. I know very well about all functions on MS Access More

$30 USD in 3 days
(1 Review)
0.6