DH Templates

Microsoft Access 2000 Questions. I really need help anwering them?

1.List the major steps in designing a new database 2.How do you edit field properties 3.Which two operators let you combine expressions so you can test more than one condition 4.How would you select all records containing today’s date? 5.Suppose you have defined a query to list employees and their salaries in descending salary order. What would you need to do to list the give highest salary earners? 6.What access feature helps you in creating expressions 7.How would you define a total query 8.How do you add an extra field to a form 9.How do you stop a column displaying in a combo box? 10.How would you change an option’s label 11.Suppose you have drawn a rectangle around a group of fields but it is filled with colour and it is hiding the fields. What would you do to overcome this problem? 12.List two ways to move to the last record in a datasheet 13.How do you create a new database using one of the supplied templates? 14.What is the purpose of the sorting and grouping feature 15.How do you add a calculated control to a report 16.What symbol is used to concatenate test into one field 17.List two methods for creating form letter using access data 18.What is the purpose of the field builder? 19.How do you make access automatically display a value in a field when you are adding records to a table 20.What data type would you use to define a field where the possible values are on or off

Public Comments

1. Look in your textbook, or whatever notes you were given on the subject. I don't expect anyone on here to answer all of these questions satisfactorily--I put at most 15 minutes of effort into a question! Purr
2. Are these home work questions that you are looking for someone to do it for you? you will have better luck if you post each question separately. By that will require extra effort on your part. Looks like you will likely fail this class....................