Home
Blog
Access 2019

Access 2019

Daniel Kevins

0 comments

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.

Create a new table and add fields into the table.

Use the Table button to create a new table. Do not make any changes to the ID field.

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`

Save the table as Fleet.

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

Save and close the table after updating the properties.
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.
Open the Fleet table in Datasheet view. Your table should contain 17 records.
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.
3. Center-align the Aircraft ID, First Class, and Coach fields.
4. Remove the gridlines.
5. Save the changes to the layout.
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.

Figure 1-123 Records sorted on In-Service field
Remove the sort criteria.
Use the Search box to find Dash8.
Delete the value from the Search box.
Close the Fleet table.
Do not save any of the changes as a result of sorting or filtering the table.
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.
Close the database.
Upload and save your project file.
Submit project for grading.

About the Author

Daniel Kevins

Follow me