Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,398 members, 7,958,148 topics. Date: Wednesday, 25 September 2024 at 09:48 AM |
Nairaland Forum / Science/Technology / Programming / Pls btw Excel nd accss which one wil be suitable for inventory tht can generate (592 Views)
Help Needed On API Used To Generate Wema Bank Virtual Accounts / Which Is Better Btw KOTLIN & FLUTTER / Which Programming Language Is Best And Suitable For Android Development (2) (3) (4)
Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Yaronkirki: 7:36pm On Sep 23, 2020 |
Please guyz want to design a simple inventory that can keep records of sales and also print invoice and receipt. So my question here is which of the ms package will be suitable between Excel and Access. Thankz |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by ojun50(m): 7:43pm On Sep 23, 2020 |
Use Excel |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Kehcsc(m): 8:25pm On Sep 23, 2020 |
For me I will go with Access though it requires some extra "technical know how" |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Yaronkirki: 8:50pm On Sep 23, 2020 |
Kehcsc: Yess and that's my problem |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by randomShek: 9:12pm On Sep 23, 2020 |
Yaronkirki:If it’s really going to be simple, Excel can handle it perfectly. |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Yaronkirki: 9:31pm On Sep 23, 2020 |
randomShek: Ok but how can I put the link for printing |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by randomShek: 10:19pm On Sep 23, 2020 |
Yaronkirki:You can setup the page to print out only the area of invoice and receipt. Turning off gridlines of those sheets will also help it look professional when printed out. You can send a pm if you want me to help. 1 Like |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Kehcsc(m): 10:46pm On Sep 23, 2020 |
Yaronkirki:In that case go with Excel.... |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Yaronkirki: 11:17pm On Sep 23, 2020 |
randomShek: Ok thankx |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by dosumuoluwaseye: 12:58am On Sep 24, 2020 |
I had even wish to know how a sales data will look like. Can anyone please help with a template or screenshot? |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Yaronkirki: 8:19am On Sep 24, 2020 |
randomShek:But I want each record from the invoice to be saved permanently |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by randomShek: 10:13am On Sep 24, 2020 |
Yaronkirki:I understand, this can be done with ease in Excel. You will save all the necessary records in one workbook for every sale you have and then whenever you want to create an invoice/ receipt for a particular date/ product, all you have to do is extract the required records. The process can become tasking as your “database” grows larger so consider automation to make it easier to maintain. |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by exhibit7432(m): 10:47am On Sep 24, 2020 |
Yaronkirki: Send me a WhatsApp message on 08104203308 |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Yaronkirki: 12:20pm On Sep 24, 2020 |
randomShek: Okk let me create the table First |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by ATTAHDYE(m): 3:55pm On Sep 25, 2020 |
YOU can use excel with a DASHBOARD (in the form of a reciept) that you can call a particular transaction and print. |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Nobody: 7:37am On Sep 29, 2020 |
Why don't you just install a small Sales Management System? There are a few robust ones out there that are completely free and can export data into excel for analysis. 2 Likes |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by Nobody: 7:26pm On Oct 02, 2020 |
Was this ever resolved? |
Re: Pls btw Excel nd accss which one wil be suitable for inventory tht can generate by talk2hb1(m): 7:36am On Oct 03, 2020 |
Yaronkirki: @op consider this airsaylongcom: |
(1) (Reply)
Finding Javascriprt Strange / Digital Marketing Or Data Analysis, Which Part Should I Choose? / Artificial Intelligence Which Doesn’t Need You To Learn Programming to code
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 21 |