Microsoft Office 2016 In Practice Chapter 1 Creating

Microsoft Office 2016: In Practice Chapter 1 Creating a Database and Tables 12/15/2021 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 1

Student Learning Outcomes Understanding Database Concepts Microsoft Office 2016: In Practice Creating and Managing a Database Creating and Using a Table in Datasheet View Importing Data Records from Excel Exploring Datasheet View Using Search, Sort, and Filter Tools to Find Records in a Table © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Practice Case Studies College of Sciences § Central Sierra Insurance § Tracks classes that are offered § Uses an existing database § Consists of a multi-office insurance company § Handles all lines of commercial and personal insurance policies § Tracks employee information § Uses a new database Real world examples © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Understanding Database Concepts SLO 1. 1 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 4

Microsoft Office 2016: In Practice Database Concepts § Database Management System (DBMS) § Relational Database § Hierarchy of Data § Field § Record § Table § Database © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Hierarchy of Data Microsoft Office 2016: In Practice Unit Field Description Examples A single unit of Date Enrolled, Student First data Name, Student Last Name, Student ID Record A collection of All of the fields for one student related fields stored together Table A collection of A record for each of the students related records at the university stored together Databas A collection of The collection of the student, e integrated and faculty, and course tables for the related tables entire university © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Major Access Objects Microsoft Office 2016: In Practice Form Table Data Query Report © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Navigation Pane Microsoft Office 2016: In Practice § Displayed by groups § Groups § Custom § Object Type § Tables and Related Views § Created Date § Modified Date § Filter by group § Displays only those in the group chosen © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Practice Datasheet and Design View of a Table View a table § Choose a view § Datasheet view § Design view § Navigation pane § Double-click § Right-click § Home tab, Views group © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Creating and Managing a Database SLO 1. 2 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 10

Microsoft Office 2016: In Practice Database File § Must be created BEFORE you can create any other objects § Methods § Template § Blank Desktop Database © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Practice Database Properties Details about the file and author © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Database Object Names Microsoft Office 2016: In Practice § Each object within a database must be named § With a meaning and purpose § 64 characters § Can include letters, numbers, and spaces § Can include special characters except a (. ), (!), ([]), and (‘) § Name cannot begin with a space © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Practice Access Data Types Short Text Long Text Number Date/Time Currency Auto. Number Yes/No OLE Object Calculated Lookup Wizard Hyperlink Attachment © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Create and Save Database Objects Microsoft Office 2016: In Practice § Create database objects § Used to create the initial objects § Create tab, choose object § Save database objects § Used to save the current object § File tab, Save button, name, click OK § Save a copy of database objects § Used to save a copy of an object § File tab, Save As button, Save Object As button, name, click OK © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Close, Open, and Backup a Database Microsoft Office 2016: In Practice § File tab § Close § Open § Backup (Save Database As) © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Creating and Using a Table in Datasheet View SLO 1. 3 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 17

Microsoft Office 2016: In Practice Datasheet View § Create tables § Edit the primary key § Add new fields § Entering data § Entering names § Between existing fields § Edit properties § Save a table § Open a saved table § Enter, edit and delete records § Delete fields © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Importing Data Records from Excel SLO 1. 4 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 19

Microsoft Office 2016: In Practice Import Data from Excel Ensure correct formatting Access External Data tab Click Excel button Specify source of data Choose location for storage Work through Wizard © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Exploring Datasheet View SLO 1. 5 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 21

Navigation Buttons Microsoft Office 2016: In Practice § Navigation bar § Home tab, Find group, Go To © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Practice Refine Datasheet Layout § Modify field order § Select font face and font size § Modify row height § Click and drag § Shortcut menu § Modify field width § Selected columns § Auto. Fit § Shortcut menu © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Refine Datasheet Layout, Continued Microsoft Office 2016: In Practice § Modify field alignments § Left § Right § Center § Display gridlines § Display alternate row colors § Use the Datasheet Formatting dialog box SAVE © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Using Search, Sort, and Filter Tools to Find Records in a Table SLO 1. 6 © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part. 25

Microsoft Office 2016: In Practice Search Data § Search box § Find button § Shortcut menu © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Sort Data Microsoft Office 2016: In Practice § Single field § Sort & Filter group § Shortcut menu § Shift+F 10 A Ascending TO Z § Multiple fields § Sort & Filter group § Remove criteria Z TO A Descendin g © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Microsoft Office 2016: In Practice Filter Data § By selection § Use shortcut menu § Create compound filter criteria § Remove filter criteria AND • Contains ALL of the criteria values OR • Contains at least one of the criteria values © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.

Chapter Summary SLO Summary Microsoft Office 2016: In Practice 1. 1 1. 2 1. 3 1. 4 1. 5 1. 6 Explain data organization concepts, use the Access Navigation Pane, and identify objects Create a database, set database properties, understand database object naming conventions and data types, and close a database Create a table in Datasheet view, edit the default primary key, add a new field, edit field properties, save a table, and enter records into a table Import data records from Excel Navigate table records in Datasheet view and customize a datasheet by modifying field order, row height, column width, field alignment, font style and size, row colors, and gridlines Search, sort, and filter records in a table © 2017 by Mc. Graw-Hill Education. This proprietary material is solely for authorized instructor use. Not authorized for sale or distribution in any manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or part.