Download Database Creation Exam with Solutions and more Exams Nursing in PDF only on Docsity!
Module 1: Creating a Database (Session 1.1) Exam With complete
solution
Quick Access Toolbar: Provides one-click access to commonly used com- mands, such as save Shutter Bar Open/Close Button: allows you to close and open the navigation pane; you might want to close the pane so that you have more room on the screento view the Object's Contents. Navigation Pane: lists all the objects (tables, reports and so on) in the database and it is the main control center for opening and working with database objects Datasheet View: shows the table's contents as a datasheet ID Field: the primary key field for all new tables Add & Delete Group: contains options for adding different types of fields, includ- ing Short Text and Number, to a table Click to Add Column: provides another way for you to add new fields to a table Table Tools Fields Tab: provides options for adding, removing, and formatting the
fields in the table. Title Bar: displays the name of the open file and the program Access Window: the program window that appears when you create a new database or open an existing database Ribbon: provides the main Access commands organized by task into tabs and groups Status Bar: Provides information about the program or open file, as well as buttons for working with the file. Sign in link: will appear here, and you can click it to sign into your Office account `Datasheet: displays the table's contents in rows and columns, similar to a table that you create in a word document or excel spreadsheet. Field: is a single characteristic or attribute of a person, place, object, event, or idea. Table: is a collection of fields that describes a person, place, object, event, or idea.
relational database management system: data is organized as a collection of tables Backstage View: contains commands that allow you to manage Access Files and Options. Template: is a predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for youto create a database. Insertion Point: is a flashing cursor that shows where text you type will be inserted. Data Type: Determines what field values you can enter for the field. AutoNumber: data type automatically inserts a unique number in this field for every record, beginning with the number 1 for the first record, the number 2 for thesecond and so on. Short Text: data type , which allows field values containing letters, digits, and other characters, and which is appropriate for identifying numbers such as visit
numbers, that are never used in calculations Date/Time: Data type, which allows field values in a variety of date and time formats. Yes/No: data type is suitable for this field because it defines fields that store values representing one of two options- true/false, yes/no, or on/off Field Selector/ Record Selector: selects that entire column or row, which you can manipulate Column Selector: Known as a field selector Row Selector: Known as a record Selector
