Question about Microsoft Access 2002 for PC

2 Answers

Ms access how can make data base in ms access and i want to make queries reports with event handling i want to know all features of ms acces give solve otherwise give most site names for free downloading

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer
Re: ms access - Microsoft Access 2002 for PC Business & Productivity Software


Posted on Nov 27, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 167 Answers
Re: ms access

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

7 Answers

MS Access database recovery

Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information:

If doesn't help, look here:

Feb 05, 2015 | Microsoft Office Professional 2007 Full...

2 Answers

Access database was copied now no tables in dropdown list

Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

Using Microsoft Query to bring Access 2007 data into a spreadsheet

Try using Data > From Other Sources and select From Microsoft Query. In the Excel sheet, select the cell that you want the results to start in. Your MS Query would be pulling the data from your Access database.

May 04, 2009 | Microsoft Excel for PC

1 Answer

How to get 1 value from report to another form in ms access

You'll have to use a separate Group By query to get the summed data you are looking for, you cannot pull it off the report.

Feb 06, 2009 | Microsoft Business & Productivity Software

1 Answer


Open the report is design view maximize the screen, in the open space right click. this will open the properties of the report as a whole. click on the all tab you will now look for the data source. you will see a drop down arrow next to the box that says table1. Hit the drop down box and you will see a list of all querys and tables selct the table you want. The report will now access a new data source. You will want to save the report as a new name or else you will not have two reports you will just have changed the first one.

Sep 17, 2008 | Business & Productivity Software

1 Answer

MS access - how to insert a function in a access table

Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!

Feb 06, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer


What are the uses of MS Access??
What are the disadvantages and advantages of MS Access?
What are the MS Access Data Base Objects?
What are the different kinds of toolbars in MS Access and there functions?

Nov 19, 2007 | Microsoft Office Professional 2007 Full...

2 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 | Business & Productivity Software

4 Answers

Running SQL queries on Excel

Another way to do it is to use the SQL Drill freeware Excel addin (

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

1 Answer

MS Access 2003 Development - Format Problem

Hi, the difficulty to solve your problem is that we are not familiar with Appx. I have faced this problem numerous time, but usually it was from Excel to Access. Now if you can transfer it to Excel then you can change the format in Excel to Text and import it into Access. I have also read a little of the Appx manuals and it says there that you can work with ODBC, are you using it? ODBC will create a connection between the APPX application Database and Access, you should be able to do your queries directly from the ODBC connection without the need to import the table. Here is a PDF manual of how to set it up from their website: I hope it helps, let me know and I will try to do my best to solve your problem. Daniel

Aug 10, 2007 | Microsoft Office Standard for PC

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

Related Topics:

266 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides