+ Reply to Thread
Results 1 to 17 of 17

I want to make a database program, how can I start for?

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    I want to make a database program, how can I start for?

    I've too many information on the excel.
    I want to make a sample database program to input and output the data.

    I mean as follows:

    1. database, for example, name, ID, money, income and QTY etc.
    2. input function(when I scared the barcode on the machine), the QTY will add 1 from original 1 to 2.
    3. output function(when I scared the barcode on the machine), the QTY will reduce from original 2 to 1.

    Firstly, how can I make it?
    Secondly, where can I find the related resource to learn on the Internet?

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: I want to make a database program, how can I start for?

    I'm not an Access user myself, but I'd suggest starting with the Microsoft site: https://support.office.com/en-gb/art...-862f470c1a9c#
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: I want to make a database program, how can I start for?

    Here are two links that should be required reading before starting to build a database.

    http://sbuweb.tcu.edu/bjones/20263/a...sdb_design.pdf

    after reading above, then look at this tutorial

    http://www.accessmvp.com/strive4peace/

    Then post back with specific issues you encounter as you begin developing your database.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    Thank you both of you.
    I will try and will comment here soon.

  5. #5
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    Should I download a Access software on the Internet?
    Last edited by cotton2014; 06-13-2016 at 06:20 AM.

  6. #6
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: I want to make a database program, how can I start for?

    No - It might be free in Heaven but Access is not a free application around here, it comes as part of Microsoft Office. Go buy it or make do with the functionality available in your (legal?) copy of Excel along with writing whatever VBA code you need.
    Last edited by cytop; 06-13-2016 at 06:37 AM.

  7. #7
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    I finished the studying of the notes which you given me before.
    In sum of my view, I have a little of uncomfortable to start creating the database system.

    1. I don't know how to start to create the database( I knew I'm stupid)
    2. I don't which one is correct, which one is a fluent logic to run the system.
    3. I don't know my concert is correct or wrong.

    Please help me to solve these issues, thank you very much!

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: I want to make a database program, how can I start for?

    If you have acquired the Access software, then I urge you to follow this step by step tutorial to build a database to understand the mechanics. Once you have built the DB from the tutorial, you should have enough basic knowledge to apply to building your own.

    http://fisher.osu.edu/~muhanna.1/837...tutorials.html

  9. #9
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    Quote Originally Posted by alansidman View Post
    Here are two links that should be required reading before starting to build a database.

    http://sbuweb.tcu.edu/bjones/20263/a...sdb_design.pdf

    after reading above, then look at this tutorial

    http://www.accessmvp.com/strive4peace/

    Then post back with specific issues you encounter as you begin developing your database.
    I followed this instruction of you given me the PDF file.
    I finished the studying and made a lot of issues.

    Now, you are giving me another materials of how to set-up database.
    I felt confused now.

  10. #10
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    OR

    Do you understand my English?
    Maybe my English was poor.

  11. #11
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: I want to make a database program, how can I start for?

    If you have followed the tutorials, then you should have enough basic knowledge to start to build your db. I do not know or understand what your specific issues are. If you are looking for someone to do the work for you, then you have arrived at the wrong place. We are here to help with specific problems to get you on the right track. If you have a specific issue with the db you are building then ask away. Otherwise, we have given you all the tools you need to start the build on your own.

    If in further doubt, then design a schema on a piece of paper showing your tables and fields, forms and controls. Then design your queries to gain your output. I hope this is helpful.

  12. #12
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    My problem is i don't know how to start. Then, how to next....

  13. #13
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    I come here for request you help me to solve the problem.

    I don't show my homework here, then ask you to help me do it.
    My answer is absolutely NO.

  14. #14
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: I want to make a database program, how can I start for?

    Go back to Crystal's tutorial and build a table in the same fashion she has shown using the normalization structure detailed in the other tutorial. Once you have your table structure built, then build your forms binding the controls on the form to your fields on the table. I cannot offer any further advise on this issue. You have the tools to build.

  15. #15
    Registered User
    Join Date
    05-10-2016
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    23

    Re: I want to make a database program, how can I start for?

    Hello here,
    I have a question that I don't understand how to do it.
    I repeat it again. It's not my homework.

    You gave me a clear guideline to start how to make a database.
    However, I haven't got a free access software to do my bigger plan of database.
    How can I free to get it on the Internet? Is it very dangerous ?

  16. #16
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: I want to make a database program, how can I start for?

    Access is not a free program. You have to purchase the software and license to use it.

    Here is a link to purchase Access 2016. https://www.microsoftstore.com/store...ctID.323017400

    Here is a link for Access 2013. https://www.amazon.com/Microsoft-Acc.../dp/B00B63E37G

    I believe that 2016 is renewable each year. Not sure exactly how that works.

  17. #17
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: I want to make a database program, how can I start for?

    Please do not ask here for links to get Access for free (see Rule 11 of the Forum Rules).

    If you need a database program but can't afford Access/Office, then there are free alternatives available. OpenOffice (https://www.openoffice.org/product/base.html) and LibreOffice (https://www.libreoffice.org/discover/base/), for example. They don't work exactly the same as Access, but the principles of database design remain the same.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Not sure if I should use excel or a database program
    By baronvonbari in forum Excel General
    Replies: 1
    Last Post: 07-17-2014, 04:00 PM
  2. VBA-How to program sizing and placing Excel window at the start of the program
    By dr.prakash in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2013, 11:45 PM
  3. [SOLVED] Doubleclic on an userform control to start a default program
    By Tom Bollah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2013, 07:04 AM
  4. Can Excel do this or do I need a database program or?
    By ronedwards in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2011, 01:58 AM
  5. What type of /program/database is Excel?
    By ablount in forum Excel General
    Replies: 2
    Last Post: 06-19-2006, 09:45 AM
  6. How to start a VB6 program form Excel VBA macro code ?
    By Øyvind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2005, 12:55 PM
  7. How to start the default mail program using Excel VBA?
    By Michalakis Michael in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1