__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html> <html lang="es" dir="ltr"> <head> <base href="../../../../"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Trabajo con consultas</title> <link rel="shortcut icon" href="media/navigation/favicon.ico"> <link type="text/css" href="normalize.css" rel="Stylesheet"> <link type="text/css" href="prism.css" rel="Stylesheet"> <link type="text/css" href="default.css" rel="Stylesheet"> <script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1"> </head> <body> <header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules"> <button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav> </div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks"> <input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores de todos los módulos" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div> </div></div> <div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication"> <noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript> <a id="bm_id840784"></a><meta itemprop="keywords" content="bases de datos,crear consultas"> <meta itemprop="keywords" content="filtrar,datos en bases de datos"> <meta itemprop="keywords" content="consultas,definir"> <meta itemprop="keywords" content="definir,consultas"> <meta itemprop="keywords" content="asistentes,consultas de bases de datos"> <meta itemprop="keywords" content="Asistente para consultas"> <h1 id="par_idN105F9" dir="auto"> <a id="data_queries"></a>Trabajo con consultas</h1> <p id="par_idN10617" class="paragraph" dir="auto">Si va a acceder a menudo sólo a un subconjunto de los datos que se puede definir con precisión mediante una condición de filtro, puede establecer una consulta. Básicamente se trata de un nombre para la nueva vista en los datos filtrados. Para ver los datos en el diseño de tabla que ha definido, abra la consulta.</p> <h2 id="par_idN1061A" dir="auto">Crear una consulta con el Asistente para consultas</h2> <p id="par_idN1061E" class="paragraph" dir="auto">In LibreOffice you can create a new query using the <a target="_top" href="es/text/sdatabase/querywizard00.html">Query Wizard</a>:</p> <ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto"> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_idN10632" class="paragraph" dir="auto">Abra el archivo de base de datos en el que desee crear la consulta.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_idN10636" class="paragraph" dir="auto">En el panel izquierdo de la ventana de base de datos, pulse en el icono <span class="emph">Consultas</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_idN1063E" class="paragraph" dir="auto">Pulse en <span class="emph">Usar el asistente para crear una consulta</span>.</p> </li> </ol> <h2 id="par_idN10645" dir="auto">Crear una consulta con la vista Diseño</h2> <ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto"> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_idN1064C" class="paragraph" dir="auto">Abra el archivo de base de datos en el que desee crear la consulta.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_idN10650" class="paragraph" dir="auto">En el panel izquierdo de la ventana de base de datos, pulse en el icono <span class="emph">Consultas</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_idN10658" class="paragraph" dir="auto">Pulse en <span class="emph">Crear una consulta en vista de diseño</span>.</p> </li> </ol> <p id="par_idN1065F" class="paragraph" dir="auto">You see the <a target="_top" href="es/text/sdatabase/02010100.html">Query Design window</a>.</p> <a id="relatedtopics"></a><div class="relatedtopics"> <p class="related" itemprop="mentions" dir="auto"><a id="related"></a><span class="emph">Temas relacionados</span></p> <div class="relatedbody" itemprop="mentions"> <p id="par_idN1067B" class="paragraph" dir="auto"> <a target="_top" href="es/text/sdatabase/main.html">Utilizar bases de datos en LibreOffice Base</a> </p> <p id="par_idN10683" class="paragraph" dir="auto"> <a target="_top" href="es/text/shared/guide/database_main.html">Información general sobre las bases de datos</a> </p> </div> </div> </div> <div id="DonationFrame"></div> <footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2> <div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;"> <img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;"> </div> <div id="DEBUG" class="debug"> <h3 class="bug">Help content debug info:</h3> <p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/shared/guide/data_queries.xhp" target="_blank">/text/shared/guide/data_queries.xhp</a></p> <p dir="auto">Title is: Trabajo con consultas</p> <p id="bm_module" dir="auto"></p> <p id="bm_system" dir="auto"></p> <p id="bm_HID" dir="auto"></p> </div></footer> </body> </html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| aaa_start.html | File | 7.35 KB | 0644 |
|
| accessibility.html | File | 9.35 KB | 0644 |
|
| active_help_on_off.html | File | 6.87 KB | 0644 |
|
| activex.html | File | 9.33 KB | 0644 |
|
| assistive.html | File | 8.15 KB | 0644 |
|
| auto_redact.html | File | 9.74 KB | 0644 |
|
| autocorr_url.html | File | 10.32 KB | 0644 |
|
| autohide.html | File | 8.1 KB | 0644 |
|
| background.html | File | 6.44 KB | 0644 |
|
| border_paragraph.html | File | 9.28 KB | 0644 |
|
| border_table.html | File | 9.17 KB | 0644 |
|
| breaking_lines.html | File | 8.14 KB | 0644 |
|
| builtin_help.html | File | 12.61 KB | 0644 |
|
| change_title.html | File | 5.56 KB | 0644 |
|
| chart_axis.html | File | 6.15 KB | 0644 |
|
| chart_barformat.html | File | 6.35 KB | 0644 |
|
| chart_insert.html | File | 10.73 KB | 0644 |
|
| chart_legend.html | File | 6.28 KB | 0644 |
|
| chart_title.html | File | 6.91 KB | 0644 |
|
| classification.html | File | 16.19 KB | 0644 |
|
| cmis-remote-files-setup.html | File | 22.95 KB | 0644 |
|
| cmis-remote-files.html | File | 14.83 KB | 0644 |
|
| collab.html | File | 15.43 KB | 0644 |
|
| configure_overview.html | File | 5.56 KB | 0644 |
|
| contextmenu.html | File | 5.53 KB | 0644 |
|
| convertfilters.html | File | 115.79 KB | 0644 |
|
| copy_drawfunctions.html | File | 7.29 KB | 0644 |
|
| copytable2application.html | File | 7.31 KB | 0644 |
|
| copytext2application.html | File | 8.95 KB | 0644 |
|
| csv_params.html | File | 52.56 KB | 0644 |
|
| ctl.html | File | 9.93 KB | 0644 |
|
| data_addressbook.html | File | 9.53 KB | 0644 |
|
| data_dbase2office.html | File | 8.96 KB | 0644 |
|
| data_enter_sql.html | File | 7.98 KB | 0644 |
|
| data_forms.html | File | 7.65 KB | 0644 |
|
| data_im_export.html | File | 11.67 KB | 0644 |
|
| data_new.html | File | 5.43 KB | 0644 |
|
| data_queries.html | File | 7.17 KB | 0644 |
|
| data_register.html | File | 7.13 KB | 0644 |
|
| data_report.html | File | 8.25 KB | 0644 |
|
| data_reports.html | File | 11.21 KB | 0644 |
|
| data_search.html | File | 5.63 KB | 0644 |
|
| data_search2.html | File | 10.34 KB | 0644 |
|
| data_tabledefine.html | File | 8.53 KB | 0644 |
|
| data_tables.html | File | 8.31 KB | 0644 |
|
| data_view.html | File | 5.85 KB | 0644 |
|
| database_main.html | File | 7.69 KB | 0644 |
|
| dev_tools.html | File | 16.93 KB | 0644 |
|
| digital_signatures.html | File | 14.99 KB | 0644 |
|
| digitalsign_receive.html | File | 8.96 KB | 0644 |
|
| digitalsign_send.html | File | 14.33 KB | 0644 |
|
| doc_autosave.html | File | 10.32 KB | 0644 |
|
| doc_open.html | File | 8.86 KB | 0644 |
|
| doc_save.html | File | 10.47 KB | 0644 |
|
| dragdrop.html | File | 9.65 KB | 0644 |
|
| dragdrop_beamer.html | File | 9.89 KB | 0644 |
|
| dragdrop_gallery.html | File | 7.66 KB | 0644 |
|
| dragdrop_graphic.html | File | 8.06 KB | 0644 |
|
| dragdrop_table.html | File | 7.94 KB | 0644 |
|
| edit_symbolbar.html | File | 7.36 KB | 0644 |
|
| email.html | File | 6.92 KB | 0644 |
|
| error_report.html | File | 7.26 KB | 0644 |
|
| export_ms.html | File | 6.87 KB | 0644 |
|
| fax.html | File | 8.58 KB | 0644 |
|
| filternavigator.html | File | 7.3 KB | 0644 |
|
| find_attributes.html | File | 9.14 KB | 0644 |
|
| flat_icons.html | File | 5.75 KB | 0644 |
|
| floating_toolbar.html | File | 11.42 KB | 0644 |
|
| fontwork.html | File | 11.92 KB | 0644 |
|
| formfields.html | File | 9.28 KB | 0644 |
|
| gallery_insert.html | File | 11.82 KB | 0644 |
|
| graphic_export_params.html | File | 17.53 KB | 0644 |
|
| groups.html | File | 10.49 KB | 0644 |
|
| hyperlink_edit.html | File | 9.48 KB | 0644 |
|
| hyperlink_insert.html | File | 7.17 KB | 0644 |
|
| hyperlink_rel_abs.html | File | 10.62 KB | 0644 |
|
| imagemap.html | File | 13.09 KB | 0644 |
|
| import_ms.html | File | 10.63 KB | 0644 |
|
| insert_bitmap.html | File | 15 KB | 0644 |
|
| insert_graphic_drawit.html | File | 13.7 KB | 0644 |
|
| insert_specialchar.html | File | 9.06 KB | 0644 |
|
| integratinguno.html | File | 6.51 KB | 0644 |
|
| keyboard.html | File | 51.55 KB | 0644 |
|
| labels.html | File | 8.93 KB | 0644 |
|
| labels_database.html | File | 8.23 KB | 0644 |
|
| language_select.html | File | 21.74 KB | 0644 |
|
| line_intext.html | File | 11.89 KB | 0644 |
|
| lineend_define.html | File | 6.32 KB | 0644 |
|
| linestyle_define.html | File | 7.01 KB | 0644 |
|
| linestyles.html | File | 6.43 KB | 0644 |
|
| lotusdbasediff.html | File | 31.13 KB | 0644 |
|
| macro_recording.html | File | 10.49 KB | 0644 |
|
| main.html | File | 25.2 KB | 0644 |
|
| manage_templates.html | File | 16.02 KB | 0644 |
|
| measurement_units.html | File | 7.09 KB | 0644 |
|
| microsoft_terms.html | File | 11.14 KB | 0644 |
|
| ms_doctypes.html | File | 6.26 KB | 0644 |
|
| ms_import_export_limitations.html | File | 15.09 KB | 0644 |
|
| ms_user.html | File | 14.94 KB | 0644 |
|
| navigator.html | File | 6.71 KB | 0644 |
|
| navigator_setcursor.html | File | 7.08 KB | 0644 |
|
| navpane_on.html | File | 5.24 KB | 0644 |
|
| numbering_stop.html | File | 10.09 KB | 0644 |
|
| openpgp.html | File | 15.36 KB | 0644 |
|
| pageformat_max.html | File | 6.76 KB | 0644 |
|
| paintbrush.html | File | 14.25 KB | 0644 |
|
| palette_files.html | File | 11.06 KB | 0644 |
|
| pasting.html | File | 8.59 KB | 0644 |
|
| pdf_params.html | File | 67.4 KB | 0644 |
|
| print_blackwhite.html | File | 12.56 KB | 0644 |
|
| print_faster.html | File | 7.44 KB | 0644 |
|
| protection.html | File | 12.83 KB | 0644 |
|
| redaction.html | File | 11.34 KB | 0644 |
|
| redlining.html | File | 7.45 KB | 0644 |
|
| redlining_accept.html | File | 8.25 KB | 0644 |
|
| redlining_doccompare.html | File | 7.99 KB | 0644 |
|
| redlining_docmerge.html | File | 7.29 KB | 0644 |
|
| redlining_enter.html | File | 9.78 KB | 0644 |
|
| redlining_navigation.html | File | 6.77 KB | 0644 |
|
| redlining_protect.html | File | 6.76 KB | 0644 |
|
| redlining_versions.html | File | 5.8 KB | 0644 |
|
| round_corner.html | File | 5.8 KB | 0644 |
|
| scripting.html | File | 21.23 KB | 0644 |
|
| space_hyphen.html | File | 8.69 KB | 0644 |
|
| spadmin.html | File | 8.97 KB | 0644 |
|
| standard_template.html | File | 15.1 KB | 0644 |
|
| start_parameters.html | File | 46.46 KB | 0644 |
|
| startcenter.html | File | 10.56 KB | 0644 |
|
| tabs.html | File | 14.58 KB | 0644 |
|
| template_manager.html | File | 31.01 KB | 0644 |
|
| text_color.html | File | 6.78 KB | 0644 |
|
| textmode_change.html | File | 7.04 KB | 0644 |
|
| undo_formatting.html | File | 9.17 KB | 0644 |
|
| usingthemes.html | File | 8.26 KB | 0644 |
|
| version_number.html | File | 5.15 KB | 0644 |
|
| viewing_file_properties.html | File | 6.81 KB | 0644 |
|
| workfolder.html | File | 7.05 KB | 0644 |
|
| xforms.html | File | 8.77 KB | 0644 |
|
| xsltfilter.html | File | 8.09 KB | 0644 |
|
| xsltfilter_create.html | File | 14.42 KB | 0644 |
|
| xsltfilter_distribute.html | File | 7.4 KB | 0644 |
|