Access reports can be based on a) Tables b) forms c) queries d) a or c 17) Unlik
ID: 382822 • Letter: A
Question
Access reports can be based on a) Tables b) forms c) queries d) a or c 17) Unlike other Microsoft office applications, an Access database file must be a) completed fully before saving it b) Saved first on your flash drive c) Created and saved first d) B and c 18) which of the ollowing are required when defining an Access table structure? a) Data type b) Field name c) description d) a and b 19) Which of the following Access objects must definitely database file? be created in a a) table b) form c) query d) none of the above 20) Which of the following is true for Access? a) 2 records in a table can't have the same primary key value b) 2 tables cannot have a field with the same name c) A table can only have 1 form. d) A and b Il. True/False 21) Every field in an Access table should represent an entity 22) Data warehouses are used by large corporations dealing with much data in many locations 23) Forms store the records for a company's database. 24) A report is a database object 25) Access tables are files 26) The title box of a form is considered an object 27) The background color of the form's header is an object property 28) Input masks are pful to keep a consistent format for data in fields. 29) Access a data e report and query in different files 30) Access allov ou to create a maximum of 3 different types of objects. 31) Lookup v is useful for creating drop-down list for a field. don't have to have a data type. 33) The s f a field is considered a field property.Explanation / Answer
Access report is based on table or queries.
While using office excess first you have to make a table or query to create a new form
16 So option D is correct
First save and then work on file because if accidently it is closed in between without being saved all the working will be ruined so well create and save first and then work
17 Option D is correct
Field name and data type is mandatory. Description cell is optional either you can use it or ignore it.
18 So option D is correct
19
As I have mentioned in the first answer table and query is mandatory to create
20 A & C are the correct option.