Becoming acquainted with the tables, forms, queries, and other objects in an access database deserve to make it easier to perform a wide range of tasks, such together entering data right into a form, adding or remove tables, finding and replacing data, and also running queries.
You are watching: To organize your database objects use the
This post provides a an easy overview that the structure of an accessibility database. Accessibility provides numerous tools that you deserve to use to familiarize yourself with the framework of a particular database. This article additionally explains how, when, and also why you usage each tool.
Note: This post is about traditional accessibility databases that consist of a record or set of documents that has all the data and also application features, such as data entry forms. Few of it go not use to accessibility web databases and accessibility web apps.
In this article
A database is a repertoire of info that is concerned a particular subject or purpose, such together tracking client orders or maintaining a music collection. If her database isn"t save on computer on a computer, or only parts of it are, you might be tracking details from a selection of sources that you have to coordinate and organize.
For example, suppose the phone numbers of your service providers are save in miscellaneous locations: in a card record containing supplier phone numbers, in product information files in a file cabinet, and also in a spreadsheet containing order information. If a supplier"s call number changes, you can have to upgrade that details in all 3 places. In a well-designed access database, the phone number is stored just once, so you only have to update that information in one place. Together a result, when you upgrade a supplier"s phone call number, the is immediately updated wherever you use it in the database.
Access database files
You have the right to use access to manage every one of your details in one file. Within an access database file, you have the right to use:
Tables to keep your data.
Queries come find and retrieve just the data the you want.
Forms to view, add, and update data in tables.
Reports to analysis or print data in a details layout.
1. Keep data when in one table, but view that from many locations. When you upgrade the data, it"s automatically updated all over it appears.
2. Retrieve data by using a query.
3. View or get in data by making use of a form.
4. Screen or publish data by utilizing a report.
All of these items — tables, queries, forms, and reports — room database objects.
Note: Some accessibility databases contain web links to tables that room stored in various other databases. Because that example, you may have one accessibility database that has nothing yet tables, and another access database that has links come those tables, as well as queries, forms, and also reports that are based on the connected tables. In many cases, that does not matter whether a table is a attached table or actually stored in the database.
Tables and also relationships
To keep your data, you develop one table for each form of info that girlfriend track. Varieties of information might include customer information, products, and also order details. To carry the data from multiple tables together in a query, form, or report, you specify relationships between the tables.
Note: In a web database or internet app, friend cannot use the relationships object tab to develop relationships. You can use lookup fields to create relationships in a web database or internet app.
1. Customer information that when existed in a mailing list now resides in the client table.
2. Order details that when existed in a spreadsheet now resides in the orders table.
3. A distinctive ID, such together a client ID, differentiate one document from one more within a table. By including one table"s distinctive ID ar to another table and also defining a relationship between the 2 fields, access can match related records from both tables so that you can carry them together in a form, report, or query.
A questions can aid you find and retrieve the data the meets conditions that you specify — including data from multiple tables. You can also use a query to upgrade or delete multiple records at the very same time and also to do predefined or tradition calculations on her data.
Note: You cannot use a questions to update or delete records in a net database or internet app.
1. The client table has information about customers.
2. The assignment table has information around customer orders.
3. This ask retrieves the stimulate ID and also Required date data from the order table, and the agency Name and also City data indigenous the client table. The query returns only orders that were required in April, and only because that customers who space based in London.
You have the right to use a type to quickly view, enter, and change data one row at a time. Girlfriend can likewise use a form to perform other actions, such as sending out data to an additional application. Forms generally contain controls the are linked to underlying areas in tables. As soon as you open a form, accessibility retrieves the data from one or more of those tables, and also then display screens the data in the layout that you made decision when you produced the form. You can produce a type by using among the Form commands on the Ribbon, the form Wizard, or develop a type yourself in style view.
Note: You use Layout view, not design view, to develop forms and also reports in net databases and also web apps.
1. A table displays plenty of records at the exact same time, yet you may need to scroll horizontally to see all of the data in a single record. Also, once you watch a table, girlfriend can"t upgrade data from more than one table in ~ the exact same time.
2. A type focuses top top one document at a time, and also it can display screen fields from much more than one table. It can likewise display pictures and also other objects.
3. A type can save on computer a button that friend click to print a report, open other objects, or otherwise automate tasks.
You deserve to use a report to easily analyze your data or to present it a certain means in print or in various other formats. For example, you may send a colleague a report that teams data and also calculates totals. Or, you may create a report with deal with data formatted because that printing e-mail labels.
1. Use a report to develop mailing labels.
2. Use a report to present totals in a chart.
3. Usage a report to screen calculated totals.
Now that you know about the simple structure of access databases, read on to learn how to usage the integrated tools to explore a specific Access database.
See details around the objects in a database
One of the ideal ways to learn about a particular database is by making use of the Database Documenter. You usage the Database Documenter to develop a report containing comprehensive information about the objects in a database. You first choose which objects will certainly be detailed in the report. Once you run the Database Documenter, that report contains all of the data about the database objects that you selected.
Open the database the you desire to document.
On the Database Tools tab, in the Analyze group, click Database Documenter.
In the Documenter dialog box, click the tab the represents the form of database object that you desire to document. To create a report on every one of the objects in a database, click the All object Types tab.
Select one or much more of the objects listed on the tab. Come select all of the objects ~ above a tab, click Select All.
The Database Documenter creates a report that consists of detailed data because that each selected object, and then opens the report in print Preview. For example, if you run the Database Documenter against a data entry form, the report developed by the Documenter list the properties for the type as a whole, the properties because that each that the part in the form, and the properties for any type of buttons, labels, message boxes, and other controls on the form, plus any code modules and user permissions that are associated with the form.
To print the report, ~ above the Print Preview tab, in the Print group, click Print.
Explore a table in design view
Opening a table in architecture view gives you a thorough look at the table"s structure. Because that example, you can discover the data type setting because that each field, find any kind of input masks, or view if the table uses any kind of lookup fields — areas that use queries to extract data from various other tables. This information is useful because data species and entry masks can affect your capability to uncover data and also run update queries. Because that example, intend that you want to use an upgrade query come update particular fields in one table by copying data in comparable fields from another table. The query will not operation if the data types for each field in the resource and location tables don"t match.
Open the database the you desire to analyze.
In the navigation Pane, right-click the table the you desire to explore, and also then click Design View top top the shortcut menu.
As needed, keep in mind the surname of every table field and the data form assigned to every field.
The data type assigned to a ar can border the dimension and kind of data that customers can enter in a field. Because that example, users might be minimal to 20 characters in a message field, and cannot go into text data in a field collection to the Number data type.
To recognize whether a field is a lookup field, click the Lookup tab in the reduced section the the table design grid, under Field Properties.
A lookup field displays one set of values (one or much more fields, such together a first and last name), yet usually shop a different collection of values (one field, such as a numeric ID). Because that example, a lookup ar may save an employee"s id number (the save on computer value), yet it screens the employee"s surname (the shown value). As soon as you usage a lookup field in expression or in find and replace operations, you usage the save value, no the shown value. Coming to be familiar with the stored and displayed worths of a lookup field is the best way to make sure that an expression or a find and replace procedure that provides the lookup field works the method that girlfriend expect.
The following illustration reflects a usual lookup field. Remember that the settings that you view in the Row Source residential or commercial property of the field will vary.
The lookup field displayed here offers a query to retrieve data from one more table. You may also see another form of lookup field, dubbed a value list, that supplies a hard-coded perform of choices. This number shows a usual value list.
By default, worth lists usage the message data type.
The best means to discover lookup and also value lists is by displaying the Lookup tab, and then click the entries in the Data Type pillar for each field in the table. For much more information around creating lookup fields and value lists, watch the web links in the See Also section.
optimal of page
See the relationships between tables
To view a graphical representation of the tables in a database, the fields in each table, and also the relationships in between those tables, use the Relationships object tab. The Relationships object tab offers an overall photo of the table and also relationship structure of a database — critical information once you need to produce or adjust the relationships in between tables.
Open the database the you desire to analyze.
On the Database Tools tab, in the Relationships group, click Relationships.
See more: Who Played Jovie In The Movie Elf, Zooey Deschanel
The Relationships thing tab appears and also shows you the relationships between every one of the tables in the open up database.