BCIS FINAL EXAM QUESTIONS WITH100 % CORRECT ANSWERS | VERIFIED

Access is a - database management system. A _____ contains information about a given person, product, or event. - record Database _____ refers to the arrangement of data into tables and fields - design _____ words are words that have a special meaning to Access and cannot be used for the names of fields. - reserved In Access, table and field names can be up to ____ characters in length. - 64 A field whose data type is ____ characters in length. -text A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255. - Memo A field with the ____ data type can store a unique sequential number that Access assigns to a recored. Access will increment the number by 1 as each new record is added. - AutoNumber A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added. - Attachment A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table. - OLE Object In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a - databaseOne way to create a table, is to click ___ on the Ribbon and then click the Table button. - Create When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field in the table. - ID To define an additional field in Datasheet view, click the ___ column heading. - Click to Add To undo the most recent change to a table structure, click the ___ button on the Quick Access Toolbar. - Undo To delete a field in a table, right-click the column heading for the field, and then click ___ on the shortcut menu, and then type the desired field name. - Delete Field