microsoft webmatrix get data from database

For example, if it’s for multiple users, a well-designed form helps to make data entry accurate, fast, and efficient. It’s important to design your form with use in mind. Similar to paper forms, Access forms are objects through which you or other users can add, edit, or display the data stored in your Access desktop database. Action queries are not available in Access web apps.įorms are like display cases in stores-they make it easier to view or get to the database items you want. Each task has a specific type of action query. To retrieve data from a table or make calculations.Īdd, change, or delete data. There are many types of queries, but the two basic types are: Use queries to get answers to simple questions, perform calculations using data, combine data from different tables, and add, change, or delete data from a database. You use a query to pull that information from various tables and to assemble it for display in a form or report.Ī query can be a request for data results from your database, or it can be used to perform an action on the data, or it might be both. In a well-designed database, the data that you want to present through a form or report is usually located in multiple tables. If you aren’t already familiar with them, learn the basics of databases. Each column or field holds some type of information about that product, such as its name or price.

In the Products table, for instance, each row or record would hold information about one product. A field is a single item of information about that entity. A record contains all the specific information for a particular entity, such as a customer or an order. Each table stores information about a specific subject, so most databases include more than one table.Įach row in the table is called a record, and each column is called a field. TablesĪccess organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a spreadsheet. Access provides six database objects that, when combined, help you take full advantage of your data.

Microsoft webmatrix get data from database