OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido Pagina 244
- Pagina / 379
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Figure 232: Query table with aliases added
3) Run the query again. The results are in Figure 233.
Figure 233: Query run with aliases
We really do not need the column showing the difference between the FuelID
fields from the table and query, so we will hide it. While it will not be visible, it
will still be used in the calculations.
4) Hide a field that does not need to be seen.
Remove the check in the box of the Visible cell as in Figure 234.
Figure 234: Making a field invisible in a query run
5) Rerun the query (Figure 235).
Figure 235: Query run with aliases
Step 10: Close, save, and name the query.
My suggestion for a name is Fuel Economy.
There are obviously other calculations that can be made in this query such as cost
per distance traveled and how much of the cost belongs to each of the payments
types.
Note
To fully use queries requires a knowledge of set operations (unions,
intersections, and, or, complements, and any combinations of these).
Having a copy of the Hsqldb User Guide, available from
http://hsqldb.org/, is also extremely useful.
244 Getting Started with OpenOffice.org 3.3
- Getting Started 1
- OpenOffice.org 3.3 1
- Copyright 2
- Contributors 2
- Feedback 2
- Contents 3
- Chapter 1 9
- Introducing 9
- What is OpenOffice.org? 10
- Base (database) 11
- Math (formula editor) 11
- Minimum requirements 12
- How to get the software 12
- How to install the software 13
- Extensions and add-ons 13
- How to get help 13
- Starting OpenOffice.org 14
- Using the Quickstarter icon 15
- Disabling the Quickstarter 16
- Reactivating the Quickstarter 16
- Parts of the main window 17
- Moving toolbars 19
- Floating toolbars 19
- Right-click (context) menus 20
- Starting a new document 23
- Opening an existing document 23
- Saving a document 24
- Renaming and deleting files 25
- • Create New Folder 26
- • Default Directory 26
- Using the Navigator 27
- Undoing and redoing changes 28
- Closing a document 29
- Closing OpenOffice.org 30
- Using OpenOffice.org on a Mac 30
- Chapter 2 31
- Setting up 31
- OpenOffice.org 31
- User Data options 32
- General options 33
- Memory options 34
- View options 35
- Print options 37
- Path options 38
- Color options 39
- Font options 41
- Security options 41
- Security options and warnings 42
- Appearance options 43
- Accessibility options 44
- Java options 44
- Online Update options 45
- Improvement program 46
- General Load/Save options 46
- Choosing language settings 51
- Choose spelling options 52
- Choosing Internet options 53
- Chapter 3 55
- Using Styles and 55
- Templates 55
- What is a template? 56
- What are styles? 56
- Applying styles 57
- Using Fill Format mode 58
- Using the Apply Style list 58
- Modifying styles 59
- Using AutoUpdate 60
- Creating new (custom) styles 61
- Copying and moving styles 62
- Deleting styles 64
- Creating a template 66
- Editing a template 68
- Setting a default template 70
- Organizing templates 72
- Examples of style use 73
- Defining a sequence of styles 75
- Chapter 4 76
- What is Writer? 77
- The Writer interface 77
- Changing document views 79
- Working with documents 81
- Working with text 82
- • Edit > Paste Special, or 83
- Inserting special characters 85
- Setting tab stops and indents 86
- Checking spelling and grammar 87
- Using built-in language tools 88
- Using AutoCorrect 88
- Using word completion 89
- Using AutoText 89
- Formatting text 90
- Autoformatting 91
- Hyphenating words 92
- Manual hyphenation 93
- Formatting pages 94
- Creating headers and footers 95
- Numbering pages 96
- Changing page margins 97
- Adding comments to a document 98
- Creating a table of contents 99
- Working with graphics 100
- Printing 100
- Using mail merge 100
- Using fields 101
- Using hyperlinks 102
- Using cross-references 102
- Using bookmarks 103
- Using master documents 104
- Creating fill-in forms 104
- Chapter 5 105
- Getting Started with Calc 105
- What is Calc? 106
- Parts of the main Calc window 107
- Formula bar 108
- Opening and saving CSV files 109
- Opening a CSV file 110
- Saving as a CSV file 111
- Going to a particular cell 111
- Moving from cell to cell 112
- Moving from sheet to sheet 114
- Selecting cells 115
- Selecting columns and rows 116
- Selecting sheets 116
- Working with columns and rows 117
- Working with sheets 118
- Deleting sheets 119
- Renaming sheets 119
- Viewing Calc 120
- Splitting the screen 121
- Split screen bar 122
- Entering numbers 123
- Entering text 123
- Speeding up data entry 124
- Using the Fill tool on cells 125
- Defining a fill series 126
- Validating cell contents 127
- Editing data 128
- Formatting data 129
- Using manual line breaks 130
- Formatting numbers 131
- Formatting the font 132
- Formatting the cell borders 132
- Defining a new AutoFormat 133
- Using conditional formatting 134
- Hiding and showing data 134
- Outline group controls 135
- Sorting records 136
- Removing a print range 138
- Editing a print range 138
- Page breaks 140
- Headers and footers 141
- Header or footer appearance 142
- Chapter 6 144
- Getting Started with 144
- What is Impress? 145
- Starting Impress 145
- Slides pane 146
- Tasks pane 147
- Workspace 147
- Toolbars 148
- Status bar 148
- Navigator 148
- Workspace views 149
- Handout view 150
- Slide Sorter view 151
- Creating a new presentation 153
- Formatting a presentation 156
- Modifying the slide elements 158
- Adding text to a slide 158
- Adding and formatting text 159
- Quick font resizing 160
- Pasting text 160
- Pasting unformatted text 161
- Formatting pasted text 161
- Adding pictures 163
- Adding tables 164
- Adding charts 165
- Adding media clips 165
- Slide masters 166
- Creating a slide master 167
- Applying a slide master 167
- Modifying a slide master 169
- Presentation style 170
- Setting up the slide show 172
- Running the slide show 173
- Chapter 7 174
- What is Draw? 175
- The Draw workspace 175
- Choosing and defining colors 178
- Snap to grid 179
- Showing the grid 180
- Configuring the grid 180
- The basic drawing shapes 182
- Drawing an arrow 183
- Choosing line endings 183
- Drawing a rectangle or square 183
- Drawing a circle or ellipse 184
- Drawing curves 184
- Writing text 185
- Gluepoints and connectors 186
- Drawing geometric shapes 187
- Selection modes 189
- Selecting objects 190
- Selecting several objects 191
- Dynamic movement of objects 191
- Rotation 192
- Inclination and perspective 192
- Editing objects 193
- Drawing arrows 194
- Using styles 195
- Special effects 195
- Mirror copies 196
- Distorting an image 196
- Dynamic gradients 196
- Duplication 196
- Cross-fading 197
- Combining multiple objects 198
- Aids for positioning objects 199
- Working with 3D objects 199
- Exporting graphics 199
- Adding comments to a drawing 200
- Chapter 8 201
- Getting Started with Base 201
- Introduction 202
- Planning a database 203
- Creating a new database 204
- Creating database tables 205
- Caution 212
- Defining relationships 213
- Creating a database form 215
- Modifying a form 218
- Writer Guide for details 226
- Accessing other data sources 229
- Registering *.odb databases 230
- Viewing data sources 231
- Editing data sources 231
- 11 in the Writer Guide 232
- Some of 233
- Calc spreadsheets 234
- Entering data in a form 235
- Creating queries 237
- Creating reports 245
- Vacations table report 246
- Creating a dynamic report 248
- Modifying a report 250
- • Click the green checkmark 251
- More ways to create reports 252
- Chapter 9 253
- What is Math? 254
- Entering a formula 255
- <?> times <?> 256
- Right-click menu 257
- Example 2: 259
- Customizations 260
- Formula layout 262
- How do I make a derivative? 264
- Numbering equations 265
- Chapter 10 267
- Printing, Exporting 267
- Quick printing 268
- Controlling printing 268
- Impress and Draw 273
- Printing a brochure 274
- Exporting to PDF 277
- Exporting to other formats 284
- E-mailing documents 284
- Digital signing of documents 287
- Removing personal data 288
- Chapter 11 289
- Graphics, the Gallery 289
- Adding images to a document 290
- Linking an image file 291
- Embedding linked images 292
- Adding objects to the Gallery 295
- Creating an image map 297
- Using OOo’s drawing tools 298
- Creating drawing objects 299
- Resizing a drawing object 300
- Grouping drawing objects 300
- Using Fontwork 301
- Editing a Fontwork object 302
- Using the Fontwork toolbar 303
- Using the Formatting toolbar 304
- Using menu options 306
- Using the 3D-Settings toolbar 306
- Chapter 12 307
- Creating Web Pages 307
- Creating hyperlinks 309
- Using the Hyperlink dialog 310
- Editing hyperlinks 312
- Removing hyperlinks 312
- Chapter 13 322
- Your first macros 323
- Creating a simple macro 324
- Running the macro 325
- Viewing and editing the macro 326
- Creating a macro 328
- A complicated example 329
- Running the macro quickly 331
- The dispatch framework 332
- Macro organization 333
- Where are macros stored? 335
- Importing macros 336
- Downloading macros to import 337
- How to run a macro 338
- Menu item 340
- Keyboard shortcuts 340
- Extensions 342
- Finding more information 343
- Printed and eBook materials 344
- Chapter 14 345
- Customizing 345
- Customizing menu content 346
- Creating a new menu 347
- Modifying existing menus 348
- Adding a command to a menu 348
- Modifying menu entries 348
- Customizing toolbars 349
- Creating a new toolbar 350
- Adding a command to a toolbar 350
- Assigning shortcut keys 353
- Saving changes to a file 354
- Assigning macros to events 355
- Some popular extensions 356
- Appendix A 358
- Keyboard Shortcuts 358
- General keyboard shortcuts 360
- Getting help 361
- Managing documents 361
- Defining keyboard shortcuts 362
- Further reading 362
- Appendix B 363
- Open Source 363
- Open Standards 363
- OpenDocument 363
- The OpenOffice.org community 364
- What is “open source”? 365
- What are “open standards”? 365
- What is OpenDocument? 365
- Frequently asked questions 366
- File formats OOo can open 367
- Opening spreadsheets 368
- Opening presentations 368
- Opening graphic files 368
- Opening formula files 368
- File formats OOo can save to 369
- Index 371 371
- Index 373 373
- Index 375 375
- Index 377 377
- Index 379 379
Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.3
(275 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.045 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales