Dmadere Week 4

Certificate

File:Dmadere certificate.PDF

Microsoft Access Protocol

File:Dmadere FDA database.zip

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 (in this case, ActionTypes_Lookup)
   • 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
   • For the purposes of these instructions, load also ApplicationDocs and Products

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

Acknowledgements

• I worked with my homework partner Naomi this week in class to complete this assignment. We talked about the assignment in class and texted about it as well if anyone needed help.
• I also consulted the LinkedIn learning page for any help with learning the Microsoft Access protocol. [LinkedIn Learning]
• I also worked on this project in class with Dr. Dahlquist where she provided us the knowledge we needed to complete the assignment.
• "Except for what is noted above, this individual journal entry was completed by me and not copied from another source." Dmadere (talk) 22:56, 25 September 2019 (PDT)

References

• Assignment protocol as listed by LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4