Sunday, March 20, 2011

Creating Access

Step 1. Open up access and create new BLANK database called the Exam Name.
Step 2. Click on External Data, then Text File.
Step 3. Then import steps 2,4. (If your in Mr Wells class you will get it.)
Step 4. Then browse for the file in my case it was J8prods, then click finish.
Step 5. Then right-click on the tab in the top left and click on Design View.
Step 6. Change the categories to what you need to, however on the 08 and previous exams they made a mistake so you need to change the Yes/No to Text to keep the Y's and N's. You don't need to do this for exams past 2008.
Step 7. Click continue on the next few bars that come up, it will display a gray screen. Double-click on the name of your database and you have finished Q1.

No comments:

Post a Comment