WEBVTT Kind: captions Language: en 00:00:07.430 --> 00:00:11.500 Think about all the information you come across in a typical day. 00:00:11.500 --> 00:00:16.250 For example, if you go shopping at a department store for a toaster. 00:00:16.250 --> 00:00:21.449 The store's inventory of products is information that has to be stored somewhere, along with 00:00:21.449 --> 00:00:24.000 the price of each product. 00:00:24.000 --> 00:00:29.050 And when you do make a purchase, the store has to be able to store the sales information 00:00:29.050 --> 00:00:35.450 so they can keep a record of how much money they make and how the inventory is affected. 00:00:35.450 --> 00:00:41.530 A database allows them to quickly determine how many Brand X toasters they have without 00:00:41.530 --> 00:00:45.070 needing to count the inventory on the shelves. 00:00:45.070 --> 00:00:50.160 Even in this simple everyday life situation, there is a lot of data. 00:00:50.160 --> 00:00:55.880 Luckily, we have databases that help us manage this information. 00:00:55.880 --> 00:01:00.380 Databases have an enormous impact in almost every area of our lives. 00:01:00.380 --> 00:01:05.430 Think about what is going on around you in everyday situations and whether there might 00:01:05.430 --> 00:01:08.060 be a database at work. 00:01:08.060 --> 00:01:11.630 For example, the supermarket is stocked with items. 00:01:11.630 --> 00:01:15.670 The items have to be ordered, shipped, and stocked in the store. 00:01:15.670 --> 00:01:18.409 The supermarket has to pay for the items. 00:01:18.409 --> 00:01:25.210 Then, when the customer buys the items, the cash register looks up prices and the customer 00:01:25.210 --> 00:01:27.720 pays for products. 00:01:27.720 --> 00:01:32.360 Where databases might be involved in that situation? 00:01:32.360 --> 00:01:34.100 What about at a restaurant? 00:01:34.100 --> 00:01:37.229 Where does the food come from? 00:01:37.229 --> 00:01:39.850 Or the traffic lights in your city. 00:01:39.850 --> 00:01:44.200 Who or what controls when they turn red or green? 00:01:44.200 --> 00:01:49.440 A database maintains order and structure in our lives. 00:01:49.440 --> 00:01:54.780 Databases are created using programs such as Microsoft Office Access 2007, which is 00:01:54.780 --> 00:01:57.909 a relational database program. 00:01:57.909 --> 00:02:04.009 This means that the database arranges information in multiple tables, which makes maintaining 00:02:04.009 --> 00:02:08.800 easier and allows you to do more with the information. 00:02:08.800 --> 00:02:14.909 Let's take a look at the Ready 2 Read database. 00:02:14.909 --> 00:02:20.090 When you start Access 2007, you will see the Getting Started page. 00:02:20.090 --> 00:02:27.550 In the left pane you have the Template categories including the Featured templates and the local 00:02:27.550 --> 00:02:33.629 templates, as well as the categories on Office Online. 00:02:33.629 --> 00:02:38.669 Templates are pre-built databases focused on a specific task. 00:02:38.669 --> 00:02:43.099 You can download and use them immediately. 00:02:43.099 --> 00:02:49.239 Right now the Featured templates are selected, so in the center area of the screen we see 00:02:49.239 --> 00:02:55.219 the online featured templates, and above that, the Blank Database command that we could use 00:02:55.219 --> 00:03:00.249 if we wanted to create a database from scratch. 00:03:00.249 --> 00:03:06.449 To see templates that are part of Access, just click Local Templates in the left pane 00:03:06.449 --> 00:03:09.209 and the screen will change. 00:03:09.209 --> 00:03:14.480 Some of these are the same as the online featured templates, but are already part of your version 00:03:14.480 --> 00:03:16.559 of Access. 00:03:16.559 --> 00:03:21.950 Additionally, in the right pane you'll see a list of recently viewed databases. 00:03:21.950 --> 00:03:29.829 From this pane, you can open an existing database, which is what I'll do now. 00:03:29.829 --> 00:03:37.769 I have the Ready 2 Read database on my computer, so I'll just click Ready 2 Read. 00:03:37.769 --> 00:03:41.319 Now we are actually looking at the database. 00:03:41.319 --> 00:03:45.680 Let me show you around this Access database so you can become familiar with the Access 00:03:45.680 --> 00:03:47.280 environment. 00:03:47.280 --> 00:03:54.979 Instead of traditional menus, Access 2007 has a tabbed Ribbon system that you use to 00:03:54.979 --> 00:03:58.489 navigate and use the software. 00:03:58.489 --> 00:04:04.389 This is the same Ribbon system that is part of all the Office 2007 applications. 00:04:04.389 --> 00:04:07.659 The Ribbon is organized into tabs. 00:04:07.659 --> 00:04:12.029 Each tab contains commands that are arranged into logical groups. 00:04:12.029 --> 00:04:19.380 For example, on the Home tab, you'll see that there is a Font group that contains the font 00:04:19.380 --> 00:04:27.350 formatting commands such a font type, size, color, alignment, and more. 00:04:27.350 --> 00:04:32.900 Unless you use keyboard shortcuts for everything, the Ribbon is how you get the work done in 00:04:32.900 --> 00:04:33.900 Access. 00:04:33.900 --> 00:04:37.690 Above the Ribbon is the Quick Access Toolbar. 00:04:37.690 --> 00:04:42.069 Once you've worked with Access awhile, you may find that you have commands that you use 00:04:42.069 --> 00:04:44.430 more often than others. 00:04:44.430 --> 00:04:49.629 To make it easier to use these, you can put them on the Quick Access Toolbar. 00:04:49.629 --> 00:04:56.310 By default, the Save, Undo, and Redo commands appear on the toolbar, but you can customize 00:04:56.310 --> 00:04:58.280 it to meet your needs. 00:04:58.280 --> 00:05:04.380 To the left of the Quick Access Toolbar is the Microsoft Office Button. 00:05:04.380 --> 00:05:10.759 From here you have access to basic menu options to work with files such as New, Save, Print, 00:05:10.759 --> 00:05:12.330 and more. 00:05:12.330 --> 00:05:16.150 It is also from this menu that you can reach your Access Options.