Quote:
Originally posted by oncetherewasabo
Probably the wrong topic, but here goes. For one of my classes we are to create a microsoft access database. Unfortunately, the professor never showed us how to use access in any way, shape, or form. The database isn't too complicated, it's just that I have no idea how to do anything in access. Basically, he wants us to create a gradebook that he can use to enter in students grades. What he wants is a gradebook where he can enter in the students grades while also entering in information on what tasks and objectives of each assignment were completed by the student for optimal feedback. He briefly explained what tables we are suppose to use. Actually, we're not supposed to use them, but he just gave an example. 1) A students table with fields of SSN, First and Last Name, and Email Address. 2) An assignments table with the assignment ID and name. 3) Tasks with fields of id description and instructions (tasks are just the different parts of each assignment) 4) Objectives with fields of ID, Description, and Point Value. The objectives are just the course objectives given in the syllabus. For example, each assignment includes many different tasks and each task fills numerous course objectives. There is also a table of student_assignment, assignment_task, and task_objective. Somehow we're suppose to link two tables together to form the last three? I'm sure this is making absolutely no sense to anyone, but I'd really appreciate it if someone with access could help me out a bit, this is really stressing me out. This database requires no real bells or whistles, just the basics. THanks in advanced and if you need any clarifications (i'm sure you do), let me know.
|
The first step is creating the Database.
1. Go into Access and when the first prompt comes up, click on Create new Database using Blank Database then name it something.
2. You will now need to create some tables to hold the data. I would probably create the tables in Excel and then import them into Access. Make sure you have a heading row for the file with the names of columns like Student Name, Social Security Number, or whatever. Don't put any extraneous information in the files. It should only include a header row and then the data right under it.
3. When you are done creating the tables in Excel go to the "Tables" tab in Access. Use the "File" pulldown and choose "Get External Data" and choose "Import". This will allow you to browse for your files. Make sure you change the default "Files of Type" to "Microsoft Excel". A prompt will come up for the importation of the data. Choose "First Row Contains Column Headings". Click Next and say you want it added into a "New Table". You then can format the data to some extent while importing it by designating it text or numbers and the like.
4. Once you have your tables imported, you will need to link them. If each table has a unique identifier (let's say the social security number is in all three tables) you need to use that to link the two tables to create the third. Go to the "Queries" tab. Choose "New" and "Design View". Now double click on the tables you need to combine. This will pop those tables onto your workspace and show you the various columns in each. Drag the unique identifier from one table to the same unique identifier in the other table. This will draw a line between the tables linking those two fields. In the toolbar there is a symbol with two spreadsheets overlapping (Query Type). Click the arrow next to this symbol and choose "Make Table". Then name the table that will be created. Choose which fields from the two tables you want to appear in the final table by double clicking on their names. This will bring the names down to the lower portion of the screen. When you run the query (By pushing the exclamation point symbol on the tool bar) your new table will be created.
I think these instructions will get you started. I'll be in meetings all day so I won't be able to offer any other help today. Good luck.