Child ID Access

Quick video guide steps to create your first table in Microsoft Access 2007. How to create a database table.

Duration : 0:4:5

(more…)

I have MS Office 2003, and as far as I can tell, it was supposed to be included (Access 20003), but is not….I need it. Not enough to buy, but shouldn’t there be an upgrade or an option…well, I just need a trial run. Please! Help me out

You know I meant 2003

Make sure that:

1) The version of Office you have is 2003 Professional. That’s the only one that comes with Access.

2) Acess has actually been installed (assuming that you do indeed have Office Pro). Go to Start –> Control Panel — > Add or Remove Programs, Click on Microsoft Office 2003 Professional, click the "Change" button, choose "Add or remove features" and click Next. This gets you to a list of all the applications that come with Office 2003 Professional. If the check box next to Access isn’t checked, check it and click Update. Then follow the on-screen steps to install Access. You’ll probably need your setup CD, so make sure you have it handy.

Task and project management software for Microsoft Access. Works great with the free version of Access.

Duration : 0:5:41

(more…)

How can I add a counter to a combo box in access so that I can graph the data of choices selected? Thanks

I haven’t done this, but I don’t think there is a counter you can plug in and use for this. You will probably have to write one.

I imagine a system that user sees as being the same and getting the same result, but a step or two in the interim is added. In the After Update event, you have code that carries the selection to a separate table and increments the counter on the selection and then proceeds on with the normal process.

The graphing would be a separate process activated independently, unless this graph is the purpose of having the combo box in the first place. In that case, it could be all put together.

You don’t mention how much detail you need, so I don’t know how deep into the process to go. That is how I would conceptualize the solution.

I have to create a relational database using microsoft access for the school swim team, displaying times, meets, etc. The only problem is I’ve never used Access before and have ZERO clue how to use it! I’ve been trying to do research on my own for several weeks now but everything I’ve found online has been very confusing. The database has to be relational and must include things like queries etc. any tips?

How do i create a relational database using microsoft access?

Creating an Access ‘relational’ database is not an intuitive process and as already correctly pointed out but requires a bit of learning and some research.

I hear what you say regarding ‘confusion’ when reading about this topic and hopefully I can provide some help (which is not confusing) on my website.

Take a look at http://www.about-access-databases.com and look at this page to start with http://www.about-access-databases.com/database-design.html (Designing and implementing). If you follow through the links this should start to shed some light on the matter.

In any event, it will take some planning and understanding before building the database and this is something only you can invest your time into.

If you need some help and further clarification on my topics I recommend, please feel free to email.

Good luck.
Ben Beitler

Microsoft Access 101 video tutorial – part 6

Duration : 0:3:51

(more…)

how to convert string to integer in microsoft access (vb) im planning to make a calculator one more thing how to use the trim function?

string to integer conversion: cint(expression)
a% = cint(" 55")
results in a% equal to 55.

a$ = trim(string/string variable)
a$ = trim(" this is a string ")
results in a$ equal to "this is a string"

I was told that you can find a phone number with just the address with Microsoft Access. I have never used this software before, so I was just wondering if it was true. And if so, how would you proceed?

There’s really many ways to do it. I’d have a table with all of the relative contact information I needed to track (ex: name, address, city, state, zip, phone number). And then I would create a form to input this data into the table. I’d have a separate button on my form I’d use to search for data I needed (such as the phone number) by way of a query that would access the table.

I need a FREE program similar to Microsoft Access. Thanks.

I’d have a look at OpenOffice. It’s an entire office suite that’s very similar to MS Office, and it’s 100% free. One of the programs included with OpenOffice is called Base, and it’s a free version of Access. It may even be able to open Access database files (I’m not certain of that, though).

Go to www.openoffice.org to download a copy! It works with Windows, Mac, Linux, and a bunch of others.

Microsoft Access Different Query Table Joins

Duration : 0:4:11

(more…)