Exp19_Access_AppCapstone_Comp – Drivers 1.0 | Access_Application_ Capstone _ Drivers_

#COMPREHENSIVE #Access #Excel
Exp19_Access_AppCapstone_Comp – Drivers 1.0 | Access_ Application Capstone Drivers | Access_ Application Capstone Drivers
Contact us
Whatsapp +92306-7065210
Email; [email protected]
Exp19 Access AppCapstone Comp \u2013 Drivers 1 0, #exp19_access_ch10_cap - drivers, exp19_access_appcapstone_comp – drivers 1.0, exp19_access_ch02_capstone - international foodies 1.0
#Exp19_Access_AppCapstone_Comp_Drivers_1.0_Access_Application_Capstone_Drivers#Exp19_Access_AppCapstone_Comp_Drivers_1.0#Access_Application_Capstone
#Exp19_Access_AppCapstone_Comp#Access_ Application Capstone _Drivers_#Exp19_Access_AppCapstoneDrivers1.0#exp22_excel_ch03_hoe_jobs#powerpoint_1g_northern_lights#Application_Capstone_Comp_Drivers#Openthefilenamed#Exp19_Access_AppCapstone_Comp_Drivers


Exp19_Access_AppCapstone_Comp – Drivers 1.0
Exp19 Access AppCapstone Comp Drivers 1.0
Access Application Capstone - Comp Drivers

Project Description:
In this project, you will add fields to a table and set data validation rules. You will also import a text file into a database, design advanced queries, and create a navigation form. Additionally, you will use SQL to modify a record source and create an embedded macro to automate opening a report. Finally, you will create a pie chart in a report.

Start Access. Open the file named Exp19_Access_AppCapstone_Comp_Drivers. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

You have discovered that the insurance company data that you want is stored in an external text file, so you will import the file as a table in the database, and not need to design the table from scratch.

Create a table in the database by importing the downloaded delimited text file named Insurance_Text.txt. Use the first row of the file as field names, use InsuranceID as the primary key, and then name the table InsuranceCos_Text. Accept all other default options. Do not save the import steps.

You will modify a table to add fields that store the websites and photos of agents, add a lookup field, and set data validation to ensure that valid values are entered in a field.


Create a new field in the Agency Info table after Website named AgentPhoto with the Attachment data type. Save the table. In Datasheet view for Record 1 (William Smith), add the downloaded picture file named WmSmith.jpg to the AgentPhoto field.

Set the validation rule of the InsuranceCo field to accept the values AS, NAT, or SF only. Set the validation text to read Please enter AS, NAT, or SF. (include the period).

Make InsuranceCo a lookup field in the Agency Info table. Set the lookup to get values from the InsuranceID field in the InsuranceCos_Text table. Accept all other defaults and save the table. In Datasheet view, select the first InsuranceCo value, type AT and press ENTER. Click OK in the message box, press ESC, and then close the table.

You will create queries to locate records that have missing values, update values in a table, and delete specific records from the database.

Create a new query using Design view. From the Insurance table, add the DriverID, AutoType, TagID, and TagExpiration fields (in that order). Save the query as Missing Tag Dates.

Create a new query using Design view. From the Drivers table, add the Class field. Change the query type to Update and set the criteria to update drivers whose class is Minor to Junior. Run the query (eight records will update). Run the query again and note that there are no records to update. Save the query as Driver Class_Update and close the query. View the updates in the Drivers table and close the tab


SAM Keywords #Ch6IndependentProject #Simnet #independentproject4-6

#NP_EX19_1a_FirstLastName

#NP_EX19_2a_FirstLastName #Excel Module 10 SAM ProjectA

#Excel Module 10 SAM 1A

#Access Module 9 SAM Project B

#Access Module 8 SAM Project B #Access Module 1 SAM Project A

#Access Module 2 SAM Project A

#Integrated Project_1 - Laundry Proposal

#COMPREHENSIVE FINAL EXAM (2HR

60Qs)

#Excel_4G_Aquatics

[ #Exp22_Word_Ch03_CumulativeAsses

sment Academics #Word_1E_Documentary

#Word_1F_Pitch_Festival

#Word_2E_Job_Listings_HW #Exp19_Word_Ch01_Cap_Space

Hammock

#Exp19_Word_Ch01_ML2_Backyard_B

onanza

#Exp19_Word_Ch01_ML1 - Water 1.2

#Exp19_Word_Ch01_HOEAssessment_ #exp19 word ch02 cap assessment personal finance

#Exp19_Word_Intro_CapAssessment_

Research

#Exp19_Word_Ch03_ML1_Football

#Exp19_Word_Ch04_CapAssessment_

Retirement

#Exp22_Word_Ch01_Cumulative_Agric

ulture

#exp19_word_ch04_cap_college #exp19_word_ch03_capassessment_s

moke

#exp19_word_ch03_hoeassessment_r

adio

#exp19_word_ch03_cap_boston

#exp19_word_ch02_hoeassessment_