The information below needs to be inputted to Microsoft Access(info in cell below) After info is put into it, it will need modifications…please do modification (Access Assignment).

Access Assignment

• Use the input document to create two tables in Access. You are creating a database for a fitness club.
• The tables in the input document are only data for creating the tables in Access. They are not an example of what the finished product will look like
• The field names for creating the tables are in the first row of each table. They are in bold to distinguish them from the data in the rows below them. They will not be in bold in Access.
• In each table, use the field that uniquely identifies each record as the primary key
• Do not use the ID/AutoNumber field as the primary key. You will select a field from the input tables to be the primary key as described above
• All of the fields will be text data type except the Number of Clients field which will be Number data type and Pay Rate which will be Currency data type
• In the trainer table, use a caption for the Pay Rate field. The caption will be Hourly Pay.
• The fitness club has 3 locations. You will add a lookup field call Location and use codes for the locations as the lookup values. The values are:
  • BR
  • CM
  • LS
• Create a relationship between the tables and apply referential integrity

Last Completed Projects

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]