Describe the advantages and challenges of using a team to develop a Access database?
541520
I am not sure what you are asking like - "Why using a team to develop access? when it can be done by one person" or "What are pros and cons of Access Database " so i will answer both - \n\n1. Using a team to develop , when it can be done by one person\nAdvantages - \na. database design will be less error prone .. so it will help in developinh error free software over it \nb. good performace can be achieved \nc. it will be done quickly \nDisadvantage - \na. will be wastage of man power \nb. let one create whole and then a quick check by few team member will also do ..  \n\n2. Using Access as a DB tool ( more likely u want this ) \nChallanges - \na. the DB size is limited , so if future expansion is needed u have to change it to some other DB tool (MS SQL Server) \nb. less secure \nc. less concurrency supported \nAdvanatages - \na. quick and good for small projects \nb. costs less \nc. less hardware requirement and easy to maintain \nd. one can easily build forms and queries to facilitate the whole project ..
923774
Since your requirement is simple, I suggest you to better to develop a small program by yourself by using MS Excel or MS Access. These softwares are available in all the PCs.
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..!
187676
Your best bet would probably be a list of checkboxes to match each question.\n\nOnce all the checkboxes have been filled in then submit the form and all the information gets transfered to a database.\n\nDo this as a standalone webpage with a DB backend. Probably something like mySQL or SQL2k, SQL2003 would be your best bet as Access only supports 10 connections at a time and you may overload this if you have multiple people entering data at the same time.
992894
Access is fully programmable, and easy to set up for small databases.  You could probably do this yourself.  I'm not sure you will find an actual "Lost and Found" database, but morelikely find an inventory control or the like.
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.
1029483
Check out Microsoft\n\nOr just Google database design or database normalization.
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.
1012904
I would suggest keep it simple.  You need a plain database ... use Microsoft Access, or even Excel.\n\nIf Excel, you need to be careful while structuring and entering data.  Since Excel is freeform (flexible), some discipline is required for good results.
942246
Try this online tutorial - it is brilliant. Not only does it have downloadable pdf files covering various topics on Access, but also exercises and example databases.\n\nhttp://www.cob.ohio-state.edu/~muhanna_1/837/MSAccess/tutorials.html\n\nHope this helps.
571274
are you updating each individual person? the best way would be to create a database using MS ACCESS that will allow you to update individuals through a GUI system. You use a lookup to find the information of the individual which will be shown through the GUI and then edit them with the changes. Its easier than using a spreadsheet and faster as well.
123133
Microsoft Access is a great prototyping tool.  If you are building an Enterprise level system for thousands of users, you are going to run SQL Server or Oracle.  But, during the design, you can design the tables and relationships in Access and throw together a few forms in minutes and show the customer "what/when/where/how" very easily.  Then, when they say, "no, I want it to do this", you modify it quickly and show them the next idea.\n\nGenerating a visual "working" sample application is all about what prototyping is - and Access is a great tool...
292739
Yes, you can and it's not even that hard!\n\nOracle is a highly scalable and secure relational database system used to maintain business information.
60430
Yes you can use ASP coding with Access database or SQL database to create an online directory of employees. Codings are readily available in http://www.haneng.com/lessons.asp.
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
785252
--being meticulous..\n--not being stubborn (you always have to be willing to learn)..\n--naming conventions for variables, filenames, tables, etc...\n--picking a specific language set to master instead of jack of all   trades...\n--knowing databases schemas\n--understanding how your program interacts with the database through networking.\n--OSI model\n--always thinking about automating in some fashion\n--the better you are at interacting with the user of your program for beginning specs, the better it will be for that person when it is complete (we are smart, but cannot read minds).
117899
Have you tried Crystal XI - they have extended their db access methods. However you could always use ODBC or OLEDB...