OpenOffice.org 2.x Guía de usuario Pagina 408
- Pagina / 508
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 7: Databases and Data Sources
1. Click the Queries icon on the left side of the database window.
2. Click Create Query in Design View.
3. The Add Tables window opens in front of the Query Design window. Add both
tables to the query.
4. Click Close in the Add Tables window.
5. Add the following fields from the Appointments table: Subject, Location, Start
date, Start time, End date, End time, Notes.
6. Add the TypeName field from the Types table.
7. In the Start date column, on the Criterion row, enter any date such as
3/9/1972.
8. Click the Switch Design View On/Off button. The SQL statement that underlies the
query is now visible. Toward the end of the statement something like the following
appears: AND (("Appointments"."Start date" = {D ' 1972-03-
09'})). This statement finds records where the Start date equals the date 3/9/1972.
9. Replace {D '1972-03-09'} with the text CURRENT_DATE and click the Switch
Design View On/Off button again.
10. Click the Run Query button. The query results appear at the top of the resulting
window.
11. Save the query as Appointments for Today and close the query.
If the database does not contain appointments for today, add an appointment for today and
rerun the query by double-clicking on it.
Add a sort order to the query
There will be days with more than one appointment. In that case, it would be useful to sort
the results of the query.
1. Open the query for editing by right-clicking the icon for the query and choosing Edit.
2. To add a sort order to a column, click in the Sort row in that column. The Sort row is
just below the Table row. Click the Sort row in the Start time column.
3. Click the drop-down for Sort and choose Ascending.
4. Set the Sort to Ascending for the End date and End time fields as well.
5. Save the query.
If the database contains appointments for the current day, try running the query.
Changing the Join type in the query
When the query is run, as it exists currently, some appointments won't appear.
OpenOffice.org User Guide for 2.x 374
- OpenOffice.org User Guide 1
- Feedback 3
- Acknowledgements 3
- Modifications and updates 5
- Contents 7
- Important Features with 2.x 37
- Multiple Language Support 41
- New Charting Module 41
- Help Agent 44
- The Title Bar 48
- The Menu Bar 49
- The Toolbars 49
- Examples of Floating Toolbars 50
- Using Floating Toolbars 51
- The document window 51
- Docking toolbars 51
- Docking windows 52
- Opening and Saving Documents 53
- Saving Documents 56
- Backup a File Automatically 57
- OpenOffice.org File Formats 58
- Sending Documents as E-Mail 61
- Printing Documents 62
- Spellcheck 66
- 5. Click Next 71
- Using Automatic Functions 74
- Undo URL recognition 76
- Turn off URL recognition 76
- Shift+Ctr+N 78
- Find & Replace 79
- Match Case 80
- Searching Backward 81
- Current Selection Only 81
- Searching for Styles 81
- Searching for Text Attributes 81
- Similarity Search 82
- Character Result/Use 83
- Permissions available 87
- Name Type Default 89
- Entering and Formatting Text 94
- Using the keyboard: 95
- Using the mouse: 95
- Deleting characters 96
- Deleting text 96
- Status bar uses 97
- Non-breaking spaces 99
- Non-breaking hyphen 99
- Hyphen, em-dash and en-dash 99
- Creating a link 106
- Delete (Del) 107
- Backspace 107
- Create Page Styles 118
- Editing Page Styles 122
- Page Styles Summary 125
- Defining default Templates 126
- Templates and Styles 127
- Automatic Spellcheck 130
- Using AutoText 131
- AutoText With AutoComplete 134
- Text Frames 135
- Editing Text Frames 136
- Linking Text Frames 136
- Using Text Animation 138
- Character 140
- Drawing Lines in Text 141
- Editing Text With FontWork 142
- Aligning Text With Lines 144
- The Navigator 145
- Other Navigator Features 147
- • Select Update Index/Table 150
- Preparation 153
- Entering Data 153
- Example file 154
- Headings and Numbering 159
- before 170
- Numbering Lines 172
- Tables in Text 173
- Table AutoFormat 175
- Table properties in general 175
- Calculating in Text Documents 177
- Statistical Functions 178
- Trigonometric Functions 178
- More Defined Values 179
- (Ctrl+a) 185
- Defining Captions 191
- Editing or deleting captions 191
- Charts with Linked Data 195
- Automatic hyphenation 206
- Manual Hyphenation 206
- Fixed and Variable Fields 209
- Printing Address Labels 213
- Newsletters 216
- Creating Page Styles 217
- Editing Headers 217
- Editing Columns 217
- Editing Paragraph Styles 218
- Working with Frames 219
- Formatting a Frame 219
- Anchoring Frames 219
- Defining a Frame Wrap 219
- Style for this purpose 221
- Using Automatic Hyphenation 224
- Letters With Envelopes 225
- Get a POSTNET font 229
- Importing into Calc 237
- Exporting from Calc 238
- The Calc Window 239
- Inserting Sheets 241
- Renaming Sheets 241
- =CONVERT( 245
- Calculating With formulae 251
- Handling Multiple Sheets 254
- Formatting a Spreadsheet 257
- Layout of Spreadsheets 259
- Addressing Cells 261
- (') 264
- Using References in formulae 266
- ='file:///C:/ 267
- Using Charts 269
- Database Functions in Calc 274
- Evaluating Data With Calc 283
- Consolidating Data 287
- Applying Goal Seek 289
- Examples 290
- Profit=Quantity * (Selling 291
- Using Scenarios 293
- Validity of Cell Contents 295
- Sample macro: 297
- Page 1 Page 3 299
- Page 2 Page 4 299
- AutoFill 304
- Linking Sheet Information 310
- 7. Click Next 316
- Outline view 320
- In-Slide Effects 321
- Editing Presentations 322
- Using Outline View 324
- NIX-based systems, use 328
- <instdir> 330
- Creating a Business Report 331
- Overview 332
- Introduction 332
- Creating a Slide Show 334
- Working with Connectors 336
- Editing Glue Points 338
- OpenOffice.org Draw Functions 343
- Drawing Curves 353
- Working With Objects 360
- Grouping Objects 362
- Entering Groups 362
- Exiting Groups 362
- Shapes - Merge 365
- Shapes - Subtract 365
- Applying Text to Bitmaps 366
- Working With colours 369
- 3D Globe 377
- 3D Effects: Favourites 379
- 3D Effects: Geometry 380
- 3D Effects: Shading 380
- 3D Effects: Illumination 381
- First Step: 382
- Second Step: 383
- Third Step: 384
- Fourth Step: 386
- Fifth Step: 387
- Using a Grid 389
- Add some more details 392
- Complete the drawing 394
- Using Snap Lines 395
- Creating a database file 398
- Creating a table 399
- Creating a related table 400
- Creating a data entry form 401
- Making data entry easier 402
- Viewing Data 406
- Creating a report 409
- Open the Data Sources window 410
- Refreshing the form 411
- Registering a Data Source 412
- Address Books 413
- Form Design 416
- Available controls 417
- Customizing controls 418
- Associating data with a field 420
- How to use the form 421
- Standard toolbar 422
- Operators 423
- Commands 424
- Further Information 432
- Inserting an object as a copy 433
- Inserting an object as a link 434
- Revision Marking Function 441
- Version Management 444
- Turning on protection 445
- Turning off protection 445
- How to get a Certificate? 448
- Self-signed certificates 449
- Moving Tabs on the Ruler 451
- Deleting Tabs 451
- Changing the Defaults 451
- Changing the colour of Text 452
- More on Templates 453
- Accessing the Sample Macros 455
- The Sample Macros 457
- Formula Entry 458
- Special Formating 461
- − 1 23 4 462
- −1 23 4 462
- Special Characters 463
- Special Operators 464
- Vectors and Matrices 465
- Formatting 466
- 5^(1+3+3^2) 467
- Step-by-Step Procedure 469
- Control 472
- 6. Adf fix 473
- Chapter 13: Xml Enhancements 480
- Creating a new Docbook Filter 485
- Common.xcu 487
- C:\<some 487
- <release>\user\basic 489
- Time for the second test 494
- Time for the third test 495
- They are a guide only 498
Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x
(548 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.093 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales