Dramir36 Week 4
Jump to navigation
Jump to search
User:Dramir36 template:Dramir36 Skinny Genes
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12/13
- Week 14
- Week 15
Purpose
- understand how to use the Microsoft Access software
- use data from the FDA to find how data analysis is conducted using Microsoft Access
- gain experience with database queries using Microsoft Access
Methods
- Download and decompress the files.
- Import the data files into a Microsoft Access database that is to be created.
- Click on the "External Data" ribbon, and in the "Import & Link category, click on "Text File"
- Browse the file that will be imported to the Access database
- Once file is chosen, click "Ok"
- For the first portion, default setting are fine, so click "Next". In the next portion, check the box stating "First Row Contains Field Names" since the FDA data files already contain the names. Click "Next"
- Default settings are ok for the next page. Click "Next"
- For the next page, if the data file already contains an unique ID for each row, then select "Choose my own primary key", if not, leave as is, and click "Next".
- Click on "Finish" to end the Import Text Wizard, and close the pop up window that follows.
