Open the file NP_AC16_2a_FirstLastName_1.accdb, available for download from the SAM website.· To complete this Project, you will also need to download and save the following support files from the SAM website:

Open the file NP_AC16_2a_FirstLastName_1.accdb, available for download from the SAM website.· To complete this Project, you will also need to download and save the following support files from the SAM website:

· Save the file as NP_AC16_2a_FirstLastName_2.accdb by changing the “1” to a “2”.

· If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

· To complete this Project, you will also need to download and save the following support files from the SAM website:

· Support_NP_AC16_2a_Clients.accdb

· Support_NP_AC16_2a_Location.txt

· Support_NP_AC16_2a_Billing.xlsx

· Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS
You are employed at Healthy Myles Fitness Center and are in charge of consolidating the company’s records and other important information into a database. You have already set up the basic structure of the database, and you are now updating some information and creating relationships to make information more useful and easier to locate.

Open the tblTrainer table in Design View, and then set the field properties shown in Table 1 on the next page. Be sure to set the TrainerID field as the primary key for the table.

Table 1: tblTrainer Table – Field Properties

Field Name Data Type Description Field Size Other
TrainerID Short Text Primary Key Caption: Trainer ID
FirstName Short Text 20 Caption: First Name
LastName Short Text 25 Caption: Last Name
Interests Long Text
Add a new field to the table after the Interests field. Use the following options (some of which may already default to the values shown below):

a. Field name: Minors

b. Data Type: Yes/No

c. Format Property: Yes/No

d. Caption Property: Accepts Minors

e. Default Value: No

Delete the College field from the table. Save the tblTrainer table. (Hint: Click the Yes button when warned that you are about to delete one record, and click Yes again if you are warned about potential data loss.) Switch to viewing the tblTrainer table in Datasheet View.

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.