Access Assistance

8 ~ ; Table Tools AC2016 -1- 2 -Tru ck mg-solut1 o n : Dat ab.. Sign In

File Create External Data Database Tools Fields Table Q Tell me what you want to do

~~- Cut T ~ l Ascending T Selection ... = [j f~ Copy i l Descending ''i;;J Adv anced • View Paste • Filter

~ Format Painter z. Remove Sort T Toggle Filter

I@] ""'New 2 p ab Calibri (D et ail) . 11 --, ac - ,- ~ Sav e ~ ~· B I .!! ~~ >'IT !ffl.

Refresh Find ~. Jli,. • al), ~· [:ijl. A ll • X Delete . - - - Views Clipboa rd r. Sort & Fil ter Reco rds Fin d Text Formatti n g r.

:'.j Drivers .,_-,-------r------,--------,-----...----A ll Access Obje ... 0 «

Search... P D river ID • FirstName • LastName . LicenseNumber • CellPhone . Cl assificati on . YearsExpe rience

T ables

em Drivers ml Trip s Bi Trucks

':J Tru<lks

1 Bob 2 Mary

4 Jenn ifer 1-1-----­

( New)

Ra lly

Adams

Smith

Fi el d Name Data Type 'il TrucklD A ut o N umb e r

TruckDe scri pt i o n Sh ort Text

M ake Short Text

M o d el Short Text

M o de lYe ar Nu mb e r

A ssetTag Nu mb e r

Pu rcha se Pri ce Cu rr ency

Pu rch ase Dat e Dat e/ Tim e

I I

3845987 555-987-4555 Leve l 6

2844121 555-457-6997 Leve l 5

3781287 555 457-1147 Leve l 4

X

I Descri ption (Opti ona l ) ~ Un i qu e ID for ea ch t ruck Des cri pti o n (si ze, type, co l or)

M anu fa ctu r e r

M anu fa ctur e r's m od e l

E.g., c013

Comp any's asset t ag numb er

Pri ce p ai d fo r t ruck

Dat e th e t ruck w as bo ught

r

,. X

• Clic

4

2

0

Project Learn Microsoft® Office 2016 Access REVIEW PROJECT 1.2

Review Project In this Review Project you will help Samson Trucking manage an Access database for its fleet of trucks. One view of the finished database appears in Figure 1.42.

Objectives Reviewed 2. Create a Table by Using Design View 3. Add, Edit, and Delete Data 4. Modify a Table’s Structure

FIGURE 1.42

1. Open the data file AC2016-1-2-Trucking.accdb. If the workbook opens in Protected View, click the Enable Editing button 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.

3. Create a new table called Trucks, using the information from Figure 1.43.

Step 1 Download start file

FIGURE 1.43

a. b. c. d. e. f. g. h.

Chapter 1: Introduction to Microsoft Access 1 Last updated: 12/14/2017

:J Trfps X Fi el d Nam e l Dat a Typ e I Descr ipti on ( Opti on al) ~ \] Tri plD AutoN umb er Un i que ID fo r ea ch t ri p

Trn cklD N um ber ID of t ru ck u se d for th e t r ip

Driv erlD N umb er ID o f driv e r o f t hi s t ri p

De liv eryD at e Dat e/ Ti m e Deliv ery dat e fo r trip

Dest in at i o n Sh ort Te xt Co mp any, city, st at e

Mi l es N umb er M il es f ro m de p ot t o d estin at i on

Loa dW eight N um ber W eight i n p oun ds

I I

Project Learn Microsoft® Office 2016 Access REVIEW PROJECT 1.2

4. Create a new table called Trips, using the information from Figure 1.44.

FIGURE 1.44

a. b. c. d. e. f. g.

Step 2 Upload & Save

Step 3 Grade my Project

5. Open the Drivers table in Design View and create an index that allows duplicate values for the

driver's "LastName" field.

6. Switch over to Datasheet View and add a new driver record for Jennifer Smith, license

3781287, and cell phone 555-457-1147. She is a novice driver with a classification of Level 4.

7. While you are in the Drivers table, delete Jerry Pintovski’s record, as he has been let go from

the company.

8. Add a new field to the Drivers table object that will store each driver’s number of years of

experience. Call the new field YearsExperience and give it a Number data type.

9. Enter the data for this field that is shown in Figure 1.42.

10. When you are finished, click Close to close the database and exit Access.

11. Upload and save your project file.

12. Submit your project.

Chapter 1: Introduction to Microsoft Access 2 Last updated: 12/14/2017