Reference no: EM132514612

BIT100 Introduction To Information Technology Skills - Emirates College of Technology

Problem 1: PowerPoint presentation

Select any specific topic and use Microsoft PowerPoint to create a presentation according to the following:

1. Create a new presentation file consists of4 slides and save it with your name and ID.

2. First slide should contain:
• The text of your topic as a title
• Your name as a subtitle
• Shapewith glow effect contains your name and ID.

3. Second slide should contain:
• The text of your topicas a wordArtwith transform effect
• Numbered list related to your topic.

4. Third slide should contain:
• Tablefilled by information related to selected topic.

5. Fourth slide contains:
• Two pictures. You are free to download pictures related to your topic.
• Apply any style to the first picture and dashed border in the second picture.

6. Apply different design template from PowerPoint for each 2 slides.

7. Add slide number for your slidesand write your name as Footer in each slide.

8. Apply different Slide Transitions for each slide.

9. Apply Custom Animation on the shape of the first slide, wordArt text in the second slide, table in the third slide and one picture in the fourth slide.

10. Set timing 5 second for second slide.

Suggested topics:

UAE national day, Gulf Counties, Tourism in UAE, Favorite sports, Favorite hobbies...

Problem 2: 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 fieldsofyour table that have one field equal to specific value. Save it as Query 1.
2. Query that viewsspecific defined fields of your tablewith field has value less than anexact value. Save it as Query2.
3. Query that views specifics defined fields of your tablethat have two constraints with relationship "and". Save it as Query3.
4. Query that viewsspecifics defined fields of your tablethat 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:- Introduction To Information Technology Skills.rar