Creating a Database

1. Access Tutorial Creating a Database

2. Launch Access • Start • Programs • Microsoft Office • Microsoft Office Access 2007

3. Click ‘New Blank Database’

4. Click ‘Browse Folder’ under Blank Database

5. Navigate and Name the File • Navigate to YOUR Network Folder • Use the filename Evans Students • Click ‘OK’ • Click ‘Create’

6. Save the New Table • Click the Save Button • Name the Table -- Students

7. Creating Fieldnames in Design View • Click the View Button • Choose Design View • Create the first 3 Fieldnames:

8. Nothing to do – Just Learn This: Even though the data that will be in the Student # field is numerical in style, the student numbers are never going to be calculated, so the data type should be ‘Text’. Other examples of this rule include: • Social Security # • Model # • Telephone # • Employee # • Zip Code

9. Creating Fieldnames in Design View Create fieldnames 4, 5, 6, 7: * Wait for teacher to help you with the Input Mask

10. Creating Fieldnames in Design View Create fieldnames 8, 9, 10: *Wait for teacher to help you with ‘Input Mask’ and ‘Lookup’

11. Creating Fieldnames in Design View Create fieldnames 11, 12: *Wait for teacher to help you with ‘Lookup’

12. Save the Table Design Click the Save button Click the View Button, choose Datasheet View Switch to Datasheet View Enter your info as the first record

13. Create Another Table in This Database • Click the Create Tab • Click Table • Click the Save Button • Name the Table Birth Info • Switch to Design View

14. In Design View, Create the Fields Create the first 3 fields:

15. In Design View, Create the Fields Create fields 4, 5, and 6:

16. Save the Table Design Click the Save button Click the View Button, choose Datasheet View Switch to Datasheet View Enter your info as the first record Enter your information, Save, and Close

17. And that’s how it’s done, folks!