I need help with my database project.

 

Thanks,

Lesley

 

Database Project (25 Points)Goal:There are a number of uses for databases. This assignment provides you with an opportunity tolearn a common data base program by creating a simple database.Database Activity with Microsoft AccessCreateBlank Access databaseClickOKName the new file, then clickCreateSelectCreate table in Design ViewUnderField nameType inPatient Nameand selectTextunderData typeRepeat this step to create the remaining text fields.For numeric fields, select "Number" for their data type.SelectViewthenDatasheet View. Clickyesif the pop-up window asks to save the tableor if it ask to create the primary key.Under thePatient Namefield, type in Test Patient One. Fill in the rest of the data byselecting the cell and type in appropriate data.Once you have entered all the data save your document.You now should have all of the data enter in the database table. The next two features will showyou how to manipulate your data view by sorting and filtering your data.Sorting the RecordsSelect the column that you want to use as a criteria for sorting.SelectRecords -- > Sort -- > Sort Ascending or Sort DescendingFiltering the RecordsOne of the basic features of any database is that it should allow you to look at a subset of yourdata, based upon some criteria. When you perform a filter, you hide all records that don't conformto your set of criteria. For example, in an address list, you might want to only look at addressfrom a particular city or state, or you might want to only see addresses within a range of zipcodes.Below is the example question.Question: Which patient had a diagnosis of vertigo?ChooseRecords -- > Filter -- > Advance Filter/Sort...from the menu bar.SelectDiagnosisfrom theFieldarea.

Attachments:

• 1496741417-Database Project1.docx