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 database 2013