fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

CIS5100 Data Structures And Programming

tag 0 Download3 Pages / 630 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

  1. Create a Database and import the four (4) Text files into four (4) Tables
  2. Modify Table Design
  3. Set Primary Keys
  4. Create Relationships between the Tables
  5. Edit Customers Table
  6. Create Data and Update Queries
  7. Create an Invoice Report

Task 1: Create and Import

Create a new blank Access Database (using any version from Access 2007 to current) and name it [lastname] [initial] _ [student number] _ [course code] _ assign1.accdb(eg. genrichr_0050051005_cis1000_assign1.accdb).

Import the four sets of data from your firm’s Intranet.

The easiest and quickest way to import data into Access is by using the Import Text Wizard.  The following steps must be followed carefully to ensure the data is imported correctly:

Importing Tab Delimited Text files into Access (any version from Access 2007 to current) using the Wizard  

  • On the External Datatab, in the Import & Link group, click the Text File data source icon.
  • In the Get External Data - Text Filewizard popup, browseto find the ‘Assignment01 Text File Customers.txt’ text file and select the Import the source data into a new table in the current database option – then click OK.
  • Select the Delimited – Characters such as commas or tab separate each fieldoption on the first page of the wizard - then click Next.
  • Select the Taboption on the second page of the wizard and turn on the First Row Contains Field Namescheck box - then click Next.
  • Set the following for each fieldon the third page of the wizard:
    • Field Name– keep the field name as it appears when imported.
    • In the List of Tables, copy the table called tblItems and paste it with the new name tblBackupItems.

      Create an Update Querythat will raise the Belgium (BE) Cost Price for all items on orderthat are not in stockby 7.25%. It is always good practice to backup any data before running an update or a delete query. The following steps should be followed to achieve this Query:

    Use tblItems for this Update Query, not your back up table tblBackupItems. If you have difficulties with this query and need to restore your data to the original values, you can copy columns as necessary from tblBackupItems to tblItems and start again.

    • Create an Update Querythat will increase the Cost Price (BE)  in tblItemsby 25%for all items currently not in stockbut on order.
    • Include rounding to 2 decimal places with the update calculation by placing the following function around the update formula:  ROUND( update_formula ,2).
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Data Structures And Programming. Retrieved from https://myassignmenthelp.com/free-samples/cis5100-data-structures-and-programming/decision-support-system.html.

My Assignment Help (2021) Data Structures And Programming [Online]. Available from: https://myassignmenthelp.com/free-samples/cis5100-data-structures-and-programming/decision-support-system.html
[Accessed 17 October 2021].

My Assignment Help. 'Data Structures And Programming' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/cis5100-data-structures-and-programming/decision-support-system.html> accessed 17 October 2021.

My Assignment Help. Data Structures And Programming [Internet]. My Assignment Help. 2021 [cited 17 October 2021]. Available from: https://myassignmenthelp.com/free-samples/cis5100-data-structures-and-programming/decision-support-system.html.


MyAssignmenthelp.com is one of the noted service providers that deliver essay help. We provide tailored essay assistance to make sure that student gets online essay help exactly in the way they want it to be written. We at MyAssigemnthelp.com have built teams of consultants, who readily attend every query related to help me writing my essay. We provide essay writing help in forms of tips and steps in order o assist students with tough essay assignments.

Latest Programing Samples

ITECH5403 Comparative Programming Languages

Download : 0 | Pages : 2

Answer: This Hotel Rooms Bookings system has been developed using 3 different programming languages – java, python and Perl. The program is successfully developed in all the 3 languages with the implementation of all the mentioned functionalities for the application. As all the programming languages are developed for different purposes, they provide several in-built properties which are available in one programming language and hence ma...

Read More arrow

BN102 Web System

Download : 0 | Pages : 7

Answer Introduction Bad website design is usually characterized by many factor that do not make website appealing and easy to use. In this case, a discussion of Smith and Goldsmith Inc. rental properties website will be evaluated. An analysis of a good website practices explain that, a good website should be easy to navigate by locating links, should not be too clumsy and should have attractive appearance. All these aspects cannot be traced fro...

Read More arrow

SITIS2 Information Systems And Data Science

Download : 0 | Pages : 7

Answers: Introduction:  A portal development is done by a real estate company. Their current system is analyzed and a report is needed to make in the back-end of that application system. An interview is conducted by the assessor for finding the class specifications utilized in the system. The following report reviews the classes and objects used in the system. 1. Analyzing the behavior of the objects in the application:  1.1. The...

Read More arrow Tags: Australia Concord Management analysing the strategic  tactical and operational levels of online store  The Book Depository University of New 

ITECH1000 Programming

Download : 0 | Pages : 5

Answer: Australia media debated and discussed recently a lot over affordability of own house for first home owners and for a month it was daily headlines of the newspaper, as some individual made a remark that new generation people spends a lot on takeaway coffees and avocado on toasts and if they stop buying it for some time they can save the money for the house deposit. This remark made a sensation amongst new generation’s people and t...

Read More arrow

BN104 Operating Systems

Download : 0 | Pages : 2

Answers: 1a. The comparison between the internal and external fragmentation: EXTERNAL  FRAGMENTATION INTERNAL FRAGMENTATION The fragmentations that are external occur due to the allocation of the processes in a variable sized memory. The fragmentations that are internal generally occur due to the allocation of the process in the fixed sized memory. The fragmentation that are external takes place whe...

Read More arrow
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?