Homework Access Week 5

xlsx

School

University Of Denver *

*We aren’t endorsed by this school

Course

4155

Subject

Information Systems

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by AgentZebra835

Use the provided data to address the required tasks in Access. Based on the data structure, decide whether a primary key needs to be added to the table for good structure. If so, add th column. If not, do not add another primary key. If there is an issue with the import, fix that is in Excel and complete the Import to Access. Submit the Access file as your submission for this week's work. Q1: Import the table to Access. Save this table as Q1 in Access. Use a calculated field to creat date variable that is formatted as Short Date. Q2: Import Q2a to Access. Format the Sales in a currency format. Save the Table as Q2Appen Then, use the append option to add the data from Q2b to append the additional data to the Q2Append information. Q3: Import Q3 to Access. Name the table Q3. Add a column to this table called "Fruit_or_Nut and format it as text. In this column, type either 'Fruit' or 'Nut' based on the type of tree that described in this Column.

his ssue s te a nd. t" t is

Sale_Year Sale_Month Sale_Day Sale_Amount 2024 1 10 $ 1,083.00 2024 1 15 $ 1,326.00 2024 1 20 $ 1,106.00 2024 1 22 $ 1,691.00 2024 2 3 $ 1,328.00 2024 2 15 $ 1,223.00 2024 2 18 $ 1,354.00 2024 2 21 $ 1,576.00 2024 3 7 $ 1,208.00 2024 3 9 $ 1,893.00 2024 3 19 $ 1,236.00 2024 3 19 $ 1,792.00 2024 4 3 $ 1,437.00

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Car_Part_Number Car_Part_Name Car_Part_Price T_03513 Fuel Cap 15 T_84164 Oil Filter 30 T_84216 Oil Drain Plug 16 T_02456 Air Filter 25 T_45620 Alternator 168 T_22045 Head Light 10 T_43851 Radiator 689

Car_Part_Number Car_Part_Name Car_Part_Price T_0000 Rearview Mirror $ 18.00 T_0001 Sideview Mirror $ 65.00 T_0002 Trailer Hitch $ 55.00 T_0003 Front Bumper $ 156.00 T_0004 Rear Bumper $ 245.00

Tree_Id Tree_Name C_0001 Walnut C_0002 Apple C_0003 Cherry C_0004 Hazelnut C_0005 Chestnut C_0006 Pear

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Homework Access Week 5

Related Documents