1 / 17

Creating a Database

Access Tutorial. Creating a Database. Launch Access. Start Programs Microsoft Office Microsoft Office Access 2007. Click ‘New Blank Database’. Click ‘Browse Folder’ under Blank Database. Navigate and Name the File. Navigate to YOUR Network Folder Use the filename Evans Students

sereno
Download Presentation

Creating a Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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!

More Related