{"id":1939,"date":"2013-01-08T10:18:51","date_gmt":"2013-01-08T10:18:51","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=1939"},"modified":"2024-04-12T14:32:00","modified_gmt":"2024-04-12T09:02:00","slug":"data-entry-and-record-manipulating","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/","title":{"rendered":"Data Entry and record manipulating"},"content":{"rendered":"<p><a class=\"vsc\" href=\"http:\/\/www.vskills.in\/certification\/Certified E-Governance Professional \"><span class=\"vsc-cn\" style=\"text-align: center;\"><span style=\"color: red;\">Certify and Increase Opportunity.<\/span><br \/>\n<span style=\"color: green;\">Be <\/span><br \/>\nGovt. Certified E-Governance Professional<br \/>\n<\/span><\/a><\/p>\n<div><img decoding=\"async\" title=\"Data in a table and the same data in a form\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif\" alt=\"Data in a table and the same data in a form\" border=\"0\" \/><\/div>\n<div><img decoding=\"async\" title=\"Callout 1\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/887\/503\/ZA001093948.gif\" alt=\"Callout 1\" border=\"0\" \/>\u00a0The structure of data in a table\u2026<\/div>\n<div><img decoding=\"async\" title=\"Callout 2\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/010\/917\/ZA001093949.gif\" alt=\"Callout 2\" border=\"0\" \/>\u00a0\u2026is reflected in the structure of a form.<\/div>\n<hr \/>\n<p>Think of forms as windows through which people see and reach your database. Forms follow function. That is, their design fits the situation in which people will enter or view data. An effective form speeds the use of your database, because people don&#8217;t have to search for what they need. A visually attractive form makes working with the database more pleasant and more efficient.<\/p>\n<div><img decoding=\"async\" title=\"Ways to create a form\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/810\/187\/ZA006049796.gif\" alt=\"Ways to create a form\" border=\"0\" \/><\/div>\n<div>Access offers several methods of creating a new form.<\/div>\n<div><img decoding=\"async\" title=\"Callout 1\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/887\/503\/ZA001093948.gif\" alt=\"Callout 1\" border=\"0\" \/>\u00a0You choose a method.<\/div>\n<div><img decoding=\"async\" title=\"Callout 2\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/010\/917\/ZA001093949.gif\" alt=\"Callout 2\" border=\"0\" \/>\u00a0You choose a data source.<\/div>\n<hr \/>\n<p>Access gives you three main ways to create a form: with the Form Wizard, with an AutoForm, or in Design view. Once you understand all three ways, you can choose the method or methods that will be best for your purposes.<\/p>\n<div><img decoding=\"async\" title=\"Form Wizard with options for data to use in form\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/259\/410\/ZA006054790.gif\" alt=\"Form Wizard with options for data to use in form\" border=\"0\" \/><\/div>\n<div>The Form Wizard asks you questions, and your answers determine the form it creates.<\/div>\n<hr \/>\n<p>The Form Wizard is best when you want to be guided step by step through the process of creating a form. The Form Wizard asks you questions and creates a form based on your answers.<\/p>\n<p>You will need to tell the wizard:<\/p>\n<ul type=\"disc\">\n<li>Which table or query the form data comes from.<\/li>\n<li>Which fields to use on the form.<\/li>\n<li>Which form layout to apply.<\/li>\n<li>Which visual style to apply.<\/li>\n<\/ul>\n<p>To start working with the Form Wizard, you would click\u00a0<b>Forms<\/b>\u00a0under\u00a0<b>Objects<\/b>\u00a0in the Database window, and then click\u00a0<b>New<\/b>\u00a0on the<b>Database<\/b>\u00a0toolbar. In the\u00a0<b>New Form<\/b>\u00a0dialog box, you would click\u00a0<b>Form Wizard<\/b>\u00a0to select this method.<\/p>\n<div><img decoding=\"async\" title=\"A columnar AutoForm and a tabular AutoForm\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/112\/713\/ZA006054814.gif\" alt=\"A columnar AutoForm and a tabular AutoForm\" border=\"0\" \/><\/div>\n<div><b>Fig. 1<\/b>\u00a0A columnar AutoForm<\/div>\n<div><b>Fig. 2<\/b>\u00a0A tabular AutoForm<\/div>\n<hr \/>\n<p>AutoForms are best when you don&#8217;t need to make many choices. If your new form will contain all the fields from a table or query, and you don&#8217;t need much control over the form&#8217;s appearance, an AutoForm is simply perfect.<\/p>\n<p>Unlike the Form Wizard, an AutoForm doesn&#8217;t ask you questions or offer you choices. Creating an AutoForm is a two-step process. Pick a type of AutoForm, pick a table or query, and Access does the rest.<\/p>\n<p>There are several types of AutoForm, but the two shown here are all you need to know about now.\u00a0<b>AutoForm: Columnar<\/b>\u00a0shows records one at a time, with each field on a separate labeled line.\u00a0<b>AutoForm: Tabular<\/b>\u00a0shows all records at once, with each field shown for each record, and field labels at the top of the form.<\/p>\n<p>To start working with an AutoForm, you would click\u00a0<b>Forms<\/b>\u00a0under\u00a0<b>Objects<\/b>\u00a0in the Database window, and then click\u00a0<b>New<\/b>\u00a0on the<b>Database<\/b>\u00a0toolbar. In the\u00a0<b>New Form<\/b>\u00a0dialog box, you would click one of the AutoForm options to select it.<\/p>\n<div><img decoding=\"async\" title=\"Toolbox and form in Design view\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/057\/952\/ZA006054806.gif\" alt=\"Toolbox and form in Design view\" border=\"0\" \/><\/div>\n<div><img decoding=\"async\" title=\"Callout 1\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/887\/503\/ZA001093948.gif\" alt=\"Callout 1\" border=\"0\" \/>\u00a0The toolbox in Design view contains controls, such as text boxes and labels, to add to your form.<\/div>\n<div><img decoding=\"async\" title=\"Callout 2\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/010\/917\/ZA001093949.gif\" alt=\"Callout 2\" border=\"0\" \/>\u00a0The Design view gridlines and dots organize the area where you insert and arrange controls.<\/div>\n<hr \/>\n<p>Design view is the best way to create a form when you want full control and complete freedom. In Design view, everything is up to you.<\/p>\n<p>The challenge is that you&#8217;re on your own, without the prearrangements of the Form Wizard or an AutoForm. However, you can also create a form by either of those methods, and then change its details in Design view.<\/p>\n<p>To work with a form in Design view, you choose items from the toolbox. These items, such as check boxes, pictures, and labels, are called\u00a0<b>controls<\/b>. You can set their properties and format them to look as you want on the form. For details, see the course, &#8220;Take the controls.&#8221;<\/p>\n<p>In Design view, you can move the controls around, like rearranging pictures on a wall. For example, you may want to group together the text boxes for address, city, state, and ZIP code\u2014but on two lines, or three, or four? You can easily try them all and pick the best.<\/p>\n<p>To see the form as it will appear when someone works with it, you can open it in Form view, and keep switching between Form and Design views until the form suits you completely.<\/p>\n<p>To start working in Design view, you would click\u00a0<b>Forms<\/b>\u00a0under\u00a0<b>Objects<\/b>\u00a0in the Database window, and then click\u00a0<b>New<\/b>\u00a0on the\u00a0<b>Database<\/b>toolbar. In the\u00a0<b>New Form<\/b>\u00a0dialog box, you would click\u00a0<b>Design View<\/b>\u00a0to select this method.<\/p>\n<p>Reports<\/p>\n<div><img decoding=\"async\" title=\"Reports summarize and present data\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/489\/200\/ZA001025745.gif\" alt=\"Reports summarize and present data\" border=\"0\" \/><\/div>\n<div><\/div>\n<p>&nbsp;<\/p>\n<div>Reports can make your data more useful.<\/div>\n<hr \/>\n<p>Reports provide many ways to organize, categorize, and even summarize your data. They help you show your data to best effect, and they offer forms of presenting data that may be new to you.<\/p>\n<p>As with other parts of Access, the first question you need to consider is, what do you want the report to do?<\/p>\n<p>Queries<\/p>\n<div><img decoding=\"async\" title=\"Queries can make your data more useful\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/189\/417\/ZA001023692.gif\" alt=\"Queries can make your data more useful\" border=\"0\" \/><\/div>\n<div>Queries can select items from your data and make it more useful.<\/div>\n<hr \/>\n<p>Queries let you pull just the data you need out of a database so you can perform tasks and get questions answered.<\/p>\n<p>With queries, you can retrieve, combine, reuse, and analyze your data. You can use queries to retrieve data from multiple tables, or as a source for forms and reports.<\/p>\n<p>In this course, we&#8217;ll stick to the basics of choosing and retrieving data with\u00a0<b>select queries<\/b>, which will give you a good foundation for working with other, more complex types of queries.<\/p>\n<p>Click\u00a0<b>Next<\/b>\u00a0to continue reading this lesson on your own.<\/p>\n<div><img decoding=\"async\" title=\"Examples of queries\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/453\/776\/ZA001022277.gif\" alt=\"Examples of queries\" border=\"0\" \/><\/div>\n<div><\/div>\n<p>&nbsp;<\/p>\n<div>Queries retrieve the latest information from your database.<\/div>\n<hr \/>\n<div>\n<p>Whenever you run a query, it checks for the latest data in your database. The data returned by a query is called a\u00a0<b>recordset<\/b>.<\/p>\n<p>You can browse through the recordset, select from it, sort it, and print it. Typically, the recordset you produce with a query isn&#8217;t saved, but the query structure and criteria you used to get the results are saved. You can check for the most recent data again at any time, simply by rerunning the query. Queries have titles, so you can easily find them and use them again.<\/p>\n<p>Because Access saves query structures and criteria, if you frequently need a certain set of information, such as sales during a specific year, you can avoid hunting down that data each time, just by rerunning the query. Chances are, you have better things to do with your time.<\/p>\n<p>You can create and save multiple queries to retrieve data in different ways. Queries are easy to revise as well, so if you don&#8217;t set them up right the first time, or if your needs change, you can easily change your criteria. You can even use one or more queries as the source of data for another query, increasing your efficiency as you select more and more precisely to get just the data you want.<\/p>\n<table>\n<tbody>\n<tr>\n<th><b>Query type<\/b><\/th>\n<th><b>Description<\/b><\/th>\n<\/tr>\n<tr>\n<td><b>Select query<\/b><\/td>\n<td>Retrieves data from one or more tables and displays the recordset in a datasheet. This is the most common type of query.<\/td>\n<\/tr>\n<tr>\n<td><b>Parameter query<\/b><\/td>\n<td>Prompts the user to enter values that define the query, such as a specified region for sales results, or a specified price range for houses.<\/td>\n<\/tr>\n<tr>\n<td><b>Cross-tab query<\/b><\/td>\n<td>Arranges a recordset to make it more easily visible, using both row headings and column headings.<\/td>\n<\/tr>\n<tr>\n<td><b>Action query<\/b><\/td>\n<td>Creates a new table or changes an existing table.<\/td>\n<\/tr>\n<tr>\n<td><b>SQL query<\/b><\/td>\n<td>An advanced query that is created by using an SQL statement.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<hr \/>\n<p>Access provides many different types of queries to meet many different needs for data.<\/p>\n<p>We&#8217;ll briefly describe most of the query types, although in this course we&#8217;ll focus on the most commonly used query type, the select query.<\/p>\n<p>A\u00a0<b>select query<\/b>\u00a0retrieves data from one or more tables and displays the recordset in a datasheet. You can also use a select query to group data, and to calculate sums, counts, averages, and other types of totals, although we won&#8217;t cover calculations in this course.<\/p>\n<p>A\u00a0<b>parameter query<\/b>\u00a0displays a dialog box when it runs, prompting the user to enter information to use as criteria for the query. You can design a parameter query to prompt for more than one piece of information; for example, you can design it to prompt for two dates. Access will then retrieve all data with values between those two dates.<\/p>\n<p>A\u00a0<b>cross-tab query<\/b>\u00a0arranges a recordset to make it more easily visible, using both row headings and column headings. Data can be seen in terms of two categories at once.<\/p>\n<p>An\u00a0<b>action query<\/b>\u00a0creates a new table or changes an existing table by adding data to it, deleting data from it, or updating it. Because an action query is so powerful, actually changing table data, you should consider backing up your data before running an action query.<\/p>\n<p>An\u00a0<b>SQL query<\/b>\u00a0is created by using a statement in Structured Query Language (SQL). SQL is an advanced way to query, update, and manage relational databases. Access can create the SQL statement for you when you create this type of query, or you can create your own SQL statement.<\/p>\n<div><img decoding=\"async\" title=\"You can create queries with a wizard or in Design view\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/338\/135\/ZA001023693.gif\" alt=\"You can create queries with a wizard or in Design view\" border=\"0\" \/><\/div>\n<div>You can create queries in Design view or by using a wizard.<\/div>\n<hr \/>\n<p>As with forms and reports, Access provides two basic ways to create queries: by using a wizard, and in Design view.<\/p>\n<p>The\u00a0<b>wizard<\/b>, also known as the Simple Query Wizard, gives you a head start in setting up your query&#8217;s structure by making some arrangements for you.<\/p>\n<p>In\u00a0<b>Design view<\/b>\u00a0you have total control when creating a query. You drag the fields you want to a grid, and then you enter the criteria for selecting the data to be retrieved.<\/p>\n<p>You can also create your query using the wizard and then refine the query in Design view to get just what you need.<\/p>\n<div><img decoding=\"async\" title=\"The wizard guides you through creating a query\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/725\/474\/ZA001023459.gif\" alt=\"The wizard guides you through creating a query\" border=\"0\" \/><\/div>\n<div><\/div>\n<p>&nbsp;<\/p>\n<div>A wizard guides you through creating a query.<\/div>\n<hr \/>\n<p>The Simple Query Wizard begins by prompting you to select the database fields you need. You can select fields from tables. You can also select fields from preexisting queries.<\/p>\n<p>For example, if you were retrieving a list of people from an Employees table, the wizard would prompt you to choose fields to include in your query, such as each employee&#8217;s name, manager, and extension.<\/p>\n<p>The wizard also enables you to group and summarize data, which isn&#8217;t necessary for simple queries but can help you analyze more complex recordsets.<\/p>\n<p>After you create your query, the wizard can run it, or the wizard can take you to Design view. In Design view you can specify criteria and refine your query. For example, you could specify in Design view that the retrieved list show only employees in the Marketing Department and that it be sorted by the employees&#8217; last names.<\/p>\n<div><img decoding=\"async\" title=\"You can create and modify queries in Design view\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/033\/145\/ZA001023969.gif\" alt=\"You can create and modify queries in Design view\" border=\"0\" \/><\/div>\n<div>You can create and modify queries in Design view.<\/div>\n<div><img decoding=\"async\" title=\"Callout 1\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/887\/503\/ZA001093948.gif\" alt=\"Callout 1\" border=\"0\" \/>\u00a0Design view shows the tables or the existing queries that you can base your query on&#8230;<\/div>\n<div><img decoding=\"async\" title=\"Callout 2\" src=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/010\/917\/ZA001093949.gif\" alt=\"Callout 2\" border=\"0\" \/>\u00a0&#8230;and a grid where you can add criteria and modify your query.<\/div>\n<hr \/>\n<p>In Design view, you begin by choosing the tables or existing queries that contain the fields you want to use.<\/p>\n<p>Then, you select and drag those fields to a grid. The fields can come from just one table, or from multiple tables. In this course, we focus on working with one table.<\/p>\n<p>After you have added your fields, you can specify criteria and other settings, such as whether to sort the results.<\/p>\n<p><b>Note<\/b>\u00a0\u00a0\u00a0 You can change the fields used in a query after you have made your original selection. For details on making changes, see the Quick Reference Card.<\/p>\n<p>Whether you create your query with the wizard or in Design view, testing it in Design view lets you easily tweak your query if you don&#8217;t get the results you want.<\/p>\n<div class=\"apply\">\n<h3>Apply for E-Governance Certification Now!!<\/h3>\n<p><a href=\"http:\/\/www.vskills.in\/certification\/Certified-E-Governance-Professional\">http:\/\/www.vskills.in\/certification\/Certified-E-Governance-Professional<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Certify and Increase Opportunity. Be Govt. Certified E-Governance Professional \u00a0The structure of data in a table\u2026 \u00a0\u2026is reflected in the structure of a form. Think of forms as windows through which people see and reach your database. Forms follow function. That is, their design fits the situation in which people will enter or view data&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[329],"tags":[618,328,6811],"class_list":["post-1939","page","type-page","status-publish","hentry","category-e-governance","tag-data-entry-and-record-manipulating","tag-e-governance-certification","tag-e-governance-professional"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Entry and record manipulating<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Entry and record manipulating\" \/>\n<meta property=\"og:description\" content=\"Certify and Increase Opportunity. Be Govt. Certified E-Governance Professional \u00a0The structure of data in a table\u2026 \u00a0\u2026is reflected in the structure of a form. Think of forms as windows through which people see and reach your database. Forms follow function. That is, their design fits the situation in which people will enter or view data....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T09:02:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/\",\"name\":\"Data Entry and record manipulating\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif\",\"datePublished\":\"2013-01-08T10:18:51+00:00\",\"dateModified\":\"2024-04-12T09:02:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#primaryimage\",\"url\":\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif\",\"contentUrl\":\"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Entry and record manipulating\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Entry and record manipulating","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/","og_locale":"en_US","og_type":"article","og_title":"Data Entry and record manipulating","og_description":"Certify and Increase Opportunity. Be Govt. Certified E-Governance Professional \u00a0The structure of data in a table\u2026 \u00a0\u2026is reflected in the structure of a form. Think of forms as windows through which people see and reach your database. Forms follow function. That is, their design fits the situation in which people will enter or view data....","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:02:00+00:00","og_image":[{"url":"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/","name":"Data Entry and record manipulating","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#primaryimage"},"thumbnailUrl":"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif","datePublished":"2013-01-08T10:18:51+00:00","dateModified":"2024-04-12T09:02:00+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#primaryimage","url":"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif","contentUrl":"http:\/\/officeimg.vo.msecnd.net\/en-us\/files\/421\/963\/ZA006049792.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/data-entry-and-record-manipulating\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Data Entry and record manipulating"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/1939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=1939"}],"version-history":[{"count":5,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/1939\/revisions"}],"predecessor-version":[{"id":66031,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/1939\/revisions\/66031"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=1939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=1939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=1939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}