Dmadere Week 4

Certificate

File:Dmadere certificate.PDF

Microsoft Access Protocol

Creating A Database

1. Open Microsoft Access
2. Select "Blank Desktop Database" to get started on creating a database
3. Rename the File using a unique identifier and press "Create"

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

Writing A Query

1. Select the "Create" tab in the top of the application
2. Select "Query Design"
3. In the "Show Table" box, select all the data to create query with and click on "Add"
   • The data should now show up in the Query Design page
4. Look for correlations in each data set
   • In this example, link the data sets together by clicking and dragging the "ActionTypes_LookupID" from the ActionTypes_Lookup box to the "ApplicationDocsID" in the ApplicationDocs data set
   • Drag the "ApplicationDocsTypeID" title to the "ApplNo" title in the Products box to link those data sets
     • The data will now show a connection between the linked sets
5. Drag specific items from the chart to the bottom of the Design Query page to add it to the field
   • Do this for each linked item to see the resulting query