It can be complex, but not when approached the Dummies way! We describe opening and creating databases in the rest of this chapter. In this chapter, we introduce you to the components of an Access database and explain some key concepts related to developing and using Access databases. Figure 2-2: The Access window with a database open. A list of buttons that you can add to the Quick Access toolbar appears. A virus is a program that must be intentionally written by a human to do bad things and also make copies of itself. There — now you have a database to explore. The usual way that this works is that several computers on a network usually a local area network in an office run Access — and all can open the same database at the same time.
If you're looking for detailed explanations or in-depth examples, the Dummies series is not the right place for you. Crosstab queries help you analyze the information in your tables by summarizing how many records contain specific combinations of values. An Access database can contain lists of records about almost anything, from sales to sports scores. When your database gets large, you can change your mind. Instead, you see tabs at the top of the window, and a bunch of buttons.
For example, you can open a table in Design view to design the fields that make up the table, or you can open it in Datasheet view to enter and edit the data in the table. Sometimes you just gotta do things such as make backup copies of your information, or get other people to help you with boring stuff such as typing information into your tables. When all objects are assigned to groups, you may choose to hide the Unassigned Objects group. But you can easily flip back a few pages and locate the definition amidst all the other words on the page. A table is an Access object that is made up of a series of records — the electronic equivalent of the index cards that make up an address list. Where to Go from Here If you patiently read the preceding Organization section, you probably know where you need to go next. It was more of a database when I had to do students files for faculty member than this I am seeing in this book which looks a bit user-friendly.
Click the drop-down list arrow on the Navigation pane title bar to see the grouping options shown in Figure 2-3. Instead, we chose what we think are the most important database-management tasks, and we show you the best way — at least in our opinions — to do each one. Figure 1-1 shows a table of names and addresses. You see Backstage View, shown in Figure 2-1. If you see an alarming security message, check out the relevant nearby sidebar, Security Warning: Certain content in this database has been disabled. Sorting objects in the Navigation pane You can sort objects within a group in the Navigation pane by right-clicking the title bar of the Navigation pane or the empty space at the bottom of the Navigation pane, and then choosing from the Sort By menu. I rarely use this program at past administrative jobs I had but just wanted to browse through and see the updated changes since I last had to use it.
We also assume you know what those key+key symbols, such as Ctrl+Esc, mean. To protect you, Access opens the database, turns off the capability to execute code, and displays a warning. Like forms, reports display information from tables; you get to choose the layout of the information. Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know. With over 600 pages of content and dozens of review questions, this reference will help you ace your exam and serve as a valuable resource throughout your career. Some databases display a form and hide the Navigation pane.
Queries can also create calculated fields, including totals, counts, and averages. Abstract: A friendly, step-by-step guide to the Microsoft Office databaseapplication Access may be the least understood and most challengingapplication in the Microsoft Office suite. The familiar way to group database objects is by object type, but there are other choices also. Click, of course, means rest the mouse pointer on the item, and then tap the left mouse button. We also put little icons pictures in the left margin to point out text that you can maybe skip over.
A friendly, step-by-step guide to the Microsoft Office database application Access may be the least understood and most challenging application in the Microsoft Office suite. You may want all of the most popular programs in a Microsoft Office software package, including Word®, Excel®, PowerPoint® and OneNote®. So I am trying to figure out early on why they are saying 2010 when it should be 2007. In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It's not quite as user-friendly as MacDonald's book, but still a useful reference. Access comes with report wizards that make creating fancy reports easy. Look for Microsoft Access to help you quickly build convenient apps for managing data, like contacts, customer billing or orders, without the need for programming knowledge.
In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. Or create a new category by clicking the Add Item button and giving your new category a name. Another type of query is the action query, which does something to the records you select — copy records from one table to another, make a change to all the records you select, delete records you select, that sort of thing. I have that open already! If the database is something you downloaded from an unknown, dubious source, leave the database content disabled, and look around it that way. A bookstore database for example can contain a Books table with title, publisher, price, and other information about each book , a Vendors table for companies from whom you buy books with company name, address, discount terms, and other information about each vendor , and maybe a Customers table of your regular customers with name, address, and other information.
You should not use the new-to-2010 features if you know you need to save the database in an older format. Microsoft Office 2010 comes jam-packed with features. These objects can store, display, and print your data, as well as contain programs you write. Anyway, when writing instructions for a computer, you really have to spell it out for them, right down to the blank spaces between words. Displaying data in lots of different formats is where Access shines. Be sure to review all of our additional , including. Now the Navigation pane should contain subheadings for tables, queries, and other types of Access objects.