Microsoft Access 2013 Design and Create Tables to Store DataChapter OverviewDatabases and Decision MakingDesigning Database TablesSlide 5Creating Tables in AccessPrimary KeysField Data TypesField PropertiesQuestions & Requested Updates from HR UsersQuick ReviewSlide 12Slide 13Slide 14Slide 15Microsoft Access 2013Design and Create Tables to Store DataChapter 2Chapter OverviewDatabases and Decision MakingDesigning Database TablesCreating Tables in AccessPrimary KeysField Data Types and PropertiesDatabases and Decision MakingInput(Data)Process Output(Information)Input using Forms Handled by Queries Output to ReportsStored in Tables Supports Decision MakingGIGO – Garbage In, Garbage OutDesigning Database TablesDatabase design is critically important to the success of an information system.Your tables are the foundation of the entire database.Designing Database TablesInclude the necessary data–Determined by reporting needsStore data in its smallest parts–Split last and first namesAvoid storing calculated data (GPA)–What about age versus birthdate?Avoid data redundancyCreating Tables in AccessTable Wizard (don’t use)Datasheet and Design ViewsPrimary KeysA field or combination of fields that uniquely identifies records in a table.–Use an existing field–Use a combination of fields (concatenated key)–Create a new field using the Autonumber data typeField Data TypesAutoNumberShort TextHyperlinkNumberLong TextDate / TimeCurrencyYes / NoOLE ObjectAttachmentCalculatedLookup WizardField PropertiesField SizeFormatInput MaskCaptionDefault ValueValidation RuleValidation TextRequiredAllow 0 LengthIndexedThese help to prevent GIGOQuestions & Requested Updates from HR UsersBad data appears in AssessmentScoreNeed email address of every applicantWant option to store 9 digit zip codeCID value occasionally skips numbersNeed to track the HR employee assigned to each candidateData entry and editing is not user-friendlyQuick ReviewWhat does GIGO stand for?a. Gee, I Goofed, OKb. Grand Illusions, Go Onc. Global Indexing, Global Orderd. Garbage In, Garbage OutQuick ReviewWhich of the following is true of the primary key?a. Its values must be uniqueb. It must be defined as a text fieldc. It must be first in a tabled. It can never be changedQuick ReviewWhich fields are commonly defined with an input mask?a. Social Security numberb. First, middle and last namec. City, state and zip coded. All of the aboveQuick ReviewWhich field data type appears as a check box in a table?a. Text fieldb. Number fieldc. Yes/No fieldd. All of the aboveQuick ReviewThe_______ is a field (or combination of fields) that uniquely identifies a