CIS100 Information Technology Skills Assignment

Assignment Help Basic Computer Science

Reference no: EM132982825

CIS100 Information Technology Skills - Emirates College of Technology

LO 1: Produce well-looking presentations to illustrate information utilizing textual, graphical and animation effects.

LO 2: Understand the file structures and Create a database using DBMS.

Question 1: File, data structure and Database

Need to do in access and put screen shot below each question

Tables
1. Create a new Access file and save it with my name:
2. Create a table with at least four fields to hold any domain that you suggest. The table should contain fields with different data types. (e.g. "Date/Time", "Short Text", "Number", "currency" and "Yes/No").
3. Save the table with a significant name.
4. Insert 5 records in the table.

Queries
Create the following queries based on your table:

1. Query that views all fields of your table that have one field equal to specific value. Save it as Query1.
2. Query that views specific defined fields of your table with field has value less than an exact value. Save it as Query2.
3. Query that views all fields of your table and has one constraint based on the field with "Short Text" as data type. The field should start with letter "A". Save it as Query3.
4. Query that views specific defined fields of your table with field has value in range of two values. Save it as Query4.
5. Query that views specifics defined fields of your table that have two constraints with relationship "and". Save it as Query3.
6. Query that views specifics defined fields of your table that have two constraints with relationship "or". Save it as Query4.

Forms
1. Create a justified form that views all records based on your table. Save the form by "Faisal AlGhafri _TableForm".

2. Create a tabular form that views all records based on a query you choose from those you created above. Save the form by "Faisal AlGhafri _QueryForm".

Reports

1. Create a tabular report based on your table that views all information. Save the report by "Faisal AlGhafri _Report".

2. Create a Stepped report based on your table that views all information classified by one field with any summary calculation. Save the report by "Faisal AlGhafri _Summary Report".

Attachment:- Information Technology Skills.rar

Reference no: EM132982825

Questions Cloud

Which lines is correct for ann ltd to account for the costs : Costs of issuing these 20,000 shares amounted to $5,000. Which of the following lines is correct for Ann Ltd to account for the costs of issuing the shares?

How much will you have to invest today : You may want to own a home one day. If you are 20 years old and plan on buying a $200,000 house when you turn 30, how much will you have to invest today

Which consolidation entry to eliminate transaction in year : The consolidation entry to eliminate this transaction in the year ended 30 June 2021 would include which of the following line items?

Should you purchase the system outright : Your firm can borrow at an interest rate of 6% APR with monthly compounding. Should you purchase the system outright by paying $150,000 now

CIS100 Information Technology Skills Assignment : CIS100 Information Technology Skills Assignment Help and Solution, Emirates College of Technology - Assessment Writing Service

What the correct consolidation data adjustment entry is : With regard to the copyright asset, the correct consolidation data adjustment entry is? Fiona Ltd obtained control of Belinda Ltd on 1 January 20X2

At what value should the land be recorded : On December 22, Obermayer Repair Service was offered $157,000 for the land by a national retail chain. At what value should the land be recorded

Applicable hrm concepts and theories : You are a consultant to the HR manager of an MNE with operations in several countries.

Prepare journal entry in records of thomas ltd to account : Prepare the journal entry in the records of Thomas Ltd to account for the above acquisition. Thomas Ltd acquired a parcel of assets and liabilities

User Account

All Pages