A More Advanced Database Illustration – Access …（更高级的数据库例子u2014u2014访问u2026）.pdfVIP

A More Advanced Database Illustration – Access 2010 3.1 Introduction and Checklist This illustration is taken from a form designed for data abstraction from medical records of women diagnosed with breast atypia. The form is intended to collect information to determine risk for developing breast cancer using the “Gail Risk,” a scale that rates risk based upon pregnancy and breastfeeding history along with race, ethnicity and menstrual history. The data abstraction form is shown on page 4. A completed MS Access database for data entry of data collected on this form consists of “tables”, “forms”, “combo boxes”, “macros” and “modules”. The following chart is an orientation to this jargon. MS Access Database Elements Table A table in Access is what we think of as a “spreadsheet” containing the actual data Form You can create an Access form that looks the same or nearly the same as your data collection instrument (the paper form). LookupTable, Combo box, combo drop function: Providing a drop down list for the user to use during data entry is a 3 step process: (1) create a table containing response list and codes – a “lookup” table (2) create a combo box; and (3) create a macro that instructs MS Access to open the list automatically when the field is entered. Module with combo box function: This is an instruction to MS Access that tells MS Access to provide a drop down menu to the user when he/she is doing data entry. Macro to maximize: This is an instruction to MS Access that tells MS Access to maximize the form for the user so that it fills the screen when the form is opened. Macro to observe skip patterns: This is an instruction to MS Access to skip the user to the appropriate “next” query when a skip is desired. MS Access 2010 Example V2.Doc - 1 - Checklist for MS Acces