Question about Microsoft Access 2002 for PC

1 Answer

How to create a program using ms access?

How to create a program using ms access in simple inventory?

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 174 Answers

You need to study the basics of database programming. take short courses for database programming.

Posted on Dec 04, 2008

  • Florenn Baggao Dec 04, 2008

    you need to study the basics of database programming. take short courses for database programming.

×

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to develop online inventory system for a iron sail shop and which programming language is good for inventory and which database ? and php, mysql can help?


Thank you for using FixYa
Hello I see that you may be leaning toward open source, and that is a good idea for your inventory. Of course MySql will work. You could use MS Office Access, or Oasis is another good one. My previous experience has been that people hear all these big names about databases and might not even need one that expensive. Are you determined to write this one yourself or do you have a programmer in the family or are you going to pay for one? It depends on how extensive your inventory is, if you are looking at less than 500 to 1000 items then these programs may really be overkill. It is surprising how many small businesses are actually running on Quickbooks. You can take a program like that and others similiar and use just the inventory module. Some people might even be able to get by with Microsoft Works or other smaller programs. Most database programs have templates that may not be exactly like your business, but allow modification to the templates to make it more like your own. I hope this was useful and please comment if this was helpful to you.

Apr 26, 2011 | Computers & Internet

1 Answer

Can you give sample source code of visual foxpro program using mySql as database flatform


Create a connection: lcStringCnxRemoto = "DRIVER={MySQL ODBC 3.51 Driver};" + ; "SERVER=200.1.1.1;" + ; "PORT=3333;" + ; "UID=booking;" + ; "PWD=booking;" + ; "DATABASE=booking;" + ; "OPTIONS=131329;" lcStringCnxLocal = "DRIVER={MySQL ODBC 3.51 Driver};" + ; "SERVER=localhost;" + ; "UID=root;" + ; "PWD=clave;" + ; "DATABASE=booking;" + ; "OPTIONS=131329;" SQLSETPROP(0,"DispLogin" , 3 ) lnHandle = SQLSTRINGCONNECT(lcStringCnxLocal)
Accesing data:
SQLSETPROP(0,"DispLogin" , 3 ) lnHandle = SQLSTRINGCONNECT(lcStringCnxLocal) IF lnHandle > 0 cmd = SQLEXEC(lnHandle,"select QuantityRooms from roomtype","cur_roomtype") IF cmd > 0 BROWSE ELSE AERROR(laErr) MESSAGEBOX("Can't connect to mySQL. Error: " + CHR(13) + laErr[2]) ENDIF USE IN cur_roomtype SQLDISCONNECT(lnHandle) ELSE AERROR(laErr) MESSAGEBOX("Can't connect to mySQL. Error: " + CHR(13) + laErr[2])
ENDIF
Creating complex sentences:
TEXT TO lcSQLcommand NOSHOW SELECT Inventory.inventoryid, Inventory.date, Inventory.roomtypeid, Inventory.sold, Roomtype.descrip, Roomtype.rooms FROM inventory Inventory INNER JOIN roomtype Roomtype ON Inventory.roomtypeid = Roomtype.roomTypeID ORDER BY Inventory.date DESC ENDTEXT cmd = SQLEXEC(lnHandle,lcSQLcommand)
Passing parameters to a query:
nValor = 12 cmd = SQLEXEC(lnHandle,"select QuantityRooms from roomtype where roomtypeid = ?nValor","cur_roomtype")
Calling a Stored Procedure:
SQLEXEC(lnHandle, "call myStoreProcedure(@param1)")
GOOD LUCK!

Mar 17, 2011 | Microsoft Visual FoxPro Professional...

2 Answers

What is ms-excel


ms excel is a program that you can make graphs and set up all sorts of things like prices at a petrol station on the front neon sign you can set it up that each time the price rises it will automatically increase that rise in dollars and cents
hope this helps

Feb 15, 2011 | Broderbund Learn MS Windows XP and Excel...

1 Answer

Choices available to create database of c++ program


Hi,

You should use the MySQL database as it is free to use and has great functionalities.

go to the belo link to get details about creating database and using in ur c++ code.

http://c-programming.suite101.com/article.cfm/using_a_mysql_databases_with_c


Thanks!

Mar 31, 2009 | Computers & Internet

1 Answer

Rating Teachers Behavior Inventory


You could assemble a simple Excel spreadsheet and then total, average, find the mean, standard deviation, trend or a host of other answers or information. You can lock the spreadsheet so no one can tamper with it or change the structure. That would be much easier than creating a special program unless there is a specific reason to do so.

Mar 21, 2009 | Microsoft Computers & Internet

2 Answers

Create an inventory prog. in visualbasic?


Do you have Microsoft Office? There are some excellent Access Templates for Inventory Databases

Jan 13, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

How to create a program using ms access?


access has a complete tutor built in id do the course press F1
and ask.

hope this helps

Dec 13, 2008 | 2001 Ducati 996 R

3 Answers

Connectivity between HTML page and Ms-Access


<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>

Nov 11, 2008 | Microsoft Office Standard for PC

3 Answers

Ms access


before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.

Nov 14, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Access 2002 for PC Logo

Related Topics:

3,246 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...