demen_demen
New member
- Local time
- Yesterday, 16:44
- Joined
- Nov 14, 2007
- Messages
- 6
I need to complete a project for school for my computer class. I am having some problems with this one assignment. I am finished but want to know if anybody can help me. Just verify that the answer is right or wrong. Any input will be greatly appreciated. Here it is... Its just a fill in the blank so if anybody who knows MS access can help me that would be great. Thanks.
The word required are the ones with the underscores around them.
Fill in the blanks:
1. Some developers like to use the _Design View_ property for a field to document its contents, such as identifying a field as a primary or foreign key or providing users with instructions about entering values into the field.
2. A _Query__ is a database object that stores criteria for selecting records from one or more tables based on conditions you specify.
3. To select multiple controls, you could click a control, and then press and hold the _Shift_ key and then click the addition controls you want to select, releasing the key once all the controls are selected.
4. A form?s _Table_ is the underlying object that provides the fields and data in the form.
5. You can view a description of each property in a property sheet by clicking the property and then pressing the _F1_ key.
6. When you select a control, eight handles appear on its corners and edges. The larger handle in a control?s upper-left corner is its _Move_ handle.
7. A
_Data Type_ displays a list of values, and lets users select one from the list.
8. Each report can have up to _Over 300_ sort fields.
9. An advantage of using the _Table Wizard_ to create a table is that the sample tables and fields already have properties set that might work well in your database or that are easily changed to accommodate your specific data needs.
10. In Design view, you can use the _Property Sheet_ to set the properties for fields that do not use the default settings.
11. In Access, you can specify restrictions on the data that users can enter into a field by creating a _Validation Rule.
12. If a user attempts to enter an invalid value in a field, the _Validation Text_ property for the field opens a dialog box with a predefined message that explains the valid values.
13. In Access, you define table relationships in the _Relationship_ window.
14. You use _Borders_ around field names to distinguish them from function names or other types of values.
15. When entering the data in a table in Datasheet view, you would press the _Control + Minus Sign_ key to cancel a record that you have just entered.
16. In Access, you can control the format of a value by creating a _Input Mask_.
17. A _Look Up_ field lets the user select a field value from a list of existing field values stored in the database or from a list of values specified when the field was created.
18. The primary objective of creating a _Indexed_ field in a table is to prevent users from entering duplicate records into the table.
19. If an expression is complex, you can use _Brackets_ to indicate which operation should be performed first.
20. To move from one record to another in a main form, you would click the buttons on the _Navigation_ bar at the bottom of the main form.
The word required are the ones with the underscores around them.
Fill in the blanks:
1. Some developers like to use the _Design View_ property for a field to document its contents, such as identifying a field as a primary or foreign key or providing users with instructions about entering values into the field.
2. A _Query__ is a database object that stores criteria for selecting records from one or more tables based on conditions you specify.
3. To select multiple controls, you could click a control, and then press and hold the _Shift_ key and then click the addition controls you want to select, releasing the key once all the controls are selected.
4. A form?s _Table_ is the underlying object that provides the fields and data in the form.
5. You can view a description of each property in a property sheet by clicking the property and then pressing the _F1_ key.
6. When you select a control, eight handles appear on its corners and edges. The larger handle in a control?s upper-left corner is its _Move_ handle.
7. A
_Data Type_ displays a list of values, and lets users select one from the list.8. Each report can have up to _Over 300_ sort fields.
9. An advantage of using the _Table Wizard_ to create a table is that the sample tables and fields already have properties set that might work well in your database or that are easily changed to accommodate your specific data needs.
10. In Design view, you can use the _Property Sheet_ to set the properties for fields that do not use the default settings.
11. In Access, you can specify restrictions on the data that users can enter into a field by creating a
_Validation Rule.12. If a user attempts to enter an invalid value in a field, the _Validation Text_ property for the field opens a dialog box with a predefined message that explains the valid values.
13. In Access, you define table relationships in the _Relationship_ window.
14. You use _Borders_ around field names to distinguish them from function names or other types of values.
15. When entering the data in a table in Datasheet view, you would press the _Control + Minus Sign_ key to cancel a record that you have just entered.
16. In Access, you can control the format of a value by creating a
_Input Mask_.17. A
_Look Up_ field lets the user select a field value from a list of existing field values stored in the database or from a list of values specified when the field was created.18. The primary objective of creating a
_Indexed_ field in a table is to prevent users from entering duplicate records into the table.19. If an expression is complex, you can use _Brackets_ to indicate which operation should be performed first.
20. To move from one record to another in a main form, you would click the buttons on the _Navigation_ bar at the bottom of the main form.
