![]() ![]() QueryĪ query is what you will use to retrieve information from your database. This article is simply an overview of objects you'll use in Access and in some other databases as well. Any other information you have in the form, like title, date, page number, is stored in the design of the form. It's important for you to remember that a bound form stores or retrieves data from its record source. To create a link between a form and the record source, you use graphic objects called controls. A form doesn't have to contain all the fields of a table or query that it's based on. This record source is the fields in the tables and queries. Most of the forms you'll have are bound to one table or more than one table, as well as queries in your database. You can also use a form as a custom dialogue box that accepts your input, then carries out an action based on what you enter into the form. You can also use a form to open other forms and reports within your database. FormsĪ form is used either to display or enter data in Access 2016. Relational databases store records across multiple tables with linked data. The column is called the field, and the row is called the record. Remember, tables contain rows and columns. TablesĬreating good tables leads to good database design. We're going to talk about the database objects in Access 2016 in this article. A database contains objects that are used to store and display large, relational data. ![]() Database objects are components that save and query information. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |