My First Datebase

Mar 1, 2006

Hi all.

I need to make a database for work.

I used Access many years ago but have forgotten most of what I knew.

I want to make a form for entering data into the table.

For one of my fields I would like the user to only be able to make a selection from a pre-defined list but I would like them to make more than one selection if required.

Example:
Languages:
English
French
Spanish

From that they could choose more than one.

How would I go about doing this.

Would it be done at the form stage?

Thanks.

View Replies


ADVERTISEMENT

Create A New Datebase From An Old One.

Nov 9, 2005

I would like to create a new database from an existing data base with the same fields but I don't want the data. Can anyone give me a step-by step instruction. I also want to duplicate the form as well.
I am currently using ACCESS 2000

View 5 Replies View Related

Datebase Relationships?

Mar 24, 2007

Im having some trouble here. This isn't my very first database but I am creating a database for a customer that does blacksmith work
He wants a customers database, projects he does, inventory he has and even a timesheet all together.

He wants to be able to input all his customers, then as he works on projects he wants to have the projects linked to the customer that ordered it, he wants to have a timesheet database where he can track per project as well as inventory that he uses per project

So I have the databases for each, but I cant figure out how to make a relationship so when you start a project, you can pick which customer the project is for, and even pick the inventory you have that you will use for that project and have it where later you can go to each customer and see which projects that customer had and then go into inventory and see that stuff isn't there anymore because he picked it and used it for certain projects.

Is there any easy way that I can do all this? I got access 2007 and lynda.com access 2003 video training that I am going through. And relationships is where I got stuck.

Anyone? Thank you very much in advance! Im willing to trade services for help from someone. My portfolio : http://portfolio.337studios.com

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved