Create a stepped report based on your table

Assignment Help Basic Computer Science

Reference no: EM132516884

BIT100 Introduction To Information Technology Skills - Emirates College of Technology

Problem 1: Database Access

Tables

1. Create a new Access file and save it with your name and ID.
2. Create a table with 4 fields to hold any domain that you suggest. All fields should be with different data types.(5 Marks:1 for primary key, 1 for each field)
3. Save the table with a meaningful 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 Query 1.
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 specifics defined fields of your table that have two constraints with relationship "and". Save it as Query3.
4. 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 "your name_Form".

Reports

1. Create a Stepped report based on your table that views all information classified by one field. Save the report by "your name_Report".

Attachment:- Information Technology Skills.rar

Reference no: EM132516884

Questions Cloud

Ethics brochure : An introduction that provides overview of ethical diversity. Definition of Pluralism and an applicable example. Definition of Relativism and applicable example

What are the general criticisms are offered of utilitarian : What are the general criticisms are offered of the utilitarian goal?

Simple explanation of the institutional theory of art : What is the simple explanation of the institutional theory of art? Can you give me examples of artworks or pieces which this theory can be applied to?

What was the total amount of gain : Gemini Auto Repair is a calendar year taxpayer. What was the total amount of gain (or loss) for Gemini in 2019 on the sale of the truck

Create a stepped report based on your table : Create a justified Form that views all records based on your table. Save the form by "your name_Form".

Is bjorn right or wrong in statement and why : Current year will decrease when compared to the previous year because the production has increased. Is Bjorn right or wrong in his statement and why?

Create a justified form that views all records : Create a table with 4 fields to hold any domain that you suggest. All fields should be with different data types - Create a justified Form that views

Calculate the depreciation expense at June : Using the Units of Production method, calculate the depreciation expense at 30 June 2017 if the motor vehicle travelled 10,000km in the year ending 30 June 2017

Compute the product cost per meal produced : Compute the product cost per meal produced under absorption costing and under variable costing. Do this first for January and then for February

User Account

All Pages