Project #6140 - Acess tablets

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

 

 

 

 

 

 

 

 

 

 

Subject Computer
Due By (Pacific Time) 05/14/2013 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy