2006-08-25 03:23:39 · 5 answers · asked by rishi k 1 in Computers & Internet ➔ Programming & Design
You have the wrong program, you need to use Access for this. You can then create your table, by opening a new database.
Make sure the tab, of your new database, with the name 'Tables' is showing, select 'New' on the right, select 'Table wizard' and you should be able to create the table.
For the query, select the 'Queries' tab, and select 'New', then select '... wizard'. There are a few wizards in here, select the one that looks most appropriate, or try them all and see which one is best.
2006-08-25 03:52:13 · answer #1 · answered by Mark aka jack573 7 · 0⤊ 1⤋
I think I understand your question but it is admittedly rather vague so there's not much to go on. However, I have made many worksheets over the years that might be what you're looking for.
I face a problem in my work network where macros are blocked for security purposes. Yet I still have an internal demand amongst employees to view specific datasets in a variety of ways that would normally call for macros. So I have devised a means of delivering them without macros.
The principle is simple, one set of data with multiple "keys" which can be sorted and used for lookups. I have one I just finished last week for distributing monthly flight schedules. Those who receive the worksheet can use any one of FOUR pull-downs to build the display by, origin, destination, airline or weekday.
I have used the same basic principle for distributing various set of data such as global port codes, client-specific shipments and for a support contact listing. Use possibilities are limitless.
If you (or anyone else reading this post) want a sample, please send me your email address. Tell me in the message you want a copy of the query tool. I'll send you it right away.
Regards,
QwertyKPH @ yahoo!
2006-08-26 15:55:34 · answer #2 · answered by qwertykph 4 · 0⤊ 0⤋
We need more info on what you are trying to do.
Excel can do so much its mind blowing.
Are you trying to create a list of information and then show a chart based on the listed info or part thereof?
2006-08-25 10:37:19 · answer #3 · answered by pcpracticum 2 · 1⤊ 1⤋
I'm not sure what you mean. Create your table and then go to "Edit" > "Find" or use the wizard to create charts.
2006-08-25 10:29:59 · answer #4 · answered by john b 5 · 0⤊ 2⤋
Just tell me what type of query u want to create.
Is it SELECT, UPDATE, DELETE.
2006-08-25 10:38:11 · answer #5 · answered by dipak 2 · 0⤊ 2⤋