QUESTION 4 DATABASE Let’s analyse the same data in Access. Open the database 4_Stats. Open the tblComparison table and then make the following changes: 4.1 Change the Elevation (m) field to a more suitable data type. 1 4.2 Set a suitable field as a primary key. 1 Save and close the table tblComparison. 4.3 Create a form based on the table tblComparison and save it as frmComparison. 2 4.4 Delete the details in the form header and then do the following: 4.4.1 Add the Logo.bmp picture as a logo in the header. 1 4.4.2 Add the text Highest Mountains next to the logo. Font colour must be Blue-Gray, Text 2 and the font size 16pt. 2 4.4.3 Change the background colour of the header section to white. 1 Save and close the form frmComparison. 4.5 Create the following query: 4.5.1 Which high mountains are the most popular to climb? Create a query to show the 3 mountains that are higher than 8500m and have been ascended the most. Save the query as Popular. Show only the fields Mountain and Elevation. Sort the query in descending order according to total ascents. 3 Save and close the query. [11]
Blog
INSTRUCTIONS: Close all applications AFTER you have save…
INSTRUCTIONS: Close all applications AFTER you have saved your work. Click on SUBMIT QUIZ at the bottom of this page. This will close your test and after that you need to click next which takes you to the “quiz” upload where you need to upload all your files.
Read the scenario below that describes the background to the…
Read the scenario below that describes the background to the practical tasks you are required to perform. SCENARIO Former Navy rescue swimmer Brian Dickinson was roughly 1 000 feet (305m) from the summit of Mount Everest – also known as the death zone – when his Sherpa, Pasang, became ill and had to turn back. Four hours later, Brian solo summited the highest peak in the world. But the celebration was short lived. Suddenly, without warning, his vision became blurry, his eyes started to burn and within seconds, he was rendered almost completely blind. All alone at 29 035 feet, low on oxygen, and unable to see, Brian was forced to inch his way back down the mountain.
Which imaging technique is most likely to visualize a struct…
Which imaging technique is most likely to visualize a structure beneath a calcification?
Bending of a transmitting sound beam after it passes through…
Bending of a transmitting sound beam after it passes through one medium into another describes:
Which of the following changes will improve axial resolution…
Which of the following changes will improve axial resolution?
PRF refers to the ______ of pulses occurring per second.
PRF refers to the ______ of pulses occurring per second.
Which receiver function includes enveloping and rectificatio…
Which receiver function includes enveloping and rectification?
Is the wall filter set too high, or too low in the following…
Is the wall filter set too high, or too low in the following image?
As the Cold War intensified in the 1950s and 1960s the threa…
As the Cold War intensified in the 1950s and 1960s the threat of _____ was a real possibility.