Design view<\/figcaption><\/figure>\nIn the field Name<\/strong> column, we define field names.<\/p>\nIn the column Data type we<\/strong> specify the kind of values that we want in the cells of this array. It is necessary that the database table needs to have\u00a0in every cell of the column value of\u00a0the same type, eg. number, text or dates. It’s also important for subsequent linking tables or creating calculations.<\/p>\nIn the Description column can be optionally detailed description of the column that serves rather to understand the content of field for the user or for creating documentation of the database.<\/p>\n
Save the table<\/h1>\n
Object designs\u00a0should always be saved. The quickest way is to use a small floppy disk icon on the Quick Access Toolbar on, or in File> Save Object As. Table name may have a maximum of 64 characters and can not contain any special symbols. It’s good to get used appropriately naming objects and this procedure applied to the entire database. Example of names may be tbl_Orders or tblOrders etc.<\/p>\n
If you do not set\u00a0a column as unique so-called\u00a0primary key<\/strong> before saving, Access asks when saving, whether you want to set it. If not set, but the table contains a field with the type AutoNumber, it will place the key to it. If such does not, the Access itself creates column of the table in the first place and calls it ID. But one can not set the key, and when asked to do select the option that you want to create.<\/p>\nAfter saving the data in the table you can\u00a0switch\u00a0the view\u00a0by selecting Home> View > Datasheet and begin to fill the cell values.<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
In the created database it is good to start with tables because without them the database does not make sense. In previous article\u00a0you could read how to set up a new database. Now we look at the creation of tables, working again with version 2010. Access is not limited by number of rows in a […]<\/p>\n","protected":false},"author":1,"featured_media":2816,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[7],"tags":[51,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2813"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=2813"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2813\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2816"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Tabulka](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/05\/tab01.png\" "\\"\\"")
<\/a>