Computer Skills (COMP 105) Lecture 2 PDF

Computer Skills (COMP 105) Lecture #2 Concept of IT, Introduction to Computer, Hardware, and Software Ms.Amal Alkhaldi Outlines ✓Identify information,data and Knowledge. ✓Identify information Technology(IT). ✓What is a Computer? ✓Types of computer system. ✓Har...

Computer Skills (COMP 105) Lecture #2 Concept of IT, Introduction to Computer, Hardware, and Software Ms.Amal Alkhaldi Outlines ✓Identify information,data and Knowledge. ✓Identify information Technology(IT). ✓What is a Computer? ✓Types of computer system. ✓Hardware & Software Ms.Amal Alkhaldi Data, Information and Knowledge Data: Facts and figures which relay something specific but which are not organized in any way and which provide no further information regarding patterns (unstructured facts and figures) Ms.Amal Alkhaldi Data, Information and Knowledge Information: it is data with relevance and purpose. For data to become information, it must be contextualized, categorized, calculated and condensed. (Processing) Ms.Amal Alkhaldi Data, Information and Knowledge Knowledge: Knowledge is closely linked to doing and implies know-how and understanding.(Processing Information) Ms.Amal Alkhaldi  Data, Information and Knowledge Data: symbols Information: data that are processed to be useful; Knowledge: application of data and information; Processing data produces information, and processing information produces knowledge. Ms.Amal Alkhaldi Information Technology (IT) Information Technologies: are systems of hardware and software that capture, process, exchange, store and present information. Ms.Amal Alkhaldi Computer Computer: is a general purpose electronic device, programmable device that is used for the production and processing of information. Capable of calculating and storing results. computer can: 1. Accept data (input). 2. Process the data according to specified rules. 3. Produce information (output). 4. store the information for future use. Ms.Amal Alkhaldi Computers are Programmable Computers respond to instructions in the form of programs. Programs are written in order to make computers behave in specific ways i.e. word processor, systems control. Programs are stored in the Computer memory. Ms.Amal Alkhaldi How computers process information 1. Computers accept inputs ( i.e. data). 2. The input is translated into binary numbers and ‘processed’. 3. The process produces output (i.e. information) 4. This sequence can repeat: ✓outputs can be inputs. Ms.Amal Alkhaldi Computer Functionalities: Any digital computer carries out five functions in gross terms: 1. Takes data as input. 2. Stores the data/instructions in its memory. 3. Processes the data into useful information. 4. Generates the output. 5. Controls all the above four steps. Ms.Amal Alkhaldi Computer Functionalities: Input Output DATA Processing Information Ms.Amal Alkhaldi Components of a Computer System Computer Systems are made up of: Hardware – the physical parts of computer. Software - the instructions or programs that control the hardware. Ms.Amal Alkhaldi Hardware: Computer hardware is the collection of physical elements ”Touchable objects”, that creates a computer system. The actual machinery, wires, transistors, and circuits … etc. Ms.Amal Alkhaldi Hardware: Ms.Amal Alkhaldi Computer Units 1. Input Unit 2. Central processing Unit 3. Primary Memory Unit 4. Secondary storage Unit 5. Output Unit Ms.Amal Alkhaldi Input Devices: Input device: is any piece of computer hardware equipment to provide data and control signals to an information processing system such as a computer or other information application. Input device translate data from form that humans understand to one that the computer can work with. Most common are keyboard and mouse. Ms.Amal Alkhaldi Input Devices: Ms.Amal Alkhaldi Central Processing Unit(CPU) CPU known as Microprocessor or processor It is responsible for all functions and processes. CPU Components: ALU (Arithmetic Logic Unit):Executes all arithmetic and logical operations. Control Unit (CU) Memory Unit Ms.Amal Alkhaldi Primary Memory Unit RAM (Random Access Memory) :is a memory inside the computer system responsible for temporarily storing data so that the processor can promptly access it as and when needed. volatile: Data will be erased once the power to the storage device is turned off. Randomly stores and accesses. RAM is considered "random access" because you can access any memory cell directly if you know the row and column that intersect at that cell. Ms.Amal Alkhaldi Primary Memory Unit ROM (Read Only Memory): is a permanent form of storage. ROM devices do not allow data stored on them to be modified. stays active regardless of whether power supply to it is turned on or off. Ms.Amal Alkhaldi Secondary Memory Unit Stores data and programs permanently. It’s retained after the power is turned off. Main Examples: ✓Hard Disk ✓Optical Disk ✓Flash memory Ms.Amal Alkhaldi Output Unit An output device is any piece of computer hardware equipment used to communicate the results of data processing carried out by an information processing system (such as a computer) converts the electronically generated information into human- readable form. Ms.Amal Alkhaldi Output Devices: Ms.Amal Alkhaldi Software Computer Programs Instructions Data Ms.Amal Alkhaldi Software Software is a generic term for organized collections of computer data and instructions, often broken into two major categories two major categories: 1. System software (Known as Operating System) is responsible for controlling, integrating, and managing the individual hardware component of a computer system. Windows, , Mac OSX ,Linux Unix are an example of OS. Ms.Amal Alkhaldi Application software 2.Application software is used to accomplish specific tasks other than just running the computer system. It may consist of: A single program, image viewer; A small collection of programs (often called a software package) that work closely together to accomplish a task, spreadsheet or text processing system; A larger collection (often called a software suite) of related but independent programs and packages that have a common user interface or shared data format. Microsoft Office, Ms.Amal Alkhaldi Applications Software Concerned with the world outside the computer. Used for the things you want the computer to do. Common Examples - Word, Excel, Internet Explorer. Applications can be more specialized: e.g. Architecture package Ms.Amal Alkhaldi Ms.Amal Alkhaldi  Computer Skills (COMP 105) Lecture #3 Computer Performance, Memory and I/O Devices Presenter: Ms.Amal Alkhaldi Outlines: Computer performance Computer Memory Input and output devices Presenter: Ms.Amal Alkhaldi Why is a computer so powerful? The ability to perform the information processing cycle with amazing speed. Reliability. Accuracy. Ability to store huge amounts of data and information. Ability to communicate with other computers. Presenter: Ms.Amal Alkhaldi  Computer performance Characterized by the amount of useful work accomplished by a computer system compared to the time and resources used. Depending on the context, good computer performance may involve one or more of the following: 1. Short response time. 2. High throughput (rate of processing work). 3. Low utilization of computing resource(s). 4. High availability of the computing system or application. 5. Fast (or highly compact) data compression and decompression. 6. High bandwidth / short data transmission time. Presenter: Ms.Amal Alkhaldi Computer vs H/W Performance Latency/Response Time (clocks from input to corresponding output) Throughput (How many results per clock) If we upgrade a machine with a new processor what do we improve? Response Time/Latency If we add a new machine to the lab what do we increase? Throughput Presenter: Ms.Amal Alkhaldi Design Tradeoffs Maximum Performance: measured by the numbers of instructions executed per Second Minimum Cost: measured by the size of the circuit. Best Performance/Price: measured by the ratio of MIPS(Million instructions per second) to size. In power sensitive applications MIPS/Watt is important too. Presenter: Ms.Amal Alkhaldi Aspect of software quality Computer software performance particularly software application response time, is an aspect of software quality that is important in human-computer interactions. Presenter: Ms.Amal Alkhaldi Computer Memory Computer memory is any physical device capable of storing information temporarily or permanently. Electronic components that store instructions, data, and results. Consists of one or more chips on motherboard or other circuit board. Each byte stored in unique location called an address. Presenter: Ms.Amal Alkhaldi Classification of memory Internal Processor Memory Main Memory Secondary Memory Presenter: Ms.Amal Alkhaldi Internal Processor Memory A small high speed memory inside the processor. Temporary storage of instruction and data. Example: Registers, built-in cache. Presenter: Ms.Amal Alkhaldi Main Memory It is relatively large memory placed outside the processor. Data and instruction storage for the operation of the processor. Can be accessed directly and rapidly by the CPU. Example: RAM, ROM Presenter: Ms.Amal Alkhaldi Main Memory Types RANDOM ACCESS MEMORY (RAM) types: Dynamic RAM Static RAM READ ONLY MEMORY(ROM) types: Strict ROM PROM EPROM EEPROM EAROM Flash ROM Presenter: Ms.Amal Alkhaldi Random Access Memory(RAM) A temporary storage that can be read from or written into by the user. Volatile memory. Every location can be accessed independently. Access time for every location is constant and independent of it's position. Presenter: Ms.Amal Alkhaldi  Static Ram(SRAM) Dynamic Ram (DRAM) Use six transistors to store data. Used in main memory high speed and high cost slower and low cost memory. accept one command and transfer refreshed 1000 times per second one word of data per clock cycle. Access time 60 - 70 nanoseconds Presenter: Ms.Amal Alkhaldi Read-only Memory (ROM) A class of storage used in computer and other electronic devices. Data stored in it cannot be modified Non-volatile memory. In modern PCs, ROM is used to store the basic bootstrapping firmware for the main processor, self-contained devices such as graphics card, hard disks, DVD drives, etc. Presenter: Ms.Amal Alkhaldi Secondary Memory Much larger in capacity but slower than main memory. Permanent storage of data and instruction. Example: Hard disk, CD, Floppy etc. Presenter: Ms.Amal Alkhaldi Storage Devices Storage devices are used to store data when they are not being used in memory. The most common types of auxiliary storage used on personal computers are : Floppy disks Hard disks CD-ROM drives Presenter: Ms.Amal Alkhaldi Presenter: Ms.Amal Alkhaldi Cache Memory System performance suffers when processor waits for data from slow memory device. Cache memory is introduced between the CPU and the main memory. Cache is a high speed memory for holding recently accessed data in main memory. The amount of cache memory has a tremendous impact on the computer's speed. Presenter: Ms.Amal Alkhaldi Two Types Of Cache Memory Level-1 L1 cache: CPU resident cache Level-2 L2 cache: Motherboard resident cache. CPU Cache Main Memory Presenter: Ms.Amal Alkhaldi Input/ Output Devices Input Devices Input devices are a part of computer that allow the use to control and adjust an electronic device. An input device is any hardware component that allows you to enter data and instructions onto a computer. Presenter: Ms.Amal Alkhaldi Presenter: Ms.Amal Alkhaldi Presenter: Ms.Amal Alkhaldi Output Devices Output devices make the information resulting from the processing available for use. The two output devices more commonly used are the printer and the computer screen. The printer produces a hard copy of your output, and the computer screen produces a soft copy of your output. Presenter: Ms.Amal Alkhaldi Presenter: Ms.Amal Alkhaldi Presenter: Ms.Amal Alkhaldi Computer Skills (COMP 105) Lecture #4 Windows 10 and Application Presenter : Ms.Amal Alkhaldi Outlines: Architecture of computer system Hierarchy of Computer Software Operating System (OS), Functions, Features, Types of OS Basic Windows 10 Presenter : Ms.Amal Alkhaldi Architecture of Computer System Hardware Operating System (OS) Programming Language (e.g. java) Application Programs (e.g. WORD, EXCEL) Presenter : Ms.Amal Alkhaldi System ,Application Software and Driver Programs: System Software(Operating system )- Performs essential operation tasks Application Software(educational software) - Performs specific tasks for users Driver Programs (Device Driver)- Small program that allows a specific input or output device to communicate with the rest of the computer system. Presenter : Ms.Amal Alkhaldi Operating System ▪ A collection of programs which control the resources of a computer system written in low-level languages. ▪ An interface between the users and the hardware, when the computer is on, OS will first load into the main memory. Presenter : Ms.Amal Alkhaldi Basic Functions Device configuration Controls terminal devices connected to the computer File management Transfers files between main memory and secondary storage, manages file folders, and provides file protection and recovery Memory management Allocates the use of random access memory (RAM) to requesting processes Presenter : Ms.Amal Alkhaldi Common Operating Systems Network Operating System UNIX / Linux / MS Windows2000 Server Desktop Operating System MS Windows XP/Me / Mac OS / DOS Mobile Operating System Android PC Presenter : Ms.Amal Alkhaldi Types of Operating System ▪ Batch processing ▪ Real time processing ▪ Time sharing processing Presenter : Ms.Amal Alkhaldi Special Features of OS Multi-tasking Multi-programming Parallel processing Buffering Spooling Presenter : Ms.Amal Alkhaldi The Basics of Microsoft Windows 10 A few feature highlights: Start menu Using tiles How to search Task view Virtual desktops Quick access tools Presenter : Ms.Amal Alkhaldi Introducing Windows 10 Your computer uses the Microsoft Windows 10 operating system Windows10 for short. Windows is the name of the operating system, and 10 identifies the version you are using. The most popular features of Windows 10 include it’s speed, flexibility, and design. Presenter : Ms.Amal Alkhaldi Starting Windows 10 Turn on your computer, after a moment, Windows 10 starts and lock screen appears. Press any key to clear the lock screen and display the Welcome screen. Presenter : Ms.Amal Alkhaldi Start Menu Windows 10: Presenter : Ms.Amal Alkhaldi How to use the start menu: Presenter : Ms.Amal Alkhaldi Start menu: Using tiles In the right pane of the Start menu, you’ll find tiles for some common apps. To move a tile, just drag it to another position. You can rearrange them within the pane. You can also drag apps between the tile view and the app list view. Presenter : Ms.Amal Alkhaldi How-to Search Windows 10 Start menu comes with a great Search tool. Search apps Search files Search the web Presenter : Ms.Amal Alkhaldi Task View One of the best parts of windows. Separate all apps into a spread out view to find the window you are looking for. Great for organization! Also “Windows + TAB” Presenter : Ms.Amal Alkhaldi Quick Access Tools The Quick Access menu provides access to advanced system tools such as Power Options, Task Manager, and Control Panel. Presenter : Ms.Amal Alkhaldi Settings: Settings gets a new “modern” look. Basically, a condensed “Control Panel” Control Panel is still available. Presenter : Ms.Amal Alkhaldi Settings in Windows 10 Windows 10: Presenter : Ms.Amal Alkhaldi Settings for System Settings here change system configurations (Display resolution/monitors, default apps, power, etc.) Presenter : Ms.Amal Alkhaldi Settings for Devices Manage settings for external devices (printers, mice, scanners) Presenter : Ms.Amal Alkhaldi Settings for Devices Presenter : Ms.Amal Alkhaldi Where is “My Computer”? Right-click the start button > Select File Explorer Click “This PC” to get to your drives. Presenter : Ms.Amal Alkhaldi File Explorer elect its icon on the taskbar or the Start menu, or press the Windows logo key on your keyboard. Presenter : Ms.Amal Alkhaldi Manipulating Folders. Move or Copy Folders and Files 1. Click to highlight the folder or file to move. 2. Click the Home tab. 3. Move the folder or file by clicking Move to. 4. Click Choose location,Choose the destination then click Move. Presenter : Ms.Amal Alkhaldi Manipulating Folders. Use Click and Drag Click and drag a folder or file to another folder in File Explorer. OR Click the folder or file, and then press Ctrl + C to copy it or Ctrl + X to cut it. Ctrl + V to paste the folder or file in the new location. Presenter : Ms.Amal Alkhaldi Manipulating Folders. Rename Folders and Files: 1. Click and highlight the desired folder or file. 2. Click the Home tab. 3. Click the Rename button. 4. Type a new folder or file name, and then press Enter. Delete Folders and Files: right-click on the folder and select “Delete”. Presenter : Ms.Amal Alkhaldi  Compression Compression : A file reduced in size through the application of a compression algorithm HOW? Select the files or folders you want to compress,To select all items within a folder, press Ctrl + A. Right-click on the selected files or folders and choose "Send to“. Select "Compressed (zipped) folder" from the submenu. Windows will create a compressed ZIP file in the same location as the original items. Presenter : Ms.Amal Alkhaldi Presenter : Ms.Amal Alkhaldi Computer Skills (COMP 105) Lecture #5 Computer Network and Internet Presenter : Ms.Amal Alkhaldi Outlines: Computer network Network communication Advantages & disadvantages of computer networks Types of computer network Network architecture Network topology Network communication technology Communication software and the internet Connecting to the internet. Presenter : Ms.Amal Alkhaldi Computer Network Computer network is a collection of computers and devices connected together via communication devices and transmission media. For example it may connect computers, printers and scanners. Presenter : Ms.Amal Alkhaldi Network Communication Network communication is describes a process in two or more computer. Devices transfer data, instructions and information. Presenter : Ms.Amal Alkhaldi Advantages of the computer networks Sharing of devices such as printer and scanner Sharing program/ software Sharing files Sharing data Sharing information Sharing of single high-speed internet connection Presenter : Ms.Amal Alkhaldi Disadvantages of the computer networks The larger network becomes, the more difficult to manage and delay connectivity. If the network stops operating system, then it may not be possible to access various resources. Computer Viruses. Presenter : Ms.Amal Alkhaldi Main concepts of network Network Communication device Transmission Media Router Wire (cable) Hub Switch Wireless Presenter : Ms.Amal Alkhaldi Types of network: Local Area Network (LAN) Local area network is a network that connects computers and devices in a limited geographically area such as a home, computer lab and office building. Presenter : Ms.Amal Alkhaldi Types of network: Metropolitan Area Network (MAN) Metropolitan Area Network (MAN) is high speed network that connect local area network in Metropolitan Area such as city or town. A MAN typically includes one or more LAN but covers a smaller geographically area than a WAN. Presenter : Ms.Amal Alkhaldi  Types of network: Wide Area Network (WAN) Wide Area Network is a network that covers a large geographically area such country or the world. WAN combines many types of media such as telephone lines, cables and radio wave. A WAN can be one large network or can consist of two or more LANs connected together. Presenter : Ms.Amal Alkhaldi Network Architecture Is the over all design of a computer network that describes how a computer network is configured. Two main network architecture: Client/server Network. Peer to Peer Network. Presenter : Ms.Amal Alkhaldi Network Topologies Presenter : Ms.Amal Alkhaldi Network Communication Technology Network Communication Technology Intranet Extranet Internet Presenter : Ms.Amal Alkhaldi What is the internet? ▪ The internet is a network of computers linking many different types of computers all over the world. ▪ It is a very large wide area network (WAN) ▪ It makes it possible for millions of users to connect to one another via telephone lines, cable lines and satellites. Presenter : Ms.Amal Alkhaldi Basic services of internet ▪ Electronic mail (E.mail) ▪ File Transfer Protocol (FTP) ▪ Telnet ▪ Usenet news ▪ World Wide Web (WWW) Presenter : Ms.Amal Alkhaldi Uses of the Internet ? On-line communication. Software sharing. Posting of information. Feedback about product. Customer support service. Presenter : Ms.Amal Alkhaldi Advantages of Internet ▪ Fastness of Internet Fastest way of getting anything. ▪ Cheapness ▪ Convenientness Ability to connect at anywhere and anytime. ▪ Global network Reaching a point or person from the planet. Presenter : Ms.Amal Alkhaldi Disadvantages of Internet ▪ Untruthfulness There are certain reliable things, people who do not exist in real life. ▪ Obtain the wrong information Existing too much wrong, uncertain knowledge as information pollution. ▪ High installation cost Presenter : Ms.Amal Alkhaldi Presenter : Ms.Amal Alkhaldi Computer Skills (COMP 105) Lecture #6 The Microsoft Word 2016 Presenter : Ms.Amal Alkhaldi Outline: The Word 2016 Environment (Screen) Manipulating Text and Paragraph Border Page Formatting Presenter : Ms.Amal Alkhaldi Microsoft Word 2016 Microsoft Word 2016 is a computer program that allows you to create, edit and produce text documents, such as letters. When first opening the program, the user will be presented with options to open recent documents, start a new blank document, or select from several templates. Presenter : Ms.Amal Alkhaldi Page Overview Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen) Title Bar Which has window controls at the right end, as in other Windows programs. A blank document opens with the default file name of Document 1. Quick Access Toolbar The Quick Access Toolbar is located all the way to the left on the title bar. It contains frequently used commands and can be customized using the drop-down menu. Quick Access Default File Name Window Controls Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen) The Ribbon Contains all of the tools that you use to interact with your Microsoft Word file. The ribbon has a number of tabs, each of which contains buttons, which are organized into groups. The Tabs are: 1. File 2. Home The Tabs 3. Insert 4. Design 5. Layout 6. References 7. Mailings 8. Review 9. View Presenter : Ms.Amal Alkhaldi  The Word 2016 Environment (Screen): File Tab: The File tab provides a Backstage view of the currently active document, and lists recently opened documents. The File tab provides options: a. Back - Takes you back to edit your document. b. Info - Obtain information about your documents. c. New - Create a new document from a blank or pre-formatted template. d. Open - Open a document. e. Save - Save the document to keep your edits. f. Save As - Resave a saved document as a different filename or file type. g. Print - Print documents and see a preview of your document. h. Close - Close the document. Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Home Tab Gives you access to some of the most commonly used commands for working with Word including: ✓ Copying. ✓ Pasting. ✓ Formatting. ✓ Aligning paragraphs. ✓ Choosing document styles. Clipboard Font Paragraph Styles Editing Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Insert Tab : Allows you to insert pictures, charts, tables, shapes, cover pages, and more to your document Design Tab: Gives you access to a variety of design tools, including document formatting, effects and page borders Document Page Background PresenterFormatting : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Layout Tab: Allows you to change the print formatting of your document, including margin width, page orientation, page breaks, and more. References Tab: Allows you to add footnotes, citations, table of contents, captions and a bibliography. Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Mailings Tab: Used for composing letters, address envelopes, and creating labels. It is useful when you are mailing a large number of letters. Review tab: Word’s powerful editing features, such as adding comments and tracking changes. Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): View Tab: Allows you to switch between different views for your document and split the screen to view two parts of your document at once. Format Tab: Will appear on the Ribbon when working with certain items, such as tables and pictures. Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Zoom Slider: This allows you to adjust how large the document is displayed on the screen. Current Information: Displays a variety of information about the document, such as the page number. Current Information Document Views Zoom Slider Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Document Views: Word 2016 has a variety of viewing options that change how your document is displayed. You can choose to view your document in 1. Read Mode: Displays the document full-screen 2. Print Layout: Shows what the document looks like when it’s printed. 3. Web Layout: Shows what the document would look like if it were saved as a webpage. Presenter : Ms.Amal Alkhaldi The Word 2016 Environment (Screen): Document Views: Read Mode Print Mode Web Layout Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Adding spaces: Press the space bar to add spaces after a word or in between text. New Paragraph line: Press Enter on your keyboard to move the insertion point to the next paragraph line. Manual placement: After a text has been entered, you can use the mouse to move the insertion point to a specific place in your document. Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Selecting Text: Select a single word: Double-click on the word to select it. Select a sentence or paragraph: Click the mouse and while holding it down drag you mouse over the text to select it. Select entire document: Use shortcut for select all text ctrl+A. Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Copy and Paste Text : When you copy something, it remains in its original location, and is also placed on the clipboard: 1. Select the paragraph. 2. In the Home tab on the ribbon, locate the Clipboard group. Paste 3. Click Copy. 4. Move your insertion point below the paragraph. Copy 5. Click the Paste button proper. OR Ctrl+C to copy text and Ctrl+V to Paste text Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Cut and Paste: When you cut something, it is removed from its current location and placed on the clipboard. The clipboard is a temporary storage area for data that can be accessed by any program on your computer. 1. Select the paragraph. 2. In the Home tab on the ribbon, locate the Clipboard group. Paste 3. Click Cut. 4. The paragraph disappears from view, but is saved in the computer’s memory. Cut 5. Move your insertion point below the paragraph. 6. Locate the Paste button in the Clipboard group. 7. Click the Paste button proper OR Ctrl+X to cut text and Ctrl+V to Paste text Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Font box Change Font: Word 2016 provides a variety of other fonts you can use to customize text and titles. 1. Select the text you wish to change. 2. On the Home tab click the drop-down arrow next to the Font box. 3. Move the mouse over the list of font styles, then select the font you would like to use. 4. The font will change in the document Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Font size Font Size: 1. Select the text you wish to change. 2. Font size drop-down arrow. 3. Select the desired font size formatting option Font Color: 1. Select the text you wish to change. 2. On the Home tab, click the Font Color drop-down arrow. The Font Color menu appears 3. Move the mouse over the various font colors. A live preview of the color will appear in the document. 4. Select the font color you wish to use. Presenter : Ms.Amal Alkhaldi Font Color Manipulating Text and Paragraph Highlight Highlight Text: 1. Select the text you wish to highlight. 2. From the Home tab, click the Text Highlighter Color drop-down arrow. Bold, Italic, and Underline: 1. Select the text you wish to change. 2. On the Home tab click the Bold (B), Italic (I), or Underline (U) command in the Font group. 3. The selected text will be modified in the document. Bold (B), Italic (I), or Underline (U) Presenter : Ms.Amal Alkhaldi Manipulating Text and Paragraph Text Alignment: 1. Select the text you wish to modify. 2. On the Home tab, select one of the four alignment options from the paragraph section ✓ Align Text left ✓ Center ✓ Align Text Right ✓ Justify Justify Align text left Center Align Text Right Presenter : Ms.Amal Alkhaldi Border Page Border: To place a border around your document, 1. The Design tab, in the Page Background group, click Page Borders. 2. A Borders and Shading Dialogue Box will open. Page Borders Presenter : Ms.Amal Alkhaldi Border 3. In the Borders and Shading Dialogue Box, on the Page Border tab, there are options for customizing a border. ✓ Settings, styles. ✓ Colors. ✓ Width. ✓ The left and center panes, ✓ Preview in the right pane. 4. in the left pane, click on the Box setting. Presenter : Ms.Amal Alkhaldi Border 5. In the center pane, in the Art drop- down list box, click the drop-down arrow. Scroll down and click a border style that you like. Click OK to add the border. Presenter : Ms.Amal Alkhaldi Page Formatting To change page orientation: 1. Select the Page Layout tab. 2. Click the “Orientation” command in the Page Setup Section. 3. A drop-down menu will appear. Click eithe “Portrait”or “Landscape” to change the page orientation. 4. Once one is selected the page will change. Presenter : Ms.Amal Alkhaldi Page Formatting Page Size: Word has a variety of predefined page sizes to choose from. 1. Select the “Layout” tab, then click the “Size” command. 2. A drop-down menu will appear. The current page size is highlighted. Presenter : Ms.Amal Alkhaldi New Document To begin a new project in Word 1. Select the file tab. Backstage view will appear. 2. Select New, then click a template. 3. A new, document will appear. Presenter : Ms.Amal Alkhaldi Save and Save As In Word, there are two ways to save a file, SAVE and SAVE AS. SAVE : is used when a document is open or edited to save what you are working on. SAVE AS: is used to save the document to a location and change its name. It is important to save your document whenever you start a new project or change an existing one. Presenter : Ms.Amal Alkhaldi To Save a Document 1. Locate and select the Save command on the Quick Access toolbar. 2. If you are saving the document for the first time Save As will appear in Backstage view. 3. You will then need to choose where to save the file and give it a file name. Presenter : Ms.Amal Alkhaldi To Save a Document 4. The Save As dialog box will appear. Select the location where you wish to save the document. 5. Enter a file name for the document, then click Save. Presenter : Ms.Amal Alkhaldi How to: Open an Existing Document 1. Navigate to Backstage view, then click Open. 2. Choose “Browse” Presenter : Ms.Amal Alkhaldi How to: Open an Existing Document (Cont.) 3. The Open dialog box appears. Locate and select your document, then click Open. Presenter : Ms.Amal Alkhaldi Presenter : Ms.Amal Alkhaldi Computer Skills (com p 10 5 ) M ic rosoft Exc el 2016 Lecture ( 6 ), Module ( 1 )  1. Introduction to Microsoft Excel 2. Excel Interface Agenda 3. The Ribbon 4. Manipulating Rows & Columns, Auto Fill & Worksheet, Alignment & Number Formatting Microsoft Excel Excel is a spreadsheet program developed by Microsoft, that consists of Workbooks. Each Workbook is made up of an infinite number of worksheets. It is possible to name each worksheet to aid in organizing your data.  Excel Interface The Start Screen allows you to create a new document or choosing from pre-made templates. Blank Page Excel Sheet  The Ribbon contains multiple tabs, each with several groups of tools. Formula It is used to express relationships between various quantities, such as temperature, mass in physics The ribbon Data Provides you with all the necessary commands to use and manage internal/external data connections.  Excel Basics Excel spreadsheets organize information (text and numbers) by rows and columns: Rows are represented by numbers along the side of the sheet. Columns are represented by letters across the top of the sheet.  Excel Basics A cell is the intersection between a column and a row. Each cell is named for the column letter and row number that intersect to make it. Excel Basics Excel allows for some basic actions which we have used before in other programs Copy/Paste (Rows, Columns, Cells, etc.) Insert (Rows and Columns) Sort (Alphabetically, Numerically, etc.)  Excel Formating Merging allows us to combine two or more adjacent cells physically (disregarding contents) To merge cells simply highlight the cells to be merged and select the merge option from the home menu Cells can also be formatted with options (bold, font size, borders, etc.)  Excel Formating Data Type in the numbers section of the home menu, select the number drop-down menu (defaults to General) and select the new type desired Excel Numeric Formating  Excel Data entry 1. Type directly into the cell. 2. Type into the formula bar.  Excel Cell Range A range is a rectangular group of cells  Excel Auto Fill Auto Fill enables us to copy the contents of a cell or a range of cells by dragging the fill handle over adjacent cells or a range  Excel Formulas Formulas are equations that perform calculations in your spreadsheet. Formulas always begin with an equals sign (=). When you enter an equals sign into a cell, you are basically telling Excel to “calculate this.” Excel Formulas Mathematical Symbols  Excel Formulas Order of Precedence (operations) controls the sequence in which math operators are computed –Parentheses –Exponentiation –Multiplication and Division –Addition and Subtraction  Excel Formulas Example  Excel Formulas What is Auto Sum Tool? Automatically creates a formula to add a series of numbers in a spreadsheet  Excel Formulas What is a Chart? Graphic representations used to compare & contrast worksheet data  Excel Formulas Ascending Descending from A to Z from Z to A What is sorting? Organizing or rearranging data in either ascending or descending order Excel Formulas Ascending Descending arranges records from arranges records from Z to A A to Z largest to smallest smallest to largest Excel Formulas Common Formula Errors #### error #DIV/0! error message when the error message appears width of a column is not when the formula you're wide enough to display all using attempts to divide the characters within that by zero. cell Excel Formulas Common Formula Errors #NAME? #REF! occur if you misspell occurs when your formula certain elements of your attempts to reference a formula deleted cell  1. Getting started with Microsoft Excel 2. Know the different features of Excel summary 3. Learned about the new Ribbon 4. How to manipulating Rows & Columns, Auto Fill & Worksheet, Alignment & Number Formatting the end.. Thank you ! Computer Skills (com p 10 5 ) M ic rosoft Exc el exerc ise Lecture ( 6 ), Module ( 2)  1. Introduction to Microsoft Excel 2. Excel Interface Agenda 3. Create a workbook and worksheets 4. Manipulating Rows & Columns, Auto Fill & Worksheet, Alignment & Number Formatting Excel Sheet  new workbook Microsoft Excel  save workbook Microsoft Excel  rename sheet Microsoft Excel Rename sheet to Stu Grade Right click - then choose Rename  Merge cells Select cells from A1 to G1 Microsoft Home Tab - select Merge & Center Excel Result  Data entry Create table as follow: Microsoft Excel  format cells format cells (color, font) Microsoft Excel From Home Tab - Cell Style  format cells for column F - Change Number from Home Tab - Number Format Format to % - Choose Percentage Microsoft Excel Select Cell  format cells for column F - Change Number from Home Tab - Number Format Format to % - Choose Percentage Microsoft Excel Select Cell  Auto Fill click on the bold square drag it down till the end Microsoft Excel  1. learned how to create and save a workbook 2. Dealing with data and cells summary 3. Merging cells and format it 4. Learned how to change number formatting of a cell and auto fill it. the end.. Thank you :) Computer Skills (com p 10 5 ) M ic rosoft Exc el 2016 Lecture ( 6 ), Module ( 3 )  1. Freezing Rows and Columns Agenda 2. Functions 3. Charts  Q1 : What is the difference between Revision Row and Column ? Q2 : There are multiple error messages in Excel, could you name and discuss one of the errors ? Excel Freezing You may have a hard time recognizing what row or column the cell you’re viewing belongs to. And this is where Microsoft Excel’s Freeze Pane can come in handy. Freeze Panes option allows you to lock your columns and/or rows so that when you scroll down or over to view the rest of your sheet, the column and/or row will remain on the screen. Excel Freezing Freeze Panes: Lock more than one column or row selected by user. Freeze Top Row: Only lock the top row. Freeze First Column: Only lock the first column. Excel Function Function is a predefined formula that performs calculations using specific values in a particular order  Excel Function Function Operators: (1) Arithmetic Operators  Excel Function Function Operators: (2) Comparison “Logical” Operators  Excel Function Common used functions: SUM AVERAGE a premade function which adds values calculates the average (arithmetic mean)  Excel Function Common used functions: MAX MIN finds the highest number which finds the lowest in a range. number in a range  Excel Function Common used functions: COUNT VLOOKUP used to search for a value counts the number of in the first column and cells that contain return a value from numbers another column in the same row  Excel Charts Charts is a visual representation of data or values  Excel Charts Types of Charts: Column chart emphasizes the variations of the data over time  Excel Charts Types of Charts: Line chart shows the relationships of changes in data  Excel Charts Types of Charts: Pie chart contain a single data series  Excel Charts Types of Charts: Bar Chart emphasizes the comparison between items in a specific period  1. Definition of Freezing Pane, Rows and Columns summary 2. What is Functions, and the common used functions in Excel 3. The different between charts types used in Excel. the end.. Thank you ! Computer Skills (com p 10 5 ) M ic rosoft Exc el exerc ise( 2) Lecture ( 6 ), Module ( 4)  1. Freezing Rows and Columns Agenda 2. Using different types of Functions 3. Inserting Charts 3. Save the workbook and print  Freeze (1) View tab Microsoft (2) Select Freeze Panes Excel  function Using =SUM() function to calculate the total Select Cell Microsoft Excel Write the function Press ENTER to see the result  function Using =AVERAGE() function to calculate the arithmetic mean Select Cell Microsoft Excel Write the function and select the Cell Range Press ENTER to see the result  function Using =MAX() function to find number the highest Select Cell Microsoft Excel Write the function and select the Cell Range Press ENTER to see the result  charts inserting PIE CHAR for FINAL EXAM (1) Select Cell Range (Stu Name & Final Exam) Microsoft Excel (2) Insert tab (2) Select Pie Char  charts inserting PIE CHAR for FINAL EXAM RESULT Microsoft Excel  print print the worksheet (1) File Tab Microsoft Excel (2) Print  1. Learned how to freeze pane 2. Dealing with multiple functions summary 3. Inserting chart 4. Printing Excel sheets the end.. Thank you Computer Skills (COMP 105) Lecture #8 The Microsoft PowerPoint 2016 Presenter : Ms.Amal Alkhaldi Microsoft PowerPoint MS PowerPoint is a program that is included in the Microsoft Office suite. It is used to make presentations for personal and professional purposes. Presenter : Ms.Amal Alkhaldi Power Point Interface When PowerPoint is opened the PowerPoint Start Screen will appear. The start screen allows you to create a new presentation. by choosing from the list of pre-made templates. Presenter : Ms.Amal Alkhaldi Blank Presentation Overview Presenter : Ms.Amal Alkhaldi The Microsoft PowerPoint 2016 Interface Presenter : Ms.Amal Alkhaldi The Microsoft PowerPoint 2016 Interface 1. Quick Access Toolbar - Allows you to keep shortcuts to your favorite and frequently used tools. 2. Ribbon Display Options - You can collapse, auto hide, or show the whole ribbon. 3. File Tab (Backstage View) - The backstage view is where you manage your files and the information/properties about them (e.g. open, save, print, protect document, etc.). 4. Ribbon - Tabbed interface, where you can access the tools for formatting your presentation. The Home tab will be used more frequently than the others. 5. Tell Me - Look up PowerPoint tools, get help, or search the web. Presenter : Ms.Amal Alkhaldi The Microsoft PowerPoint 2016 Interface 6. Collapse the Ribbon- This button will collapse the ribbon. Click on the pinned icon to re-open the ribbon. 7. Mini Toolbar - Select or right-click text or objects to get a mini formatting toolbar. 8. Slides Tab - Use this to navigate through your slides within your presentation. 9. Slide - This is where you type, edit, insert content into your selected slide. 10. Status Bar - View which slide you are currently on, how many slides there are, speaker notes or comments in your presentation, change your views, or change your zoom level. Presenter : Ms.Amal Alkhaldi The Ribbon The Ribbon contains multiple tabs, each with several groups of tools. The tools provided in the ribbon will help you complete common tasks in PowerPoint. The Ribbon has ten tabs: 1. File 2. Home 3. Insert 4. Design 5. Transitions 6. Animations 7. Slide Show 8. Review 9. View 10. Format Presenter : Ms.Amal Alkhaldi The Ribbon (Home tab ) The Home tab gives you access to some of the most commonly used commands for working with Power Point, including copying and pasting, adding new slides, formatting, aligning paragraphs. Presenter : Ms.Amal Alkhaldi The Ribbon (Insert tab) The Insert tab allows you to insert pictures, charts, tables, shapes, new slides, and more to your presentation. Presenter : Ms.Amal Alkhaldi The Ribbon (Design) The Design tab gives you access to a variety of design tools, including presentation formatting, adjusting slide size, which can give your presentation a polished look. Presenter : Ms.Amal Alkhaldi The Ribbon (Transition tab) The Transition tab allows you to choose from different transition styles between slides. These styles will be helpful when presenting your Presentation. Presenter : Ms.Amal Alkhaldi The Ribbon (Animation tab) The Animation tab allows you to display different sections in one slide in different orders. It also allows you to choose in what manner these sections should appear on your slide. Presenter : Ms.Amal Alkhaldi The Ribbon (Slide Show) The Slide Show occupies the full computer screen, exactly the way your presentation will look on a big screen when your audience sees it. You can see how your graphics, timings, movies, animated effects, and transition effects will look during the actual presentation. Presenter : Ms.Amal Alkhaldi The Ribbon (Review tab) The Review tab is a place to check your spelling and insert comments on the presentation. You also have a thesaurus for when you feel like you are using the same word over and over. Presenter : Ms.Amal Alkhaldi The Ribbon (Cont.) The View tab is a feature that let’s you change how the presentation appears. Presenter : Ms.Amal Alkhaldi New Presentation To begin a new project in Power Point 1. Select the file tab. Backstage view will appear. 2. Select New, then click a template. 3. A new, presentation will appear. Presenter : Ms.Amal Alkhaldi Selecting, Adding & Deleting slides To add a slide, click on the “New Slide” icon in Home tab. To work on a slide, go to the slide column (left side of screen)-click on it. To delete a slide- go to slide column- click on it- press “Backspace” button Presenter : Ms.Amal Alkhaldi Home Tab- slide layouts To shrink/enlarge text box borders- click on a “sizing handle” and drag. You can click on the Layout tool (next to New Slide) to change to another type of slide layout. Different layouts give room for pictures, charts, tables. Presenter : Ms.Amal Alkhaldi Changing Slide Size To change the page size: Word has a variety of predefined page sizes to choose from. 1. Select the “design” tab, then click the “Slide Size” command. 2. A drop-down menu will appear. The current slide size is highlighted Presenter : Ms.Amal Alkhaldi Slide Transitions Affects the way slides appear on the screen- good finishing touch Go to Animation Tab- Transition to This Slide group- click on a slide icon to preview it. After choosing, click on “Apply to all slides” Timed slide advance option on the far right under “Advance Slide.” Presenter : Ms.Amal Alkhaldi Themes A Theme is a set of formatting options that is applied to an entire presentation. A theme includes a set of colors, a set of fonts, and a set of effects. Using themes shortens formatting time and provides a unified, professional appearance. The Themes group is located on the Design tab, it allows you to select a theme from the Themes Gallery. You can apply variants, and customize the colors, fonts, and effects of a theme. Presenter : Ms.Amal Alkhaldi Applying a Theme to a Presentation 1. On the Ribbon, select the Design tab. 2. In the Themes group, hover over a theme with your mouse to see a preview. 3. Click the arrows to scroll to additional themes. Presenter : Ms.Amal Alkhaldi Shortcuts and Right-clicking Ctrl-Z to undo changes, Ctrl-Y to redo changes. To select text, highlight with mouse or press Ctrl-A to select all text in a text box. To change font, color, & size, text and then right–click on it to get mini pop-up toolbar & menu Presenter : Ms.Amal Alkhaldi Shortcuts and Right-clicking Ctrl-Z to undo changes, Ctrl-Y to redo changes. To select text, highlight with mouse or press Ctrl-A to select all text in a text box. To change font, color, & size, text and then right–click on it to get mini pop-up toolbar & menu Presenter : Ms.Amal Alkhaldi Home Tab- bullet Points Automatic…click on Bullets icon in Home tab to turn off. To start new bullet, press enter To make a sub-point, press tab To go back to a regular bullet pt, right-click and then click on the “Decrease Indent” icon (in mini pop-up menu or in Home tab). Keep bullet pts. concise Presenter : Ms.Amal Alkhaldi Graphics Inserting Pictures : Images from your own collection and experiences may also add value to your presentation. You must have the image saved prior to adding it to your presentation. 1. Go to the Insert tab 2. Click Pictures. 3. This will open the Insert Pictures window 4. In the Insert Picture dialog box, navigate to find your image. 5. Select your image. Presenter : Ms.Amal Alkhaldi Graphics Draw Shapes Shapes are simple geometric objects that are pre-created by PowerPoint and can be modified. A shape can contain text or can appear without it. It can also be filled with color, and the outline of the shape can be given a different style and color. Presenter : Ms.Amal Alkhaldi  Graphics Inserting a Shape 1. Select the Insert Tab. 2. Click Shapes. 3. Select the shape you wish to draw 4. Your cursor becomes a small black plus sign. 5. In the Slide pane, point the crosshair mouse pointer to the upper-left corner of the area where you want to draw the shape, hold the left mouse button down, and then drag diagonally down to the right to create the shape. Presenter : Ms.Amal Alkhaldi Graphics Altering a Shape : 1. You can now move your shape if necessary by clicking on the object, holding down the left mouse button, and dragging it to another location. 2. You may also alter the look of your shape by selecting the shape and clicking the Format tab. 3. In the Shape Styles group, scroll through additional styles and click on the desired style to apply it to the shape. Presenter : Ms.Amal Alkhaldi Bullet Point Animations The Animate command affects text in a PPT show (if you do not select an animation, all text will appear with slide). Click on the text box- go to Animations Tab/ Animations group/Animate command (must be done for every slide). Choose the animation style. “1st order paragraph” means bullet pts. Presenter : Ms.Amal Alkhaldi Slide Show PowerPoint presentations are meant to be supplemental information, not a script. Starting the Slide Show 1. Select the Slide Show tab. 2. Click From Beginning to begin the presentation from the first slide or click From Current Slide to begin the presentation from the slide which currently appears in the Slide Preview pane Note: You can also run the presentation from the current slide by clicking the slide show icon located on the status bar or press F5 Presenter : Ms.Amal Alkhaldi Presentation Tools PowerPoint provides tools that are available for use while presenting your slide show. Presenter : Ms.Amal Alkhaldi Presentation Tools Presenter : Ms.Amal Alkhaldi Printing PowerPoint 2016 allows you to print your presentation in order to aid you in presenting or to give your audience something to take notes on. There are multiple formats available when printing; you should choose a format which best suits your presentation and audience needs. But first Check your text for errors by pressing F7. Presenter : Ms.Amal Alkhaldi Printing From the Backstage view: 1. Click the File tab. 2. Click on Print to view the printer settings 3. Indicate the number of copies you would like to print. 4. Select the printer. Presenter : Ms.Amal Alkhaldi How to: Open an Existing Presentation 1. Navigate to Backstage view, then click Open. 2. You can browse from Recent Presentations or from Computer(Eg, Documents) Presenter : Ms.Amal Alkhaldi How to: Open an Existing Presentation 3. The Open dialog box appears. Locate and select your document, then click Open. 1 2 Presenter : Ms.Amal Alkhaldi To Save a Presentation 1. Locate and select the Save command on the Quick Access toolbar. 2. If you are saving the document for the first time Save As will appear in Backstage view. 3. You will then need to choose where to save the file and give it a file name. Presenter : Ms.Amal Alkhaldi Presenter : Ms.Amal Alkhaldi To Save a Presentation 4. The Save As dialog box will appear. Select the location where you wish to save the presentation. 5. Enter a file name for the presentation, then click Save. Not: Use shortcut Ctrl+S Choose a location and type a file name, then click Publish Presenter : Ms.Amal Alkhaldi How To: Export Presentation to PDF 1. Click the File tab to access Backstage view. 2. Click Export, then select Create PDF/XPS. Presenter : Ms.Amal Alkhaldi How To: Export Word to PDF 3. The Save As dialog box will appear. Select the location where you wish to export the documents, enter a file name, then click Publish. Presenter : Ms.Amal Alkhaldi Presenter : Ms.Amal Alkhaldi Computer Skills (COMP 105) Lecture #9 The Microsoft Access 2016 Presenter : Ms.Amal Alkhaldi Database Concepts  Database fundamentals  Tables, fields, and field types  Primary keys  Filtering, sorting, and relationships  Forms, queries, and reports Presenter : Ms.Amal Alkhaldi Database fundamentals(Database Concepts) Definition of a database: A database is an organized collection of data stored and managed in a way that allows for efficient retrieval, manipulation, and maintenance of information. Purpose of databases: Databases are used to store and manage data in a structured and organized manner, enabling users to access, update, and analyze information effectively. Database management systems (DBMS): DBMS are software applications that provide tools and interfaces for creating, managing, and interacting with databases, such as MySQL, PostgreSQL, Microsoft SQL Server, and Oracle Database. Presenter : Ms.Amal Alkhaldi Tables, fields, and field types o Tables, Fields, and Field Types: Data in a database is stored in tables, which are similar to spreadsheets with rows and columns. Each table represents a specific entity or object, and the columns (fields) represent the different attributes or characteristics of that entity. Field types determine the kind of data that can be stored in each column, such as text, numbers, dates, or Boolean values. Presenter : Ms.Amal Alkhaldi  entity Tables, fields, and field types attributes or characteristics Each table represents a specific entity or object, and the columns (fields) represent the different attributes or characteristics of that entity. Presenter : Ms.Amal Alkhaldi Primary keys o Primary Keys: o A primary key is a unique identifier for each row in a table, ensuring that each record is distinct and can be easily referenced. o Primary keys can be a single field or a combination of multiple fields. o Primary keys help maintain data integrity and enable the establishment of relationships between tables. Presenter : Ms.Amal Alkhaldi Primary keys o A primary key is a unique identifier for each row in a table, ensuring that each record is distinct and can be easily referenced. Presenter : Ms.Amal Alkhaldi Filtering, sorting, and relationships o Filtering, Sorting, and Relationships: o Filtering allows you to display only the data that meets specific criteria, hiding the rest. o Sorting arranges the data in a specific order, such as alphabetically or numerically. o Relationships define the connections between tables, allowing you to link and retrieve data from multiple tables simultaneously. Presenter : Ms.Amal Alkhaldi Forms, queries, and reports Forms, Queries, and Reports: Forms provide a user-friendly interface for entering, editing, and viewing data in the database. Queries are used to retrieve and manipulate data from the database based on specific criteria. Reports present the data in a structured and formatted layout, often for printing or sharing purposes. Presenter : Ms.Amal Alkhaldi Access 2016 Module 1 Getting Started with Access 2016 Presenter : Ms.Amal Alkhaldi Module Objectives Explore a database Create a database Create a table Create primary keys Relate two tables Enter data Edit data Presenter : Ms.Amal Alkhaldi Explore a Database Can start Access in different ways Database contains different objects Tables Queries Forms Reports Navigation Pane displays objects Presenter : Ms.Amal Alkhaldi Objects in a database Explore a Database (Slide 2 of 3) Presenter : Ms.Amal Alkhaldi  Explore a Database Access objects and their purpose Presenter : Ms.Amal Alkhaldi Table Important database terminology Presenter : Ms.Amal Alkhaldi Create a Database Use an Access template (sample database) or create a blank database Table Design View provides the most options for defining fields Datasheet View spreadsheet-like view of the data in a table Data type Characteristic of a field Presenter : Ms.Amal Alkhaldi Create a Table Essential tasks Define the fields Select data type for each field (e.g., numbers, text, dates) Name the table Determine how the table will participate in the relational database Identify primary key Field that contains unique data for each record Presenter : Ms.Amal Alkhaldi Creating a primary key field Create Primary Keys Presenter : Ms.Amal Alkhaldi Create a Blank Database Select a Blank Database From the Access Welcome screen Click Blank desktop database from the Access "welcome" screen From the File > New menu Click Blank desktop database from the Access "welcome" screen Presenter : Ms.Amal Alkhaldi  Create a Blank Database Your new database has now been created. It's a blank database with a table that is ready to be configured. Presenter : Ms.Amal Alkhaldi Customize the Blank Table Customize the Blank Table First, we're going to add a field to the existing table. Then we'll rename the existing field.. Select a Data Type for the New Field. Right-click Click to Add and select Short Text from the combo box. Presenter : Ms.Amal Alkhaldi Customize the Blank Table Name the Field Once you've selected a data type, the field header will be highlighted with the text Field1 so that you can provide a name for the field. Enter ArtistName as the name of the field. Presenter : Ms.Amal Alkhaldi Customize the Blank Table Rename the First Field The first field in our table is currently called ID. We'll rename it. Right-click on the ID field header, and select Rename Field. The field will be highlighted for you to rename it. Enter ArtistId. Presenter : Ms.Amal Alkhaldi Customize the Blank Table Save the Table Right-click on Table1 to save the table. Enter Artists at the prompt. our Finished Table Your database table now contains two fields (ArtistId and ArtistName). Presenter : Ms.Amal Alkhaldi Create a New Table Create a New Table Ensuring the Create tab is selected on the Ribbon, click Table. This will add a blank table called Table1 to the database. Presenter : Ms.Amal Alkhaldi  Create a Table Set up the Fields Now add 4 fields and rename the first. Set them up as follows: Presenter : Ms.Amal Alkhaldi Set a Primary Key Click Table Design from the Ribbon (ensuring that the Ribbon is on the Create tab). A blank table called Table1 will be displayed in Design View. Presenter : Ms.Amal Alkhaldi Set a Primary Key Set a Primary Key Right-click on the GenreId field and select Primary Key from the drop down list. This makes the field a primary key field. Once you've done this, you'll see a little key icon to the left of GenreId. Save the Table Presenter : Ms.Amal Alkhaldi Add Records Directly into Datasheet View Open the Genres table in Datasheet View and enter the following data: Presenter : Ms.Amal Alkhaldi Presenter : Ms.Amal Alkhaldi