1.To combine criteria with ____________________, place the criteria on the same row.2.To compact and repair a database, tap or click the ___ button in the Info gallery in the Show
Get answer to your question and much more Get answer to your question and much more 3.To create a crosstab, click the ____ button on the CREATE tab. Get answer to your question and much more 4.To create a lookup field, select ____________________ from the menu of available datatypes.5.To create a multivalued field, create a ____ field being sure to check the Allow Multiple Get answer to your question and much more Values check box.6.To create a multivalued field, create a(n) ____________________ field being sure to Get answer to your question and much more check the Allow Multiple Values check box. Get answer to your question and much more 7.To create a new query in Design view, click CREATE on the ribbon to display theCREATE tab and then click the ____button to create a new query.8.To create a parameter query, enter a parameter rather than a specific value as a criterion in Get answer to your question and much more the design grid. The parameter must be enclosed in ____. Get answer to your question and much more 9.To create a split form, select the table in the Navigation Pane, click CREATE on theribbon, click the ____ button on the CREATE tab to display a menu, and then click SplitForm on the menu.10. To create a top-values query, use the Top Values box on the DESIGN tab to change the Get answer to your question and much more number of records to be included from All to the desired number. Get answer to your question and much more 11. To create a validation rule for the State field to restrict entries to TN or TX, enter ____ inthe Validation Rule property box.12. To create an update query, create a new query and then click the ____ button on the Get answer to your question and much more DESIGN tab.13. To define an additional field in Datasheet view, tap or click the ____ column heading. Get answer to your question and much more 14. To define an additional field in Datasheet view, tap or click the ____________________ Get answer to your question and much more column heading, select the data type, and then type the field name. Get answer to your question and much more 15. To delete a database object, press and hold or right-click the object in the NavigationPane and then tap or click ____ on the shortcut menu.16. To delete a field from a table, open the table in ____ view, click the row selector for the Get answer to your question and much more field to be deleted, and then press the DELETE key. Get answer to your question and much more A Totals row in Access helps you see, at a quick glance, what the totals are for columns on a datasheet. For example, in a table of purchase information, we can show the sum of the price, or units purchased, or a total count of the items by adding a Totals row to the datasheet:
Note: To show the Sum value for a column, the column’s data type has to be set to Number, Decimal or Currency. For non-numeric columns, you can only select the Count total type. Add a Totals row
Selecting the total typeAfter adding the Total row, you select what type of totals value is displayed for each column. For example, aggregates like sums can be displayed when the data type is set to Number, Decimal, or Currency. A count of values is possible when the data type is a text value. Let’s have the datasheet in this example show us the total sum value for the Purchase Price and Units Purchased columns and the total count for the Item column in the image below:
Understand Sum and the other aggregate functionsAggregate functions perform calculations on columns of data and return a single result. You use aggregate functions when you need to calculate a single value, such as a sum or an average. As you proceed, remember that you use aggregate functions with columns of data. That may seem like an obvious statement, but when you design and use a database, you tend to focus on rows of data and individual records — you make sure that users can enter data in a field, move the cursor to the right or left and fill in the next field, and so on. In contrast, you use aggregate functions to focus on groups of records in columns. For example, suppose you use Access to store and track sales data. You can use aggregate functions to count the number of products sold in one column, calculate total sales amounts in a second column, and calculate the average sales amount for each product in a third column. This table lists and describes the aggregate functions that Access provides in the Totals row. Remember that Access provides additional aggregate functions, but you must use them in queries.
More about the Standard Deviation and Variance functionsThe Standard Deviation and Variance functions compute statistical values. Specifically, they calculate where values are clustered around their mean (their average) in a standard distribution (a bell curve). For example, suppose you randomly collect 10 tools stamped from the same machine and measure them for breaking strength — a process that tests the machine and your quality control measures. If you compute an average breaking strength, you can see that most of the tools have a breaking strength that is close to that average, while a few have a greater strength and a few have a lesser strength. However, if you only compute the average breaking strength, that value does not tell you how well your quality control process works, because a few exceptionally strong or weak tools can skew the average up or down. The Variance and Standard Deviation functions work around that problem by telling you how close your values are to the mean. For breaking strength, the smaller the numbers returned by either function indicate that your manufacturing processes are working well, because few of the tools have a breaking strength above or below the average. A complete discussion of variance and standard deviation is beyond the scope of this article. You can consult any number of statistics Web sites for more information about both topics. Remember these rules as you use the Variance and Standard Deviation functions:
Top of Page When you enter text data in a criterion you must enclose the text in quotation marks?When you enter text data in a criterion, you must enclose the text in quotation marks. The asterisk (*) wildcard represents any collection of characters. The question (?) mark wildcard represents any collection of characters.
When you sort data in a query the records in the underlying table are actually rearranged?The field or fields on which records are sorted is called the sort key. If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key. When you sort data in a query, the records in the underlying table are not actually rearranged.
When you sort data duplicates are not included?When you sort data, duplicates are not included. The expression for a calculated field can be typed directly into the field row. When you sort data in a query, the records in the underlying table are acutally rearranged. The property sheet is a window containing various properties of the object.
Does changing the column width in a Datasheet changes the structure of a table?Changing the column width in a datasheet changes the structure of a table. Landscape orientation means the printout is across the length (height) of the page. To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.
|