New perspectives on microsoft office 2013 textbook solutions free download.theunfamousseries.com
Stories inside.(READ) New Perspectives on Microsoft® Office , Second Course – Keane
May 16, · With proven pedagogy that emphasizes critical-thinking, problem-solving, and in-depth coverage, New Perspectives helps students develop the Microsoft Office skills they need to be successful in college and beyond. Updated with all new case-based tutorials, New Perspectives Microsoft Office continues to engage students in applying skills to real ISBN: , Oct 22, · Search and overview Search and overview. MS Office Syllabus Summer pdf. Demonstrate integration of the applications in Office with each other. TEXT: New Perspectives, MS Office First Course 1st Edition by Shaffer/ Carey/ Parsons/ Oja / Finnegan. ISBN: e-Book and SAM code also available.
New perspectives on microsoft office 2013 textbook solutions free download.
Unlike static PDF New Perspectives on Microsoft Office , First Course 1st Edition solution manuals or printed answer keys, our experts show you how to solve each problem step-by-step. No need to wait for office hours or assignments to be graded to find out where you took a . Unlike static PDF New Perspectives on Microsoft Excel , Comprehensive 1st Edition solution manuals or printed answer keys, our experts show you how to solve each problem step-by-step. No need to wait for office hours or assignments to be graded to find out where you took a . Oct 22, · Search and overview Search and overview.
This document is organized chronologically, using the same headings that you see in the textbook. Under each heading you will find in order : Lecture Notes that summarize the section, Figures and Boxes found in the section if any , Teacher Tips, Classroom Activities, and Lab Activities.
Pay special attention to teaching tips and activities geared toward quizzing your students, enhancing their critical thinking skills, and encouraging experimentation within the software. For your students: Our online feature, CourseCasts, is a library of weekly podcasts designed to keep your students up to date with the latest in technology news.
Ken is an expert in the latest technology and sorts through and aggregates the most pertinent news and information for CourseCasts so your students can spend their time enjoying technology, rather than trying to figure it out.
Open or close your lecture with a discussion based on the latest CourseCast. Chapter Objectives Students will have mastered the material in this tutorial when they can: Session 1. Session 1. The tables within the database contain a collection of records. The records within the table contain a collection of fields.
Each field in the table represents a particular characteristic of the data. A field, or a collection of fields, is designated as the primary key. The primary key uniquely identifies a record in the table. When the primary key of one table is represented in a second table to form a relationship, it is called a foreign key.
This may not be clear when you first say it; however, students seem to understand the concept easily when you show them an example such as the one shown in the text. The figures in this section of the tutorial are very useful for reinforcing these concepts. Be sure students understand Figures , , and Students might wonder if there are other kinds of databases besides relational databases.
Explain that while there are different types of databases, the relational database is the most popular type of database today. This is mainly because it is the easiest type of database to learn and to use. Group Activity: Encourage students to think about creating a database that will store information about students. Reemphasize the importance of good database design.
Divide students into groups of two or three. Ask each group to design a table that will contain information about students. Refer students to Figure and Figure The groups should decide on all the fields characteristics they would need to maintain student records.
Once the fields are defined, guide them toward selecting a field that would uniquely identify a student usually a student ID. Group Activity: Ask students to create another table that will store information about the student organizations students participate in or extracurricular activities, sports, etc.
When students have decided what the second table will be, have them determine the required fields. Most importantly, have the groups decide on the common field that will link these tables in a relational database. You can keep this example going throughout the course. As you present concepts about relationships between tables, you can use a table for students and one for advisors to help you illustrate these concepts.
Quick Quiz: In database terms, a is a single characteristic or attribute of a person, place, object, event, or idea. Answer: C A. Answer: table True or False: In a relational database, you connect records in separate tables through a common field that appears in both tables.
Answer: True. Review the Session 1. It contains options for creating a new database, opening an existing database, and more. You can create a new database that. If the database you need to create contains objects that match the ones found in common databases, such as ones that store data about contacts or events, you can use a template that Access installs listed in the Available Templates section or download a template from Microsoft Office Online listed in the Office.
If you are working on a touch device, such as a tablet or touch monitor, you can switch to Touch Mode in Access to make it easier for you to tap buttons on the ribbon and perform other touch actions.
However, the examples are designed for using a mouse and, if followed, will take them out of Touch Mode. Quick Quiz: When you are viewing the Backstage view, which of the following is not one of the options? Answer: D A. Answer: template The new blank table that Access creates is displayed in view.
Answer: Datasheet 2. Assign a Project: Guide students in thinking about database terminology and opening the Help Center to find the answer.
Explain that sometimes knowing how to search will give you better results. Discuss the findings in class. Discuss guidelines for naming fields in Access tables.
Demonstrate how to change the default primary key name and data type. Demonstrate how to add new fields in a table. Demonstrate how to enter records and then data into fields in the database. Demonstrate how to save and name a table. Demonstrate how to open a table using the Navigation Pane. Demonstrate how to save a table.
In a later tutorial, they will learn how to add records in other ways. As they enter records, they will be placed in the table in the order in which they were entered.
However, when you close the table and open it again, the records will be ordered according to the primary key order. The navigation bar at the bottom of Datasheet view will indicate how many records are in the table and what the current record is i. Discuss how Access allows you to save using the SkyDrive to store the database. To use it they must have an account and log in to save and retrieve files. Answer: because of the way you formatted the numbers 2. Quick Quiz The data type allows values that contain digits, a decimal point, commas, a plus sign, and a minus sign.
Currency B. AutoNumber C. Number D. Emphasize how important the database name is. Have the students open Access and create a database based on the classroom activities in the above section. Have the students assign field names to the characteristics they defined. This short section explains why they should close tables to avoid unintended changes. The changes will not be saved if you exit Access first B.
It prevents unintended changes being made in the table C. You cannot exit Access with open tables D. All of the above The Close button is located on the. Answer: program window title bar True or False: Exiting Access will automatically close all open tables first. Demonstrate how to open an existing Access database. Demonstrate how to copy and paste records from another Access database.
Explain that there are many other ways to enter records in a table, including copying and pasting records from a table into the same database or into a different database. Quick Quiz: To select all the records in a table, click the. Answer: False True or False: To copy and paste records from one database to another, the tables must have the same structure. Answer: True 2. Class Discussion: What two ways have you learned so far to input information into a table?
Answer: Key the information or copy and paste the information. Give an example of when you might want to combine the information from two databases. Answer: Answers will vary, but one might be when two salespeople are combining their customer sales information. Figure shows which record becomes the current record when you click each navigation button. Note the New record button, which works in the same way as the New button on the Home tab you used earlier to enter a new record in the table.
Quick Quiz: True or False: You can make a field the current field by clicking anywhere within the column for that field. Answer: False 2. Class Discussion: What two methods can be used to move through records in a table? Answer: the horizontal and vertical scroll bars and the navigation buttons. If you have not been using a student data example, then make the questions match the data you have been using as an example.
Quick Quiz: When you create a query, you tell Access which you want and what Access should use to select the records. Answer: B A. Answer: Simple Query Wizard 2. Explain that in this section students will create a very simple form. Later they will learn how to make more design decisions about the appearance of the form. Quick Quiz: A is an object you use to maintain, view, and print records in a database.