Results 1 to 4 of 4
  1. #1
    shish is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    3

    I want to learn database programming

    Hello, I want to learn database Programming. But where and how to start?



    The type of database application I want to develop is something that can run super shops, saloons, movie rental services and office management programs.

    Actually, I found MS access can do maximum of what I want, but the bad part is I don't like its interface and it doesn't look unique( you have to open ms access all the time to enter into database).

    My application will allow user to enter data from different computers in LAN and update automatically. Its report might contain pictures as well as graphs. There would be print option too.

    Database part is totally new to me, previously I've just worked on algorithms in C++ and doing programming contests(Like ACM, IOI). Is mixing VB with access a good choice? If so, it would be better for me as I can work on access a little bit.

    What other languages those mix with access?

    Please suggest me a total guideline from start to be capable of making such kind of application.And kindly suggest me an easy process which can be learnt quickly by me. It would be nice if you can mention the learning resources too.

    Why quickly? As I want to keep myself on algorithms and do a part time job in a database company or form myself a little one to support my tuition fees.

    Thanks in advance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Start with the 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/

    One of them discusses converting Access db to a runtime version, end user would not need Access program to run the app. I have seen Access apps that don't look like they are Access file.

    Review http://office.microsoft.com/en-us/ac...010341717.aspx

    Get books. You might find this one of interest: Access™ 2007 Programming by Example with VBA, XML, and ASP by Julitta Korol, Wordware Publishing, Inc.

    Take class.

    There are many template databases available to learn with and modify.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    shish is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    3
    Thanks for your valuable reply.
    Will I be able to print memo's like super shop through this?
    How much data can be processed by access. Is there any limit?
    Would you kindly mention the source of those database templates ?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Access has reporting output functionality. I don't know what super shop is.

    Access has a file size limit of 2gb.

    Database templates are all over the the web, including Microsoft website. Google: Access database Northwind. It has been used in numerous tutorials.

    Open Access to create a new database and some templates are presented for selection.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Learn MSAccess by playing MSAccess Jeopardy
    By pkstormy in forum Sample Databases
    Replies: 4
    Last Post: 11-17-2016, 07:27 AM
  2. Need help designing database and programming
    By meissnerb in forum Database Design
    Replies: 1
    Last Post: 04-11-2012, 04:32 PM
  3. trying to learn visual basic
    By darklite in forum Programming
    Replies: 7
    Last Post: 08-24-2011, 02:18 PM
  4. Replies: 27
    Last Post: 06-25-2011, 07:33 PM
  5. Access Novice - Looking to learn from scratch.
    By Javaman in forum Database Design
    Replies: 1
    Last Post: 03-13-2010, 08:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums