I would like to create a Access 2007 database to track all my meetings and keep track of who attended them. What would be the best way to structure my database to do that?
What is the best way to structure a meeting database?
Depending on your knowledge of Access and the time you have to commit to creating a database you have two routes:
1. Use the templates provided in Access (both on and off line) to find a ‘Contact Management’ style that meets to your nearest requirements. Follow the links and prompts and you have a database ready to go. You will probably need to modify and enhance certain objects (fields, queries and reports) so some knowledge of Access will be required.
2. Plan, design and implement a database from scratch! If you have the time and knowledge this will be the best approach as you control everything from the start. But as I say it will require some of your time. To help decide if you feel comfortable, take a look my articles using this link http://www.about-access-databases.com/database-design.html
Hope this helped
Ben Beitler
I heard the guy was depressed and was then manipulated by the terrorist group.
So
If terrorist groups are just going around manipulating vulnerable people so they can be used as a their puppet who is really at fault?
the person manipulating?
OR
the person being taken advantage of?
OR
both?
Should the young man be put in jail
OR
Rehabilitated at a mental institution?
this young man is an intelligent human being and has been taught right from wrong. his father approaching the u.s. embassy proves that. in my opinion he is responsible for his actions!
I have an arduino decimille (a circut board) and it is programmed in C. I sort of learned very basic programming with it but now i need it to input data (the results of an on/off switch) into a database.
What free database programs can i use that will accept input from a program written in C?
mySQL with ODBC
I have not been able to access my Yahoo emails from within the Yahoo sign up for over a week. I am VERY FRUSTRATED.
change your password
The Marine Tattoo Policy.. http://usmilitary.about.com/od/marines/a/tattoo.htm
Generally speaking it is BEST not to have any "body art"…..even when they let you in…..it can limit your assignments
How can I combine
select distinct ids from studenttable
……………then for each id…………………
select top 1 * from studenttable where id = @id order by timestamp desc
……into one T-SQL statement (IE without using loops/queues)?
BTW I meant cursors not queues
Give this a try:
SELECT a.* FROM studenttable a,
(SELECT id, MAX(timestamp) FROM studenttable GROUP BY id) b
WHERE a.id = b.id and a.timestamp = b.timestamp
I don’t mind helping out the teens and younger folks, but sometimes, I’d really just like to find some interesting debates from real adults. But it’s almost impossible to dig through all the teenage questions to find anything of real substance. I think it would be helpful if Yahoo added an option to select an age group for the question. Any other thoughts?
Yeah, sounds great, but then the teens would just lie about their age, like they do everywhere else.
I have a DSi and I don’t know how to insert the SD card into my computer. Can I insert it into my camera then insert the camera’s USB wire into the computer?
Yes it should work just fine but there should also be a sd slot for your card but u said u didnt want to do that so ya it should work by doing wat u want to do
How do I make a Database using MS Access to organize movies with my clients who rent them?
Need to set up a few tables and have them connected to each other. From customers who rent them out to the inventory of movies that are on the shelf.
if found a description, which seems to be pretty exhaustive, here:
http://www.docstoc.com/docs/7161561/Movie-Rental-Online-Project
I hope this is a start
I’m doing this UIL Computer Applications test and it want me to add a field to the select query that says AMOUNT = Rate from the ToolsRented table and multiply it by DaysRented from the ToolsRented table. Me and my UIL coach tried to find something in the office help but came out empty handed. So if anyone has a the correct form please tell me. Me and my coach think there is a typo in the test itself. Thank you for ur help.
In QBE you would add a ‘calculated expression:’
AMOUNT: [Rate]*[DaysRented] to the next available column in the Select row
Writing it in SQL:
SELECT [Rate]*[DaysRented] AS AMOUNT FROM ToolsRented
No Typo there