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

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • 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
    Florenn Baggao Dec 04, 2008

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

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Repair MS Access database without having program installed


Use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more: https://access.recoverytoolbox.com/

Oct 18, 2015 | Microsoft Office Business & Productivity...

1 Answer

What is MS Publisher 2007? How to create FLYERS using MS Publisher? How to create BROCHURES using MS Publisher? How to create NEWSLETTER using MS Publisher?


Publisher is a program that makes it easier to make "posters" and "brochures" and "newsletters".

Start the program. Click "New". Click "start a new FLYER", or "start a new BROCHURE", or "start a new NEWSLETTER", to use some of the pre-defined templates that define the layout of your publication (fan-fold, multi-column, et cetera).

Feb 03, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

I have MS office installed on my PC but somehow have lost MS Access. How to reload MS Access ?


Hello:
First, verify that you have the correct version of Microsoft Office. Microsoft Access was only included in the Professional version of Microsoft Office 2003.
Second, Microsoft Access is probably still on your computer, but you no longer have a shortcut to it. You can create one by following these instructions:
  1. Open a file browser by navigating to Start>Computer (Start>My Computer on XP)
  2. Navigate to C:\Program Files\Microsoft Office\Office 11\
    (C:\Program Files (x86)\Microsoft Office\Office 11\ on x64 systems)
  3. In this folder is a file called MSACCESS.exe. This is Microsoft Access.
  4. Right-click on the file.
  5. Hover/click on the "Send To" option.
  6. Click on the "Desktop (Create Shortcut)" option.
  7. You now have a shortcut to Access on your desktop.

Jan 31, 2011 | Keystone Microsoft Office 2003 Essentials...

1 Answer

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-


1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

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

1 Answer

Creation of a dynamic web page


Okay, you can't do that with just Office 2003 professional. You'll need to install and configure the dotnet framework on your machine first, and then you could use infopath to create forms to work with, say, something like MS Sharepoint. You could use MS Frontpage to create an online form and link it with an Access database, but you will not need the dot net framework for that. It's easy and Frontpage is pretty intuitive.

Here are the basic instructions for using MS Frontpage: http://office.microsoft.com/en-us/frontpage/HP052812481033.aspx

You will also need webspace or a webhost that will support Microsoft ASP web hosting.

If you haven't done this before, it may be easier to get a professional do it for you, using either Microsoft or PHP/MySQL based technologies. It will certainly be time efficient.

Oct 18, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Ms access


Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.

You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.

For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.

Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

1 Answer

MS ACCESS


How to Evaluate the rows in MS Access

Sep 18, 2007 | Microsoft Office Standard for PC

1 Answer

I want to create tables in ms access


because access is such a complicated programme, to reply to your question would take an age, so go to the site below for help on how to use it. http://office.microsoft.com/en-us/access/FX100646921033.aspx

Aug 25, 2007 | Microsoft Office Standard for PC

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

Related Topics:

3,239 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

Les Dickinson
Les Dickinson

Level 3 Expert

18297 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

Loading...