Create a database containing one table about airplanes

Assignment Help Database Management System

Reference no: EM131428412

Independent Project 1-6

Boyd Air is a national airline company. For this project, you will create a database, containing one table, to store information about the airplanes in Boyd Air's fleet. After creating the database, add fields into the table, edit field properties, import data, modify the datasheet layout, and find data using the Search box. This project has been modified for use in SIMnet.

Skills Covered in This Project

Create a table.
Edit the default primary key.
Add new fields into a table.
Edit properties in Datasheet view.
Save a table.
Import records.
Change the datasheet layout.
Sort data in a table.
Find data using the Search box.

IMPORTANT: Download the resource file(s) needed for this project from the Resources link. Make sure to extract the file(s) after downloading the resources zipped folder. Please visit the SIMnet instant help for step-by-step instructions.

1. Open the AC2016-IndependentProject-1-6 database start file.

a. Enable content in the security warning.

b. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.

2. Create a new table and add fields into the table.

a. Do not make any changes to the ID field.

b. Enter the remaining fields into the table using the information in the following table. After you enter the last field name, InServiceDate, press the down arrow key to remain in that column.

c. Save the table as Fleet.

3. Edit the field properties of the Fleet table using the information in the following table.

4. Save and close the table after updating the properties.

5. Import data from Excel into the Fleet table.

a. Launch the Get External Data - Excel Spreadsheet dialog box.

b. Locate and select the AirplaneDataFile-01 Excel file (downloaded from the Resources link).

c. Append the records to the Fleet table.

d. Launch the Import Spreadsheet Wizard.

e. Finish the Import Spreadsheet Wizard. Close the Wizard after the records have imported.

6. Open the Fleet table in Datasheet view. Your table should contain 17 records.

7. Change the layout of the Fleet table.

a. Change the Font Size to 12.

b. Select the entire datasheet and use AutoFit to adjust all the fields to their correct size.

c. Center-align the Aircraft ID, First Class, and Coach fields.

d. Remove the gridlines.

e. Save the changes to the layout.

8. Sort the Fleet table in descending (newest to oldest) order according to the In-Service field. The table should look similar to Figure 1-120.

9. Remove the sort criteria.

10. Use the Search box to find Dash8.

11. Delete the value from the Search box.

12. Close the Fleet table.

13. Do not save any of the changes as a result of sorting or filtering the table.

14. Add the following database properties.

a. Title: Boyd Air Fleet Data

b. Author: Marcus Sampson

c. Company: Boyd Air

d. Click OK to save the changes.

15. Close the database.

16. Upload and save your project file.

17. Submit project for grading.

Attachment:- Assignment.rar

Reference no: EM131428412

Questions Cloud

Discuss about the consequences of french revolution : Discuss about The Consequences Of French Revolution. Introduce the history background of French revolution. show positives and negatives of French revolution.

What is the skill and what steps would the behaviorist use : Describe how that behaviorist would teach an adult a new skill. Be specific; what is the skill and what steps would the behaviorist use?

Should these places be blamed for that or is this : The Jews and others who were targeted by the Nazis had obviously heard the unprecedented level of hatred from the 3rd Reich. Some tried to flee but were not permitted to enter the US and other places in large numbers. Should these places be blamed..

Would you have joined a resistance : Along those lines, many chose not to flee the rising tide of the German war machine. If it were you, would you have fled? At what point would you have fled? Where would you have gone? Would you have joined a resistance?

Create a database containing one table about airplanes : Boyd Air is a national airline company. For this project, you will create a database, containing one table, to store information about the airplanes in Boyd Air's fleet

Why is criticism from others a barrier to creative thinking : 1. Are making quick decisions always a bad move? When is this not the best route - Why is criticism from others a barrier to creative thinking?

Discuss three aspects of us history since 1865 : Introduce your paper with your previously crafted thesis statement.Discuss two (2) international events involving the US military from the past five (5) years that can be traced back to a foreign policy created after the Civil War.

Discuss specific aspects of the freedom movements of the 50s : Discuss specific aspects of the freedom movements of the 50s and 60s that you believe paved the way for the election of Barack Obama in 2008. Highlight at least one (1) specific piece of legislation and at least one (1) leader who contributed to i..

Local broad cost leader : Local Broad Cost Leader - Low priced products for the local region: our brands offer solid value. Our primary stakeholders are bondholders, customers, stockholders, and management.

User Account

All Pages