...Excel Excel ShortCut Keys and Tips Enter data by using shortcut keys To Complete a cell entry Cancel a cell entry Repeat the last action Start a new line in the same cell Delete the character to the left of the insertion point, or delete the selection Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line Move one character up, down, left, or right Move to the beginning of the line Edit a cell comment Create names from row and column labels Fill down Fill to the right Fill the selected cell range with the current entry Complete a cell entry and move down in the selection Complete a cell entry and move up in the selection Complete a cell entry and move to the right in the selection Complete a cell entry and move to the left in the selection Press ENTER ESC F4 or CTRL + Y ALT + ENTER BACKSPACE DELETE Enter the time Insert a hyperlink Complete a cell entry Copy the value from the cell above the active cell into the cell or the formula bar Alternate between displaying cell values and displaying cell formulas Copy a formula from the cell above the active cell into the cell or the formula bar Enter a formula as an array formula Display the Formula Palette after you type a valid function name in a formula Insert the argument names and parentheses for a function, after you type a valid function name in a formula Display the AutoComplete list CTRL + SHIFT + : (COLON) CTRL + K ENTER CTRL + SHIFT + " (QUOTATION MARK) CTRL...
Words: 3690 - Pages: 15
...Behaviors Select Window | Behaviors to open the Behaviors panel Select the Submit button on the form and then click the Add Behavior button in the Behaviors panel. A list of options that can be modified will appear. Select Validate Form (see figure below). The validate form dialog box should appear. In the fields box, select the information in the form that is required and select the Required check box. Click OK to close the Validate Form box and to implement the behaviors. Save the changes. Dragging AP Elements Display a template file Click on the blank page to deselect the AP elements. In the tag selector, click the <body> tag. Click Add Behaviors in the behaviors panel and select Drag AP Element. The Drag Ap Element dialog box will appear (see figure below). Select the Basic tag and from the drop down list Select the desired div. Click OK Select File | Save All to save the changes. Using Assets and the Dreamweaver Library Window | Assets. From the Main menu select The Assets panel should appear in the files panel. Select the Images group from the Assets panel. Click the desired photo to select it. Click and drag this file into the desired editable region and add alternate text. Select the Library group in the Assets panel. Then select the paragraph in the editable region and drag it into the bottom section of the Assets panel. An icon and Text box should appear. Name the icon and press Enter to update Library. Save...
Words: 255 - Pages: 2
...Excel 2013 Help Page 1 of 8 Keyboard shortcuts in Excel This article describes what Key Tips are and how you can use them to access the ribbon. It also lists Ctrl combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013. In this article Keyboard access to the ribbon Will my old shortcuts still work? Ctrl combination shortcut keys Function keys Other useful shortcut keys Keyboard access to the ribbon If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. The ribbon comes with new shortcuts, called Key Tips. To make the Key Tips appear, press Alt. To display a tab on the ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab's buttons appear. Then, press the key for the button you want. Will my old shortcuts still work? Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013. For example, Ctrl+C still copies to the clipboard, and Ctrl+V still pastes from the clipboard. Most of the old Alt+ menu shortcuts still work, too. However, you need to know the full shortcut from memory — there are no screen reminders of what letters to press. For example, try pressing Alt, and then press one of the old menu keys E (Edit), V (View), I (Insert), and so on. A box pops up saying you're using an access key from an earlier version of Microsoft...
Words: 2819 - Pages: 12
...Calculator Program: import java.awt.*; import javax.swing.*; public class Calculator extends JFrame { JTextField display;// Display text field. JPanel buttonPanel;// Panel for buttons. JButton buttons[];// Array to create button objects. Calculator() { super("Calculator");// Gives the frame the title of Calculator. display = new JTextField();// Creates and stores the object of the text // field in the display. buttons = new JButton[16];// Array made up of 16 variables to signify // buttons. buttons[0] = new JButton("7");// Seven button. buttons[1] = new JButton("8");// Eight button. buttons[2] = new JButton("9");// Nine button. buttons[3] = new JButton("/");// Divide button. buttons[4] = new JButton("4");// Four button. buttons[5] = new JButton("5");// Five button. buttons[6] = new JButton("6");// Six button. buttons[7] = new JButton("*");// Multiply button. buttons[8] = new JButton("1");// One button. buttons[9] = new JButton("2");// Two button. buttons[10] = new JButton("3");// Three button. buttons[11] = new JButton("-");// Subtract button. buttons[12] = new JButton("0");// Zero button. buttons[13] = new JButton(".");// Dot button. buttons[14] = new JButton("=");// Equals button. buttons[15] = new JButton("+");// Add button. buttonPanel = new JPanel();// Creates panel for buttons. buttonPanel.setLayout(new GridLayout(4, 4, 5, 5));// Sets the layout of // the...
Words: 917 - Pages: 4
...Patient Demographics MU Core Set 7 Record Pt Demographics: Sex, race, ethnicity, date of birth & preferred language. More than 50% MU Menu Set 4 Send reminders to patients via communication preference (recall) for follow up care. More than 20% of pts 65 & older or 5 & younger Launching Product Login Maneuver Keyboard • Can use mouse • Keyboard (alt & underlined letter) • Tab or Enter-most efficient way to move from field to field (beginning of field) • Shift, tab – takes you back to previous field • Use end/home keys • Arrow keys • Ctrl+C=Copy • Ctrl+V=Paste • Ctrl+X=Copy/Cut • Ctrl+N = Next Tab • Ctrl+B = Prior Tab Search for Patient – in Pt Demographic Screen 7 Different Ways Add a New Patient Begin name w/ZZ for practice patients Special & Unique Features: Logoff takes you out and back in to the exact patient and exam tab on this station ACCESSING RECORD • Choose the option Exam • Choose the Medical Bag Icon OPTIONS ADD • Add New • Choose the proper layout o Default o Show some of the other layouts – Transfer Paper SUMMARY TAB • Do Not Fill out the Summary Tab – will auto fill from other tabs • Overview of information entered for the date of service and historical data for sub folders CHIEF COMP - Chief Complaint/History of Present Illness • Logic Fields – easy check boxes o New Patient o Consult – Medicare no longer reimburses for Consultations **Yellow fields represent exam logic fields. They enable the system...
Words: 769 - Pages: 4
...Getting Started * Menus * Shortcut menus * Toolbars * Customizing toolbars Working With Files * Creating and opening documents * Saving documents * Renaming documents * Working on multiple documents * Close a document Working With Text * Typing and inserting text * Selecting text * Deleting text * Undo * Formatting toolbar * Format Painter Formatting Paragraphs * Paragraph attributes * Moving, copying, and pasting text * The clipboard * Columns * Drop caps Styles * Apply a style * Apply a style from the style dialog box * Create a new styles from a model * Create a simple style from the style dialog box * Modify or rename a style * Delete a style Lists * Bulleted and numbered lists * Nested lists * Formatting lists Tables * Insert Table button * Draw a table * Inserting rows and columns * Moving and resizing a table * Tables and Borders toolbar * Table properties | | | | Graphics * Adding clip art * Add an image from a file * Editing a graphic * AutoShapes Spelling and Grammar * AutoCorrect * Spelling and grammar check * Synonyms * Thesaurus Page Formatting * Page margins * Page size and orientation * Headers and footers * Page numbers * Print preview and printing Macros * Recording a macro * Running a macro Table of Contents * Mark TOC entries * Generate a table of contents Web Wizard * Using the Web Wizard Creating Web Pages...
Words: 7811 - Pages: 32
...Caravan Park Bookings System Creating the Data Entry Form based on multiple tables to enter a booking, a Mainform/Subform Choose Create form by using wizard The purpose of this form is to enter a booking, in a user-friendly manner using the data that is available in appropriate tables. A wise choice of fields can save time on re-designing, once you practice these steps. As a customer activates a booking choose (appropriately) some or all of the fields from the Customers table, then select all of the fields from the Bookings table and then choose (appropriately) some of the fields from the Sites table. Click next and the wizard will show you a view of what the layout of the form will look like, organised by Customers. There are two forms, where one is a subform of the other, the mainform. Therefore title the two forms appropriately, with almost the same name, for example Bookings Mainform Bookings Subform Next validate that you can enter a booking for an existing customer booking a site. Consider the data the user enters and the data supplied by the system. choose a Customer and enter a site ID choose a date enter a duration Delete the Bookings label in the subform as it takes up too much space. The end result should be to make the subform show as many records as possible, or in other words it should take up the majority of the form. Position the fields in both the mainform and subform to take up less space. Creating a drop-down list (combo box) to select a site Rather...
Words: 431 - Pages: 2
...RadioButton public class RadioButton extends CompoundButton java.lang.Object ↳ android.view.View ↳ android.widget.TextView ↳ android.widget.Button ↳ android.widget.CompoundButton ↳ android.widget.RadioButton Known Direct Subclasses AppCompatRadioButton A radio button is a two-states button that can be either checked or unchecked. When the radio button is unchecked, the user can press or click it to check it. However, contrary to a CheckBox, a radio button cannot be unchecked by the user once checked. Radio buttons are normally used together in a RadioGroup. When several radio buttons live inside a radio group, checking one radio button unchecks all the others. See the Radio Buttons guide. XML attributes See CompoundButton Attributes, Button Attributes, TextView Attributes, View Attributes Summary Inherited XML attributes From class android.widget.CompoundButton From class android.widget.TextView From class android.view.View Inherited constants From class android.view.View Inherited fields From class android.view.View Public constructors RadioButton(Context context) RadioButton(Context context, AttributeSet attrs) RadioButton(Context context, AttributeSet attrs, int defStyleAttr) RadioButton(Context context, AttributeSet attrs, int defStyleAttr, int defStyleRes) Public methods CharSequence getAccessibilityClassName() Return the class name of this object to be used for accessibility purposes. void...
Words: 453 - Pages: 2
...IT Services Microsoft Access 2010™ An Intermediate Guide (Level 2) Contents Introduction ..............................................................................................................1 Speeding up Table Creation ................................................................................2 Using Datasheet View ...........................................................................2 Using a Table Template .........................................................................3 Input Masks ...............................................................................................3 Importing Tables .....................................................................................3 Relationships .............................................................................................................4 Finding Unmatched Records ...............................................................................6 The Find Unmatched Query Wizard .................................................7 Action Queries ..........................................................................................................7 Make-Table Queries ...............................................................................7 Delete Queries .........................................................................................8 Append Queries .......................................................................................8 Update Queries ................
Words: 8701 - Pages: 35
...User Interface Design Coverage: This chapter teaches you to use additional controls to build application forms. These controls include: TextBox, MaskedTextBox, RichTextbox, GroupBox, CheckBox, RadioButton, and PictureBox. You will learn how to lay out a form and set various properties to change the appearance and behavior of controls. Programming topics include clearing TextBox controls, changing text color, concate INTRODUCTION Chapter 2 In-Class Project The in-class project for this chapter uses numerous controls. You will build a project form that is similar to that shown below. It will include the following new controls: TextBox MaskedTextBox GroupBox RadioButton CheckBox PictureBox GroupBox Control A GroupBox control is used to group or contain other controls. It is used to organize a form into different sections and this can make the form easier for an application user to use. Name property – most of the time you will not bother to name a GroupBox control because they are rarely referred to when you write programming code – if you were to name the control, a name such as StudentInformationGroupBox would be appropriate. Text property – displays the words in the upper left corner of the GroupBox control. If you leave the Text property blank, the GroupBox looks like a rectangle. The form above has three GroupBox controls with Text property settings of Student Information...
Words: 6365 - Pages: 26
...Teaching Computer Skills To Children with Visual Impairments: A Concept-Based Approach | [Graphic. Three color photos are standing side-by-side. In the first, a young teen-age boy is typing on a computer keyboard and smiling. In the second, a man is sitting in front of a computer reading using his refreshable braille display. In the third, three children are in a computer lab. All three have headphones. One is looking at the screen and one is listening to the output. (The face of the third child is blocked by the head of the second). End of graphic description]Joanmarie Diggs, M.Ed.The Carroll Center for the Blind 2002 AER International Conference 20 July 2002We know….The world is made up of objects whose function and form dictate how we access and use these objects. Children who are blind or visually impaired need concrete, hands-on experiences so that they can understand the world around them and can independently and safely interact with the objects they encounter.Similarly….The Windows Operating System is made up of objects whose function and form dictate how we access and use these objects. As with accessing objects in the environment, people who are sighted have visual information about the form and function of Windows objects and controls. In addition, a mouse user can access all windows controls in the same way: clicking on them. Children who are blind or visually impaired need to understand the form and function of these objects and controls so that they can independently...
Words: 6098 - Pages: 25
...Example 2.1 with Pie Chart - Graphing and Summarizing Qualitative Data A group of cardiac physicians in southwest Florida have been studying a new drug designed to reduce blood loss in coronary artery bypass operations. Blood loss data for 114 coronary artery bypass patients (some who received a dosage of the drug and others who did not) are saved in the BLOODLOSS file. Although the drug shows promise in reducing blood loss, the physicians are concerned about possible side effects and complications. So their data set includes not only the qualitative variable, DRUG, which indicates whether or not the patient received the drug, but also the qualitative variable, COMP, which specifies the type (if any) of complication experienced by the patient. The four values of COMP recorded by the physicians are (1) redo surgery, (2) post- op infection, (3) both, or (4) none. Figure 2.5, generated using SPSS, shows summary tables for the two qualitative variables, DRUG and COMP. Interpret the results. Interpret the Minitab output shown in Figure 2.6 and the SPSS output shown in Figure 2.7. This tutorial will demonstrate how to use Minitab to reproduce Figures 2.5, 2.6 and 2.7 on page 36 of the textbook. Steps one through 8 will produce tables similar to those of Figure 2.5 on page 36 of in the text After loading the minitab worksheet BLOODLOSS.MTW: 1. Begin by clicking on Stat. 2. Next, click on Tables. 3. Then click on Tally Individual Variables. 4. Double-click C2 DRUG. 5. Double-click C3...
Words: 821 - Pages: 4
...Getting Started with WinEst Using WEI Commercial with Assemblies Item Database Sample Exercise Professional Cost Estimating and Budgeting Things you need to know about WinEst Pull Down Menus & Toolbars WinEst allows customization of your Toolbars. Here is an example: If you prefer a large, easy to see selection of Icons, Select Preferences from the Tools menu. Now select the Toolbar option from the displayed list of preferences. In the upper right hand corner of this prompt, under Style, change Images to Large. [pic] Toolbar Small Images with Short Text [pic] Toolbar Large Images with Text WinEst has pull down menus for each of the following - File, Edit, View, Filters, Tables, Tools, Database, Reports, Custom, Window and Help. When the mouse is clicked on one of these menu items, a list drops down with the available commands for that menu. Scan the menus to see the features available in the WinEst program. Help Help is always available. You can select Contents or Search for help commands from the Help menu or press the F1 key to view help. To close the Help system, click on the X in the upper right hand corner. Maneuvering about the System WinEst has three main views which enable you to follow a structured method of building and reviewing your estimates. You can move from view to view at any time by clicking one of the corresponding toolbar buttons (Takeoff, Sheet or Totals) or by making selections from the View menu. Takeoff ...
Words: 4953 - Pages: 20
...Activity 2 (2 hours) a) Create an efficient database structure that minimises data duplication. Ensure you use all and only the fields provided Screen-print relationships in the database, making sure table names, field names and relationships can be clearly seen b) Use the correct date types and key fields for your database. Produce screen-prints in DESIGN view of each of your tables showing only the field names, data types and primary keys c) An efficient database must include suitable validation. (Must name validation used) Screen-print in design view ONE example of range check on an appropriate field. Ensure you can clearly see the field it is applied to and the range specified Screen-print in design view one example of presence check on an appropriate field. Ensure you can clearly see the field it is applied to. Screen-print in design view give one example of a list check or table lookup on an appropriate field. Ensure you can clearly see the field d) Import the data from the text files and enter the additional data provided at the beginning of this activity into the tables you have created Screen-print each table showing at least 5 records, or all records if there are fewer than five and the full record count. (If the fields are too wide to fit on one page, truncate data is allowed) Activity 3 (4 hours) a) A form is required that will allow Vicky to add the details of students who wish to take part in productions...
Words: 790 - Pages: 4
...Keyboard shortcuts To do this Press Switch to the next program. ALT+TAB Switch to the previous program. ALT+SHIFT+TAB Display the Windows Start menu. CTRL+ESC Close the selected workbook window. CTRL+W or CTRL+F4 Restore the window size of the selected workbook window. CTRL+F5 Switch to the next pane in a worksheet that has been split (Window menu, Split command). F6 Note When the task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) is visible, F6 includes that pane when switching between panes. Switch to the previous pane in a worksheet that has been split. SHIFT+F6 Note When the task pane is visible, SHIFT+F6 includes that pane when switching between panes. When more than one workbook window is open, switch to the next workbook window. CTRL+F6 Switch to the previous workbook window. CTRL+SHIFT+F6 When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC. CTRL+F7 When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ENTER. CTRL+F8 Minimize a workbook window to an icon. CTRL+F9 Maximize or restore the selected workbook window. CTRL+F10 ...
Words: 7223 - Pages: 29