Boyd Air is a national airline company.


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.

[Student Learning Outcomes 1.2, 1.3, 1.4, 1.5, 1.6]

File Needed: AC2019-IndependentProject-1-6.accdb (Available from the Start File link.)AirplaneDataFile-01.xlsx (Available from the Resources link.)

Completed Project File Name: [First Name.Last Name]-AC2019-IndependentProject-1-6.accdb

Skills Covered in This Project

  • Create a blank database.
  • 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.
  1. Open the AC2019-IndependentProject-1-6 start file.
    1.  Click the Enable Editing button in the Message Bar at the top of the presentation so you can modify it.
    2.  The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  2. Create a new table and add fields into the table.
    1.  Use the Table button to create a new table. Do not make any changes to the ID field.
    2.  Enter the remaining fields into the table using the information in Table 1-19. After you enter the last field name, InServiceDate, press the down arrow key to remain in that column.Table 1-19DATA TYPEFIELD NAMEShort TextPlaneModelShort TextManufacturerShort TextLengthNumberFirstClassSeatsNumberCoachSeatsDate & TimeInServiceDate
    3.  Save the table as Fleet.
  3.  Edit the field properties of the Fleet table using the information in Table 1-20.Table 1-20FIELD NAMECAPTIONSIZEIDAircraft IDN/APlaneModelModel25Manufacturer20Length7FirstClassSeatsFirst ClassN/ACoachSeatsCoachN/AInServiceDateIn-ServiceN/A
  4.  Save and close the table after updating the properties.
  5. Import data from Excel into the Fleet table.
    1.  Launch the Get External Data – Excel Spreadsheet dialog box.
    2.  Locate and select the AirplaneDataFile-01 Excel file downloaded from the Resources link.
    3.  Append the records to the Fleet table.
    4.  Launch the Import Spreadsheet Wizard.
    5.  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.
    1.  Change the Font Size to 12.
    2.  Select the entire datasheet and use AutoFit to adjust all the fields to their correct size.
      Datasheet view of Fleet table displays 17 records.Figure 1-123 Records sorted on
      In-Service field
    3.  Center-align the Aircraft ID, First Class, and Coach fields.
    4.  Remove the gridlines.
    5.  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-123.
  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.
    1.  Title: Boyd Air Fleet Data
    2.  Author: Marcus Sampson
    3.  Company: Boyd Air
    4.  Click OK to save the changes.
  15.  Close the database.
  16.  Upload and save your project file.
  17.  Submit project for grading.
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Benefits of our college essay writing service

  • 80+ disciplines

    Buy an essay in any subject you find difficult—we’ll have a specialist in it ready

  • 4-hour deadlines

    Ask for help with your most urgent short tasks—we can complete them in 4 hours!

  • Free revision

    Get your paper revised for free if it doesn’t meet your instructions.

  • 24/7 support

    Contact us anytime if you need help with your essay

  • Custom formatting

    APA, MLA, Chicago—we can use any formatting style you need.

  • Plagiarism check

    Get a paper that’s fully original and checked for plagiarism

What the numbers say?

  • 527
    writers active
  • 9.5 out of 10
    current average quality score
  • 98.40%
    of orders delivered on time