Other Homework Help

Shoreline Community College Create and Manage Database Access Database Lab

 

  • As you design your database, think about what the goal may be for the database, what data may be needed to meet that goal, and what the primary key may be for your database table.
  • Create a database named “Patient” that contains 8-10 fields including one calculated field.
  • Enter data for your database either directly in Access or use Excel and import.
  • Make sure to review Design View to see of your fields are properly formatted and mark the Primary Key.
  • Submit a copy of your Patient database (include your name in the file name).
  • Summary. When you submit your assignment, provide a short summary (~250 words) of your database goal, design, and why you selected the fields you did including the primary key in a WORD document.