Work & Academics

Part 1: Setting up the data

1. Open Access and select New, then Blank Database
2. This will open a save dialog prompt (you have to save your database before you can start using it)
3. Once you save your database, you’ll get a window that looks like the following:

4. Depending on what you are most comfortable with, you have three choices for creating your table.
5. If you are comfortable with spreadsheet-type applications, double click on “Create table by entering data”—you can explore the other options later.
6. Selecting that option will bring you to a screen that looks like this (Click on image to see full-size):

7. On that screen you can start entering your data, just as you would in a spreadsheet.
8. You’ll notice that at the top of the table, it says “Field 1″, “Field 2″ and so on. Double-clicking on those lets you rename them to reflect what is actually contained in them. So, you can double-click and rename it to “First Name”, “Last Name” and so on.
9. Click the “X” to close the table. It will ask you to save the table. It will probably also ask you something about a primary key. Just go ahead and accept it, title the table with a meaningful name and you’re almost done.

Pages: 1 2 3 4