+
Related Flashcards
Cards In This Set
| Front | Back |
|
-----view allows you to create a table in a spreadsheet view
a. Datasheet b. Design c. Excel |
A
|
|
A ---key is a field that contains unique values
a. Main b. Primary c. Secondary |
B
|
|
A field name cannot have more than---characters
a. 32 b. 64 c. 128 |
B
|
|
---field allows better formatting of data in tables ,forms and reports
a. Text b. Memo c. Rich text memo |
A
|
|
---property enables you to limit the values that can be entered in a field
a. Validation rule b. Validation text c. Allow zero length |
A
|
|
A field name cannot include spaces
|
F
|
|
Deleting a field means deleting the entire the entire data of that column from the selected records only
|
F
|
|
Input mask field property makes data entry easier and controls the values a user can enter
|
T
|
|
You can delete a field in design view
|
T
|
|
You can insert records by clicking on insert button of records group on the home tab
|
T
|
|
Match the columns
1. Auto number. A. Stores value in a monetary format 2. Text. B. Logical Data used when only one of Two options is valid 3. Number. C. Can contain values that are text , numbers or both 4. Currency. D. Creates unique values automatically 5. Yes/no. E. Can store numeric data only |
1. D
2 C 3. E 4. A 5. B |
|
Explain the term
data type |
It is a type of field that specifies the type of data you can enter into it:
autonumber: it creates a unique value automatically text: it contains values in the firm of text , numeric or a combination memo: it is a large version of a text field allowing storage upto 2 GB data number: it stores numeric values upto 16 bytes of data date/time: it is used to store date and time data currency : it stores values in a monetary format yes/no: it is used when one of the two options is valid OLE object: it stores images , documents from other windows based programme hyperlink: it is used to store web addresses attachment: it is used to store images spreadsheet files as an attachment |
|
Explain the term design view
|
It allows to create a table in a professional way by first defining the structure of a table and then entering the data.it is used by programmers and professionals
|
|
Write the steps to Create a table in MS-access using design view
|
Select table design option from the tables group
there will be three columns on table design screen-field name , data type and description.enter all the three columns. save the table by pressing Ctrl+S keys or by pressing save option.type the name of the table and press Ok a message box appears on the screen giving a warning no primary key is defined .click no press Ctrl+W keys together to close the table window |
|
Write the steps to insert a new field in the table using data sheet view
|
A table is created by default
the workspace of database shows table 1 . start entering the data in rows and columns of the table in data sheet the field names are seen as ID field 1 , field 2 after entering data save the table by pressing Ctrl+s keys or choose save options press ok |
