Microsoft Office Access 2007 Lab 1ObjectivesSlide 3Slide 4Concept PreviewOutlineSlide 7Slide 8Slide 9Slide 10Slide 11Slide 12Designing a New DatabaseConcept 1Creating and Naming the Database FileStarting with a Blank DatabaseSaving the New DatabaseAccess Application WindowConcept 2Using the Navigation PaneUsing Datasheet ViewAccess ViewsDefining FieldsEntering DataChanging Field NamesEditing EntriesDefining Data TypeConcept 3Data TypesData TypesUsing Field TemplatesField TemplatesSwitching ViewsUsing Design ViewConcept 4Field PropertiesModifying Field PropertiesChanging Data TypeEditing Field NamesConcept 5Defining a Primary KeyEntering a Field DescriptionEntering and Editing DataVerifying Data Accuracy and ValidityUsing AutoCorrectAttaching a FileSlide 47Moving between FieldsZooming a FieldChanging Column WidthDeleting RecordsCreating a Second TableUsing the Lookup WizardConcept 6Using a Lookup FieldPreviewing and Printing A TablePreviewing the TablePrinting a TablePrint Range OptionsChanging the Page Orientation and MarginsMore on Changing the Page Orientation and MarginsClosing and Opening a Table & DatabaseConcept 7SubdatasheetExiting AccessKey TermsKey TermsSlide 68Slide 69Slide 70FAQsSlide 72Discussion QuestionsSlide 74McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Microsoft Office Access 2007Lab 1Creating a DatabaseMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Objectives1. Plan, create, and modify a database2. Create and save a table structure3. Define field names, data types, field properties, and primary key fields4. Enter and edit data1-2McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Objectives5. Add attachments 6. Change views7. Adjust column widths8. Use the Best Fit feature9. Create a second table1-3McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Objectives10.Create a Lookup field11.Delete records12.Preview and print a table13.Change page orientation 14.Close and open a table and database1-4McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Concept Preview•Database•Object•Data Type•Field Property•Primary Key•Lookup Field•Subdatasheet 1-5McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Introducing Access 2007–Starting Access–Exploring the Access Window•Creating a New Database–Planning and Designing a Database–Creating and Naming the Database1-6McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Creating a Table–Defining Field Names–Defining Data Types–Defining Field Properties–Entering a Field Description1-7McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Creating a Table continued–Defining a Primary Key Field–Defining Date formats–Defining Additional Fields–Editing Field Definitions–Saving the Table Structure1-8McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Entering and Editing Table Data–Using Table Datasheet View–Entering Data in a Datasheet View–Editing Data–Inserting a Picture–Navigating a Datasheet1-9McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Changing a Column Width–Resizing a Column–Using Best Fit•Adding Records in Data Entry•Deleting Records1-10McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Previewing and Printing a Table–Previewing the Table–Changing the Page Orientation–Printing a Selected Page•Closing and Opening a Table and Database1-11McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Outline•Exiting Access•Key Terms•FAQs•Discussion Questions1-12McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Designing a New Database1-13McGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Concept 1•Database – Organized collection of related information•Table – Vertical columns & horizontal rows where information is stored•Record–A row –Information about one person, place, or thing•Field –A column –Smallest unit of information 1-14DatabaseDATABA SEMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Creating and Naming the Database FileMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Starting with a Blank DatabaseMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Saving the New DatabaseMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Access Application WindowMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Concept 21-19ObjectMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Using the Navigation PaneMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Using Datasheet View •A visual presentation of the data•Consists of rows and columns •Header row contains field names•Select All button is used to select an entire row •Record number indicator shows the total number of records in the tableMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Access ViewsMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Defining FieldsMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Entering DataMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Changing Field Names•A field name is used to identify data stored in the field•Should describe the contents of the data entered in the field•Name can be up to 64 characters long–Cannot begin with a space–Best to use short field namesMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Editing EntriesMcGraw-Hill Career Education © 2008 by the McGraw-Hill Companies, Inc. All Rights Reserved.Defining Data TypeMcGraw-Hill Career Education © 2008 by the McGraw-Hill