Dmadere Week 4

Certificate

File:Dmadere certificate.PDF

File:Dmadere FDA database.zip

Microsoft Access Protocol

Loading Data Tables

1. Open Microsoft Access
2. Under the "External Data" tab at the top, select "Text file"
3. Browse and select the data to enter in the database
   • Make sure "Import the source data into a new table in the current database" is selected if there is not a table created yet in the database
   • Select "Delimited", then "Next"
   • Select "First row contains field names" if the first line of data is the title of each row
   • Go through each specific data tab and make sure the correct "Data Type" is selected, then click "Next"
     • Short text - refers to less than 50 characters (used in case there are any errors after importing)
     • Integers - refers to any numbers
4. Primary Key
   • If there is no key identifier that the data has, then select "Let Access as primary key". For the sake of this assignment, select "Choose my own primary key" since there are already identifiers
   • Once selected, make sure it is corresponds to the correct data tab, then click "Next"
5. Select "Finish", and then "Close"
6. Repeat steps listed above to load all FDA data