IC3 Module b Notes PDF
Document Details
Uploaded by Deleted User
Tags
Summary
This document contains practice questions and information about software applications like MS Word and MS Access. It covers topics such as common shortcuts, file systems, and database concepts.
Full Transcript
MS Word 1. Which type of program is designed to be used on touch screen devices such as tablets? Apps (applications) 2. Which application is best suited for; Keeping a personal budget? → Excel Writing a report? → Word Keeping track of employees’ information? → Access Creating slides →...
MS Word 1. Which type of program is designed to be used on touch screen devices such as tablets? Apps (applications) 2. Which application is best suited for; Keeping a personal budget? → Excel Writing a report? → Word Keeping track of employees’ information? → Access Creating slides → PowerPoint 3. You accidentally deleted an app from your device. How do you restore the deleted app? Download it again from the app store 4. Match the device to the default program where apps are purchased. iPad mini → App store Surface pro → Windows store Galaxy tab 5 → Play store Kindle Fire → Amazon app store 5. Other Apps and applications: Editing and modifying images → Photoshop Working with plain texts → Notepad Desktop Publishing → Publisher Editing Video → Premiere 6. How to Purchase an App: 1) Navigate the store 2) Search for the App 3) Select the App 4) Open the App 5) Select the buy option 6) Confirm login information 7. Common shortcuts: 8. File systems for common applications: Word →.doc.docx.txt Excel →.xls.xlsx.csv PowerPoint →.ppt.pptx.rtf.potm Database →.mdb aacdb MS Access 1. Terms: Table → Basic building block of any database Forms → Commonly used as a data entry screens Reports → Used to print and summarize data Queries → Used to extract data from one or more tables Field → Category of information with a table Primary Key → Unique identifier of a record Record → Group of fields Foreign → Is a primary key on another table but a normal field on the current table. 2. What would make a god primary key? Grade point average Last name Student ID Date of birth Order of number Movie duration - Other examples of primary key: Passport number Vehicle plate number Book ID Civil ID 3. Views in Access. Tables: Design, datasheet Query: Design, SQL, datasheet Report: Report, design, print, layout 4. Select an aspect of the website that uses a database: Search bar Product catalogue of product list 5. CSV is a simple format used to store tabular data, such as a spreadsheet or database. Example: Customer Contact List. 6. Table Metadata. The name of the table The name of each field in the table The data type of each field The size of each field 7. Characteristics of relational database. Each field should have a unique attribute name
