#Microsoft access 2013 sample database update#

Note: You cannot use a query to update or delete records in a web database or web app.ġ. Display or print data by using a report.Īll of these items - tables, queries, forms, and reports - are database objects. When you update the data, it's automatically updated everywhere it appears.Ĥ. Store data once in one table, but view it from multiple locations. Reports to analyze or print data in a specific layout.ġ. Queries to find and retrieve just the data that you want.įorms to view, add, and update data in tables. Within an Access database file, you can use: You can use Access to manage all of your information in one file.

As a result, when you update a supplier's phone number, it is automatically updated wherever you use it in the database. In a well-designed Access database, the phone number is stored just once, so you only have to update that information in one place. If a supplier's phone number changes, you might have to update that information in all three places. If your database isn't stored on a computer, or only parts of it are, you may be tracking information from a variety of sources that you must coordinate and organize.įor example, suppose the phone numbers of your suppliers are stored in various locations: in a card file containing supplier phone numbers, in product information files in a file cabinet, and in a spreadsheet containing order information. See details about the objects in a databaseĪ database is a collection of information that is related to a particular subject or purpose, such as tracking customer orders or maintaining a music collection. Some of it does not apply to Access web databases and Access web apps. Note: This article is about traditional Access databases that consist of a file or set of files that contains all the data and application features, such as data entry forms.

Microsoft access 2013 sample database