SOLUTION: Lone Star College Airplanes Information in Boyd Air Fleet Project

PlaneModel
B747-400
Dash8
Dash8
B737-800
A319
B777
A319
A319
B737-800
B737-800
B777
B747-400
B777
A319
A319
B737-800
B737-800
Manufacturer
Boeing
De Havilland
De Havilland
Boeing
Airbus
Boeing
Airbus
Airbus
Boeing
Boeing
Boeing
Boeing
Boeing
Airbus
Airbus
Boeing
Boeing
Length
231’10”
107’9″
107’9″
129’6″
111’0″
242’4″
111’0″
111’0″
129’6″
129’6″
242’4″
231’10”
242’4″
111’0″
111’0″
129’6″
129’6″
FirstClassSeats
24
0
0
12
8
30
8
8
12
12
30
24
30
8
8
12
12
CoachSeats
544
70
70
150
116
450
116
116
150
150
450
544
450
116
116
150
150
InServiceDate
1/1/2013
3/1/2012
2/20/2013
10/1/2015
1/1/2016
9/25/2010
6/1/2015
8/1/2016
7/25/2015
11/10/2012
6/1/2017
4/1/2013
12/1/2014
4/4/2018
7/30/2019
10/29/2018
2/25/2019
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-16.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.
a. Click the Enable Editing button in the Message Bar at the top of the
presentation so you can modify it.
b. 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.
a. Use the Table button to create a new table. Do not make any changes to
the ID field.
b. 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-19
This table lists the different data types to select and the field names to be
typed in each of the fields
Data Type
Field Name
Short Text
PlaneModel
Short Text
Manufacturer
Short Text
Length
Number
FirstClassSeats
Number
CoachSeats
Date & Time
InServiceDate
c. Save the table as Fleet.
3. Edit the field properties of the Fleet table using the information in Table 1-20.
Table 1-20
This table lists the different field names and the associated text to be typed in the
Caption and Size properties
Field Name
Caption
Size
ID
Aircraft ID
N/A
PlaneModel
Model
25
Manufacturer
20
Length
7
FirstClassSeats
First Class
N/A
CoachSeats
Coach
N/A
InServiceDate
In-Service
N/A
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 InService field. The table should look similar to Figure 1-123.
Figure 1-123 Records sorted on In-Service field
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

Purchase answer to see full
attachment

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
SOLUTION: Lone Star College Airplanes Information in Boyd Air Fleet Project
Post Your Own Question And Get A Custom Answer
Hire Writer
Written Assignments
Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Why Choose Us?

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Professional Academic Writers

Over the years, our Written Assignments has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keeps up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention to deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Written Assignments, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Customer Support 24/7

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@writtenassignments.com.

Try it now!

Order Now to Get 20% Discount

We'll send you the first draft for approval by at
Total price:
$0.00

How our best essay writing service works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Written Assignments has stood as the world’s leading custom essay writing paper services provider. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Cheapest Essay Writing Service

At Written Assignments, we prioritize all aspects that bring about a good grade such as impeccable grammar, proper structure, zero plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.

Admissions

Admission and Business Papers

Be assured that you’ll get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.

Editing

Editing and Proofreading

Our skilled editing and writing team will help you restructure your paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.

Coursework

Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as many details as possible in the place order section.