Difference between revisions of "Dmadere Week 4"
Jump to navigation
Jump to search
(→Microsoft Access Protocol: added another protol) |
(→Microsoft Access Protocol: added instruction subtitles) |
||
| Line 7: | Line 7: | ||
== Microsoft Access Protocol == | == Microsoft Access Protocol == | ||
| − | === Creating A Database === | + | === Creating A Database=== |
| + | === Loading Data Tables === | ||
# Open Microsoft Access | # Open Microsoft Access | ||
# Under the "External Data" tab at the top, select "Text file" | # Under the "External Data" tab at the top, select "Text file" | ||
| Line 22: | Line 23: | ||
# Select "Finish", and then "Close" | # Select "Finish", and then "Close" | ||
# Repeat steps listed above to load all FDA data | # Repeat steps listed above to load all FDA data | ||
| + | |||
| + | === Writing A Query === | ||
Revision as of 21:24, 25 September 2019
Contents
Certificate
Microsoft Access Protocol
Creating A Database
Loading Data Tables
- Open Microsoft Access
- Under the "External Data" tab at the top, select "Text file"
- 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
- 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"
- Select "Finish", and then "Close"
- Repeat steps listed above to load all FDA data
