Question about Access database 4 small business. (Inventory, etc.)  (Just point me in the right direction)?
967929
Best way is to have 2 tables.  A header and details table.\n\nThe header table will have one row per sale.  Key field would be invoice number.\n\nThe detail table will have details of each sale.  One row per item.  Key field would be invoice number and item number\n\nJoin field would be invoice number.
167195
The previous answer is correct - however, unless we're talking about a high volume of data, I prefer to use an MS Access backend database instead - I think it's easier to maintain.\n\nHowever, as the previous respondent said, the key is finding an ISP whose platform supports your platform.
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
492576
Can u elaborate the problem, The MS-Access has it own built in SQL building routine, if this is not solving your problem, then please explian the kind of connectivity or query u are passing so that i can understand it better..!
479077
CREATE DATABASE [Database Name];\n\nWithout knowing the scope of your question, that is all there is to it.
643171
This forum will probably lack the comprehensive information you need.  The materials provided with the Access program can get you started, however I suggest visiting a book store for a "How TO" instructional book.\n\nDo a search for "Microsoft Access" on amazon.com as a starting point.\n\nOn the web, research these sites:\n\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr051202.htm (About Databases)\nAccess Database Too Big! \nAccess Database Too Big!\nhttp://databases.about.com/b/a/222380.htm (About Databases)\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr060902.htm (About Databases)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 2/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401b.htm (About Delphi Programming)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 1/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401a.htm (About Delphi Programming)\nBuilding an Access Database From the Ground Up \nIn this series of ten Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/od/buildinganaccessdatabase/index.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals \nhttp://databases.about.com/b/a/139756.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals\nhttp://databases.about.com/b/a/243511.htm (About Databases)\nBuilding an Access Database From the Ground Up \nIn this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm (About Databases)
254134
I believe Access SQL supports the TOP keyword as below.  This will allow you to easily limit the number of records.\n\nSelect TOP field1, field2, field3\nfrom mytable1 m1 left join mytable2 m2\n on m1.field1 = m2.field4\nwhere field1 = 'value'
988113
i can design it for u plz send me the detail  that what type of inventory system u want (e.g. Normal, Medium, Large) and in which language. Where u have to submit it at DLP or Regular College.\nhoping 4 ur reply.
232872
try out this site. Has good level of information about using access databases\n\nhttp://www.fgcu.edu/support/office2000/access/\n\nhttp://www.nvcc.edu/home/dmickey/tutorial/\n\nyou can also learn a lot about access simply by reading its help files \n\nhope this helps
957966
click here:http://en.wikipedia.org/wiki/Database_management_system
121676
u want database managemenet oor batabase management?\nIf Data\n     Login To www.A1VBCode.com \nThere You Can Download lot of progrmas Based On Tat\nDon't Forget to choose the best Answer ...
584486
A database does not have to be that complicated. It can be a great help, especially if you can carry it around with you. \n\nIn its simplest form, a database is simply a structured way to organize information. This might be a list of customers, sales figures or even how far you drove to meet with a client. Software for your Windows Mobile powered Pocket PC or Smartphone allows you to access and update that information from anywhere and sync it with the data stored on your office computer. \n\nCROSSMARK, which helps consumer goods manufacturers and retailers ensure that products are on shelves and priced correctly, uses database analytic tools and Pocket PCs to help its field workers fix problems quickly. \n\nWhen its 13,000-plus field workers visit stores, they do not have to waste time trolling for problems. Instead, its database software finds potential issues by analyzing sales data, and alerts field workers through their Pocket PCs. \n\n"We kind of equate it to having a fire truck driving around looking for a fire," says Charlie Orndorff, vice president of Infrastructure Services for CROSSMARK. "Instead, we tell them where the fires are. Through the mobile technology, we're able to do that." \n\nIn the retail industry where profit margins are razor thin, the use of mobile databases has paid immediate dividends. CROSSMARK was able to boost sales of ready-to-eat cereal and disposable diapers by 3 percent. \n\n"That's huge," Orndorff says, "especially in categories that are as mature as those two categories are. That's a huge win." \n\nWhile CROSSMARK developed a custom application to display the data on the Pocket PCs, you don't have to be a programmer—or a large business—to make use of the technology. There are many database applications available already for Pocket PCs and Smartphones. Even if your company isn't making use of mobile databases, you could find it worthwhile to set up your own. \n\nOne possible use could involve using a database to keep track of your expenses and automatically file for reimbursement. \n\nWithout a database, you have to carry receipts around with you all of the time and a paper notebook to keep track of your mileage. When you sit down with all of the paper at the end of the day, it can be tough to remember which expenses resulted from which clients or projects. And there's always a significant risk you could lose one of your scraps of paper – and its data – before you were able to enter it in a more formal system. \n\nA portable database eliminates those problems. You can enter your expenses as soon as you incur them. You can even add special fields and put expenses into your own categories. You can also add flags to help you itemize your deductions for income taxes. \n\nWhile you could accomplish much of this with Pocket Excel, it is often easier with a database. In order to sort and analyze the data later, you would have to set up columns in Excel for every category of information you would like to collect. Each expense would then be a separate row. \n\nYou would have to be very careful to make sure that you entered everything into the appropriate field in your giant grid, which is not the easiest thing to do with a limited viewing area.
945171
The problem is that Microsoft Access, as I am sure you are aware, is very limited in its use. It is great for hobby projects, and small applications, but for commercial applications, you hit the wall very quickly.\n\nIn MS-Access 2003, a 7-table join is the upper limit. If you want to join more tables in a query, then you have to rethink your design - or denormalise the database, which defeats the purpose of proper design in the first place.\n\nI have written a medium-sized commercial application in MS-Access, but I stretched the limits of what MS-Access could handle, in almost every way imaginable, and I would never want to build a career in programming MS-Access :-)\n\nMy suggestion is therefore... Since you know MS-Access, sell yourself as a VB developer - it should take little time to bring yourself up to speed on the differences in Basic dialects, and you end up with a more robust platform. You could also go for C# or another .Net language.\n\nGood luck :-)
168991
I am assuming you are the one asking the questions.  I have found that the biggest failing database developers have is not using the resources available for code samples. \n\nQ:  Where would you turn for help with creating a stored procedure or a select statement that was erroring out?
1073394
You can migrate to SQL 2000 or 2005. You can even start using Oracle, as a vamp yahoo user told you to. But the question is, do you really need to migrate?\n\nThe locking/inability problems are solved in the Access Startup Menu, where you can set things like refresh time interval between a change in a record made by a user and the time need to the change to be seen across all access database users. Have you explored all the Access database features?\n\nSpeaking of my experience, I have a small  Access database with about 20 000 entries, and no such problems are happening with me.
924206
to display the records from Sales table and Purchase table, do like Monalisa said, but he/she missing 'WHERE' query.\n\nassume :\nCreate Table Sales (Sales_Date date, total integer);\nCreate Table Purchase (Purchase_Date, total integer);\n\nSelect Sales_Date, Total from SALES where\nSales_Date>='10/03/2006' and Sales_Date<='10/09/2006'\nunion all\nSelect Purchase_Date, Total from PURCHASE where\nPurchase_Date>='10/03/2006' and Purchase_Date<='10/09/2006'\n\nNotes :\n'UNION' will eliminate the same records from PURCHASE table.\nto get all records we must use 'UNION ALL' .\n\nTo sum sales and purchase in 3rd to 9th oct  :\n\nSelect sum(A.Total) as TotalSales, sum(B.Total) as TotalPurchase from SALES as A, PURCHASE as B where A.Sales_Date>='10/03/2006' and A.Sales_Date<='10/09/2006'\nand B.Purchase_Date>='10/03/2006' and B.Purchase_Date<='10/09/2006'\n\nps :\nmy query format maybe have a little different with ms Access query format, so if my query can't run in ms Access, try to change it to ms Access query format.
1153856
You can't, you can only build a spreadsheet, or a single table database.  You can use Access to build DB's.\n\nIf you need tuturiols on how to create/manage a Access Database.  See the links below.