Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: In the previous lesson, you learned how to create a simple query with one table. Most queries you design in Access will likely use multiple tables, allowing you to answer more complex questions. In this lesson, you'll learn how to design and create a multi-table query. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn how to create a multi-table query (Part 1). Watch the video below to learn more about joins and query criteria (Part 2). DESIGNING A MULTI-TABLE QUERY Queries can be difficult to understand and build if you don't have a good idea of what you're trying to find and how to find it. A one-table query can be simple enough to make up as you go along, but to build anything more powerful you'll need to plan the query in advance. PLANNING A QUERY When planning a query that uses more than one table, you should go through these four steps: Pinpoint exactly what you want to know. If you could ask your database any question, what would it be? Building a query is more complicated than just asking a question, but knowing precisely what question you want to answer is essential to building a useful query. Identify every type of information you want included in your query results. Which fields contain this information? Locate the fields you want to include in your query. Which tables are they contained in? Determine the criteria the information in each field needs to meet. Think about the question you asked in the first step. Which fields do you need to search for specific information? What information are you looking for? How will you search for it? This process might seem abstract at first, but as we go through the process of planning our own multi-table query you sho

This website is dedicated to lesson plans. It assists in the development of lesson plans, finding ideas and resources to form a lesson plan, and allows one to view existing lesson plans.

This is a site that teachers share their lesson plans for reading and writing they found successful.

In correspondence with the New York Times, this website provides recent news relevant to education issues, lesson plan archives and daily lesson plan updates. The website has three categories; teacher connections, student connections, and parent connections.

Lesson planning site! This site is specifically used for giving teachers ideas of connections for using in their lesson plans.

A blog created by teachers for teachers. Find teaching tips and resources for Pre-K to 8th grade teachers. Topics include classroom management, free lesson plans, educational techniques, and more. A blog created by teachers for teachers. Find teaching tips and resources for Pre-K to 8th grade teachers. Topics include classroom management, free lesson plans, educational techniques, and more.

Teachnology.com is an innovative website that provides future and current teachers with a plethora of lesson plans in all content areas and grade levels.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Access is a database creation and management program. To understand Access, you must first understand databases. In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Microsoft Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access tutorial. Watch the video below to learn more about databases in Access. WHAT IS A DATABASE? A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They're such a useful tool that you see them all the time. Ever waited while a doctor's receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? If so, then you've seen a database in action. The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above: the database of patient information at a doctor's office. What lists are contained in a database like this? To start with, there's a list of patients' names. Then there's a list of past appointments, a list with medical history for each patient, a list of contact information, and so on. This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give these cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. An illustration of two lists - www.office.com/setup However, if you were a professional baker, you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders, and so on.

This site is really great for picking a lesson plan topic or even unit plan topics. It lists the topic, for example U.S. History, then under that there is a list of ideas.

Scholastic.com is a valuable resource for teachers to utilize in that it provides the options of lesson plans, teaching strategies, timesaving tools, planning calendar, printables and mini-books, as well as an online stoor for resources.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about working with tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

This website gives you example lesson plans, sample worksheets, examples of useful projects and much more.

Education world is a resourceful website for teachers offering references and assistance with lesson plans.

This site provides everything a teacher could be looking for. There are lesson plans, ideas for technology integration, and solutions to school issues.

Teaching website. Has lesson plan ideas, how to develop as a professional, information on the administration, technology integration, school issues you may face, and more.

While parts of this website cost money, there are thousands of free worksheets, reading comprehension ideas, research report concepts, and theme units for multiple subject areas. This website is perfect for worksheets, ect. that can enhance a lesson plan.

This is a wonderful reference guide for teachers that offers detailed lesson plans, online education information, and question archive responses.

Mrs. Alphabet is a website that would help future teachers of younger children come up with lesson plans according to holidays and times of the month. It would also help teachers with ideas on how to teach the alphabet, phonics, and mathematics.

A site to look up lesson plans for teachers of all subjects and grade level

This website provides activites such as concept maps, lessons, and various activites taylored to the grade you are teaching and the subject matter. There are various catagories for teachers, parents, and students to obtain a vast amount of information.

TeacherTube.com allows teachers to utilize the media of videos as an educational tool within their classrooms on various elements of curriculum.

A site for teachers that gives lesson plans, activities and advice for learning to write creatively!