Customer information that once existed in a mailing list now resides in the Customers table.Ģ. To bring the data from multiple tables together in a query, form, or report, you define relationships between the tables.ġ. Types of information might include customer information, products, and order details. To store your data, you create one table for each type of information that you track. In most cases, it does not matter whether a table is a linked table or actually stored in the database. For example, you may have one Access database that contains nothing but tables, and another Access database that contains links to those tables, as well as queries, forms, and reports that are based on the linked tables. Note: Some Access databases contain links to tables that are stored in other databases. 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. This article also explains how, when, and why you use each tool. Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article provides a basic overview of the structure of an Access database. I have tried using "Save As" under the "Save And Publish menu to store the database in an older format, but that does not solve the problem.Becoming familiar with the tables, forms, queries, and other objects in an Access database can make it easier to perform a wide variety of tasks, such as entering data into a form, adding or removing tables, finding and replacing data, and running queries. When I save the new database with an "accdb" extension I get the message saying it is invalid - if I leave off the extension or use "mdb" I get a message saying the file cannot be found. I understand that the default Access file type has changed from "mdb" to "accdb". Set db = OpenDatabase(Name:="C:\Work Matters\Databases\Lawyer.mdb") Var1 = "SELECT * FROM Lawyer WHERE = Wayne Cusack" & Chr(34) & var1 & Chr(34) & "ORDER BY Ordernumber " The old templates connected to an "mdb" database using code like this: I get error messages - either the database cannot be found or the file format is invalid. Now, using Word 2010 and Access 2010, I cannot open the database to draw out the data. In the past I have created document templates that drew data from an MS Access database.