Microsoft Access Exam Ltest Updated

True or False: When importing a new table from an existing Excel worksheet, the user must import all columns from Excel into the new Access table. - Answer false Which of the following is NOT an option for print range of a table? - Answer Records From: ________ To: ________ True or False: Entering data on a single-record form will automatically update the data in the record without having to click save. - Answer true true or false: When a designer shortens the field length of an existing field, all data for existing records will be truncated to match the new field length. - Answer true true or false: Users should not store redundant data within a database and should create a new table to contain that data. - Answer true true or false: User can export an Access Table to a Word Document. - Answer true true or false: The Short Text data type will allow a user to store up to 512 characters in that field. - Answer false True or False: All templates provided by Microsoft are safe and users can enable content if any warning message is displayed. - Answer true Which of the following is NOT a way method to create a new database? - Answer Database wizard When appending or creating a new table from an Import, the file that is being imported is called the ________ file. - Answer source true or false:Primary keys must be numbers. - Answer false A user can delete multiple columns from Layout view of a Form by holding down the ________ key and clicking on the range of columns to delete. - Answer SHIFT Database designers typically do not add spaces in field names (LName), but can add details in the ________ field of the field properties to provide additional context to the field that is not displayed (Last Name). - Answer caption true or false:If users delete a Field from the Design view by accident, they can click Undo to correct the error. - Answer false true or false:To use the Append option to add records to an existing table, the column headings in the Excel worksheet must be identical to the field names in the table. - Answer true true or false:Once users select a data type for a field and enter data, they cannot change the data type. - Answer false True or False: After users enter critical information and click Create, they will be directed immediately to Table 1 after creating a new database from Blank desktop database. - Answer true A user can close the existing database and leave Access open to continue working on anther database by clicking close from the ________ tab. - Answer File True or False: Each table should have a field that contains a unique value for each record in the table. - Answer true When designing a new database, the first question users should ask themselves is ________. - Answer What questions should this database be able to answer? Pressing Enter three times at the end of a multiple-items form will open ________. - Answer a single record form true or false: By default, when a user opens a table and selects Report from the Create tab, all fields and all records are included in the report. - Answer true true or false: Users can add additional tables to databases created from templates. - Answer true A ________ is an organized collection of data. - Answer database True or False: In the Datasheet view, a user will see the underlying structure of the table. - Answer false A user can use ________ to view how a table will print before committing. - Answer Print Preview true or false: Within an Access table, each row is a field and each column is called a record. - Answer false Fields that contain numbers that are not used in calculations should be set to ________. -