Child ID Access

This is a database developed to track Customer orders, products, production, payments and shipping for a small business.

Duration : 0:7:28

(more…)

See a higher quality video on TechTutor.TV! A new blank database can be created easily by using the opening Access 2007 screen. In this tutorial, you will learn how to create a new blank database in Access 2007. See higher quality tutorials all for FREE at http://www.techtutor.tv!

Duration : 0:2:0

(more…)

I am wondering if there is a way on how to connect a Microsoft Access database to an online MYSQL database (they both run with mysql so it should be possible)

Create a Data Source using the Data Source Manager in the Administrative Tools area of Windows. After that, Created a Linked Table in Access, point it to the data source you created, and pick the tables you’d like to link.

How to add a media Player to Access Database

Duration : 0:2:24

(more…)

i’v taken input from the user in a form.. and i want to save that info in MS Access database… can anyone help?

Try to read this:

http://www.webmasterworld.com/forum88/11830.htm

Here is a login system using a access database

questions, comments and requests to kreativedevelopments@hotmail.co.uk

Duration : 0:8:2

(more…)

I would like to connect our pdf’s to a database so that when the pdf is filled out it populates the related fields in an access database. Currently we have acrobat 9 standard and I am an acrobat novice so the more detailed you can be the better.

Thanks.

This much, I can tell you: It’s possible.

I’ve personally never done such a thing, as most of the PDF’s I send out are populated with data in another format, then created.

You will need a good understanding of Javascript to pull it off, as that is the language Adobe pairs a PDF with. Here’s a link to get you started:

http://www.adobe.com/devnet/acrobat/javascript.html

I don’t imagine that it is very easy to do, which is why I’ve never even thought to try.

Best of luck though…

I’d like to make a google earth map from my Access database, with a minimum of hand-coding into KML. My data is simple – it includes cities, states (but not ZIP). I’d like to plot dots for each city and state on the map. Is there a software solution for this?

As far as i know, there is no pre-existing solution that will do what you want to do. I have come across several Excel to KML solutions, however each assumes you already have the coordinates for the plotpoints. This is really the core problem you’ll run into, as though the Google Earth program supports the ability to lookup by address, the KML file format requres the use of latitude and longitude corrdinates.

This doesn’t mean your at a dead end though. One longer solution is to export your data to excel, then use the free service at http://www.geocoder.us to convert the addresses to latidude and longitude, and add to the spreadsheet. Finally use the included macros to generate the required KML file. If you have alot of points or you need to do this frequently, it could be more trouble than its worth.

If you have programming experience, you could automate the process; the geocoder.us site allows remote procedure calls designed for programmers.

The biggest limitation you’ll find is that the addresses are valid only for US addresses, and it is based on data that is about 7 years old, so very new addresses may not be valid.

If your looking for coordinates for actual cities, you might try wikipedia instead; most have corrdinates listed for each cities applicable page.

Good luck.

Natalie Silver is a Microsoft Access instructor in the Computers and Technology Program of the Division of Continuing Education at Kennesaw State University. In this video, she gives an overview of Microsoft Access and compares its features with those of Microsoft Excel.
http://www.kennesaw.edu/coned/computers/

Duration : 0:2:29

(more…)

We take reservations and credit card payments for each order entered in to a access database. We normally run the charges on the next day. Now we’re trying to run them at time of reservation. Is there a way to do this from access?

Most credit card companies can provide you with a SDK (software development kit). Usually there is a VB version. So you could write the code in Access to process the credit card.
Check with your Merchant Account.