Question Details

Answered: - DIS 102: Microsoft Access Assignment 1. Create a Microsoft


DIS 102: Microsoft Access Assignment


Hi,kindly see attached and assist.

Kind Regards,






DIS 102: Microsoft Access Assignment

 

1. Create a Microsoft Access document

 

Computer System Sale Report

 

For this database project, you will use Microsoft Access to create an INVENTORY table

 

for a hardware store, which contains more than 10 records with the fields listed below.

 

DESIGN YOUR TABLE STRUCTURE (without using a wizard ? as shown below):

 

Field Name

 

Item ID

 


 

Data Type

 

Text

 


 

Width

 

5 chars.

 


 

Other Information

 

Primary Key ? may contain alpha and

 

numeric, the first character must be

 

an upper case letter. You create this,

 

do not use autonumber.

 


 

Description

 

Vendor ID

 

List Price

 

On-Hand Qty

 

Item Type

 


 

Text

 

Number

 

Currency

 

Number

 

Text

 


 

20 chars.

 


 

4 chars.

 


 

Long Integer

 

Leave decimal places as 2

 

Long Integer

 

Codes must be validated, and must be

 

formatted in upper case. Codes are:

 

SOFT, HARD, ELEC, or OTHR.

 

Default value is OTHR

 


 

On Sale

 


 

Yes / No

 


 

In this project, you will:

 

1. Design the Table Structure

 

2. Enter the Data

 

3. Create Two Queries of your own from the table and give each query a

 

heading of your own (remember to indicate the questions used for your

 

query).

 

4. Create a report for your table

 

Print and hand in your work as a hard copy

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185478.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now