Curipod placeholder

GR.8 Tables in Access

0
0
Profile picture of mercy.ca-smf

mercy.ca-smf

Updated 13 days ago

1. Word cloud
60 seconds
A table contains data in the form of __ and __
2. Open question
150 seconds
Define Table in Acces
3. Open question
270 seconds
Which field will you choose for setting primary key- Name or Account Number? Why
4. Open question
180 seconds
What are the two main types of Views in Access?
5. Open question
180 seconds
How will you add a new field in a table?
6. Open question
270 seconds
How will you sort the data within a table?
7. Open question
300 seconds
How will you delete a field?
8. Drawings
450 seconds
Design a data base with the fields Name, Address and Ph.No. and appropriate data type
9. Poll
60 seconds
What is a primary key in MS Access?
  • A field that stores dates and times
  • A field that stores numbers with decimal places
  • A unique identifier for each record in a table
10. Poll
60 seconds
Which data type should be used to store text values of variable length?
  • Date/Time
  • Text
  • Number
11. Poll
60 seconds
What is the purpose of an index in MS Access?
  • To improve search performance by allowing quick access to data
  • To calculate mathematical formulas
  • To store binary large objects (BLOBs)
12. Poll
60 seconds
What does the term 'one-to-many relationship' mean in MS Access?
  • Multiple records from one table can be related to multiple records in another table
  • One record from one table can be related to multiple records in another table
  • Each record can only have one related record in another table
13. Poll
60 seconds
Which statement is true about field validation rules in MS Access?
  • They ensure that only valid data is entered into a field.
  • They control the layout and formatting of forms and reports.
  • They automatically update the values of calculated fields.

Suggested content