Sidebar: Exporting Information to PDF and XPS Files. .. Microsoft Office Access is a powerful relational database application that. Move the mouse pointer Chapter 3 Getting Help from Office In This Chapter ᮣ Opening and browsing the Help Microsoft office for. with Office , Microsoft added its most important feature ever — making . with Office on a “dummy” document filled with useless information you.

Microsoft Access 2007 For Dummies Pdf

Language:English, Arabic, Hindi
Country:Cape Verde
Genre:Academic & Education
Published (Last):12.01.2016
ePub File Size:15.36 MB
PDF File Size:20.40 MB
Distribution:Free* [*Registration needed]
Uploaded by: ELVIA

Bible and Access Workbook For Dummies. He's also developed course- ware in Access and VBA and has been on the speaker circuit for Microsoft. Access. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, Word is a part of the Microsoft Office suite of programs. Download free Microsoft Access Tutorial course material and training, PDF file on 49 pages.

Jean Rogers Acquisitions Editor: Bob Woerner Senior Copy Editor: Teresa Artman Technical Editor: Lee Musick Editorial Manager: Kevin Kirschner Media Development Specialists: Kristie Rees Layout and Graphics: David Faust, Techbooks Indexer: Techbooks Anniversary Logo Design: Richard Pacifico Media Development Coordinator: Laura Atkinson Media Project Supervisor: Laura Moss Media Development Manager: Richard Graves Editorial Assistant: Amanda Foxworth Sr.

Editorial Assistant: Cherie Case Cartoons: Rich Tennant www. Contents at a Glance Introduction Getting to Know Microsoft Office Editing Data Getting Help from Office Working with Word Typing Text in Word Formatting Text Designing Your Pages Playing the Numbers with Excel The Basics of Spreadsheets: Numbers, Labels, and Formulas Playing with Formulas Charting and Analyzing Data Making Presentations with PowerPoint Creating a PowerPoint Presentation Adding Color and Pictures to a Presentation Showing Off a Presentation Getting Organized with Outlook Organizing E-Mail with Outlook Storing Contacts and Organizing Tasks Scheduling Your Time Storing Stuff in Access Using a Database Searching, Sorting, and Querying a Database Creating a Database Report The Part of Tens Ten Tips for Using Office Ten Keystroke Shortcuts for Office Table of Contents Introduction Editing Data.

Typing Text in Word. Formatting Text. Table of Contents Adjusting Line Spacing Designing Your Pages. Numbers, Labels, and Formulas. Table of Contents Inserting and removing page breaks Playing with Formulas. Charting and Analyzing Data. Creating a PowerPoint Presentation. Adding Color and Pictures to a Presentation. Showing Off a Presentation. Table of Contents Adding Hyperlinks Organizing E-Mail with Outlook.


Storing Contacts and Organizing Tasks. Scheduling Your Time. Using a Database. Searching, Sorting, and Querying a Database. Table of Contents Querying a Database Creating a Database Report.

Introduction M icrosoft Office contains loads of new features. Unfortunately, finding — let alone using — these new features can be troublesome. So, with Office , Microsoft added its most important feature ever — making the programs easier to use.

First, there are the people already familiar with Microsoft Office who want to bone up on the new ways that Office works. For these people, this book can serve as a handy reference to finding where Microsoft put various commands in the new Office user interface. For these people, this book can serve as a guide through word processing Microsoft Word , number calculations Microsoft Excel , presentations Microsoft PowerPoint , database management Microsoft Access , and managing your personal resources like time, appointments, and e-mail Microsoft Outlook.

No matter how much or how little you may know about Microsoft Office, this book introduces you to the most common features so you can start being productive with Office right away.

Get smarter in just five minutes

How This Book Is Organized To help you find what you need, this book is organized into parts where each part covers a different program in Office This part of the book explains the new Office menus and toolbars while also showing you common commands that you can use in any Office program.

Part II: Working with Word Word processing is the most popular use for Office , so this part of the book explains the basics to using Word. Not only does this part of the book explain how to create and save text, but it also covers different ways to alter text, such as using color, changing fonts, adding headers and footers, checking spelling and grammar, and printing your written masterpiece so it looks perfect.

Part III: This part of the book explains the three basic parts of any spreadsheet, how to format data, how to create formulas, and how to create different types of charts to help you visualize what your spreadsheet numbers really mean.

Not only will this part of the book give you the lowdown on spreadsheets, but it shows you how Microsoft Excel can make creating, formatting, and displaying spreadsheets simple and easy — and most importantly, useful and fun. Part IV: Making Presentations with PowerPoint Throw away your overhead transparencies and clumsy whiteboard and pads of paper. If you need to give a presentation to a large group, you need to know how to create colorful and visually interesting presentations using PowerPoint instead.

With PowerPoint, you can organize a presentation into slides that can display text, pictures, and even animation. By mastering Part V: Getting Organized with Outlook Almost nobody feels like they have enough time to stay organized, so this part of the book explains why and how to use Microsoft Outlook.

With Outlook, you can read, sort, and write e-mail, keep track of appointments, store names and addresses of your most important contacts, and even organize your daily to-do tasks. By reading about how to use Outlook in this part of the book, you can see how to turn your computer into a personal assistant to make you more productive.

Part VI: Storing Stuff in Access If you need to store large amounts of information, such as tracking inventories, organizing customer orders, or tracking prospective customers, you may need to use a database program like Microsoft Access. With Access able to slice and dice your information, you can better analyze your data to understand how your business really works. Part VII: The Part of Tens Almost every program offers multiple ways of accomplishing the same task, and Office is no exception.

After you get familiar with using Office, take a peek in this part of the book to read about different types of shortcuts you can use to work with Office even faster than before.

This part of the book also offers tips for using Office to make the programs even easier and more useful. How to Use This Book Although you can just flip through this book to find the features you need, consider reading Part I of this book to discover how the new menus and toolbar icons of Office work and how they differ from previous versions of 3 Conventions To get the most from this book, you need to understand the following conventions: First, you use the mouse pointer to select data text, numbers, e-mail messages, and so on to change.

Second, you use the mouse pointer to tell Office which commands you want to use to change the data you selected.

Was this information helpful?

Dragging typically moves something from one location to another, such as moving a word from the top of a paragraph to the bottom. Right-clicking typically displays a shortcut menu of additional options. In addition to understanding these terms to describe different mouse actions, you also need to understand different keystroke conventions too.

Icons Used in This Book Icons highlight important or useful information. This icon highlights information that can save you time or make it easier for you to do something. Introduction This icon emphasizes information that can be helpful, although not crucial, when using Office Look out! This icon highlights something dangerous that you need to avoid before making a mistake that you might not be able to recover from again.

This icon highlights interesting technical information that you can safely ignore but which might answer some questions for why Office works a certain way.

Getting Started The best way to master anything is to jump right in and start fiddling with different commands just to see what they do and how they work. Just hold down the Ctrl key, press the Z key, and release both keys at the same time.

Mastering Office is going to be easier than you think. A In this part. But after you get over your initial impression or fear of Office, you can understand and even admire the elegant madness behind its massive bulk. Despite the fact that Microsoft Office contains more commands than any sane person could ever possibly use, it can be conquered. Perhaps the most important part of this book explains the completely redesigned user interface of Microsoft Office To guide you through the multitude of commands you may need to get your work done, Office provides several ways to get help, one of which hopefully will actually provide you with the answers you need.

Besides showing you how to get help within Office, this part of the book also explains how to get the various programs of Office started in the first place. After you start using Office, this part of the book also shows you some of the more common keystroke and menu commands that all Office programs share. That way when you figure out how to use one Office program, you can quickly learn and use any other Office program with a minimum of retraining and hassle, and you can then join the ranks of the many happy people already using Microsoft Office to get their work done.

Each of these core programs specializes in manipulating different data. Word manipulates words, sentences, and paragraphs; Excel manipulates numbers; PowerPoint manipulates text and pictures to create a slide show; Access manipulates data, such as inventories; and Outlook manipulates personal information, such as e-mail addresses and phone numbers.

Although each Office program specializes in storing and manipulating different types of data, they all work in similar ways. First, you have to enter data into an Office program by typing on the keyboard or loading data from an existing file.

Second, you have to tell Office how to manipulate your data, such as underlining, enlarging, coloring, or deleting it.

Third, you have to save your data as a file. To help you understand this three-step process of entering, manipulating, and saving data, Office offers similar commands among all its programs so you can quickly jump from Word to PowerPoint to Excel without having to relearn entirely new commands to use each program. Even better, Office rearranges its numerous commands so finding the command you need is faster and easier than ever before.

Loading an Office Program The first step to using Office is loading the program you want to use. To load any Office program, follow these steps: Click the Start button on the Windows taskbar. A pop-up menu appears. Choose All Programs. Another pop-up menu appears. Choose Microsoft Office. A list of programs appears on the Start menu, as shown in Figure Figure You can find every Office program from the Start menu.

Chapter 1: Getting to Know Microsoft Office 4. Your chosen program appears on the screen. This new user interface consists of three parts, as shown in Figure The three parts of the new Microsoft Office user interface.

Ribbon 11 In Word, a file is called a document. In Excel, a file is called a workbook. In PowerPoint, a file is called a presentation. In Access, a file is called a database. In previous versions of Office, the File menu was clearly labeled File. In Office , the File menu appears when you click the Office Button in the upper-left corner refer to Figure Creating a new file When you first load an Office program, it automatically creates an empty file for you to use right away. Click the Office Button.

A drop-down menu appears, as shown in Figure The Office Button menu displays different commands for opening, creating, or closing your files. Getting to Know Microsoft Office 2. Choose New. A New dialog box appears, as shown in Figure A New dialog box lets you create a blank file or use an existing template.

A blank file appears ready for you to start storing data in it. Creating a new file from a template Rather than create a blank file, you may find it easier to use a template instead. A template contains predefined formatting for creating different types of files easily, such as calendars, newsletters, sales reports, or a corporate slide show presentation. Office provides three types of templates: To use one of these templates, follow these steps: Click the Office Button and choose New.

A New window appears refer to Figure Click Installed Templates. The New window displays all the installed templates on your computer. Click the template you want to use and then click the Create button. Office creates a new file based on your chosen template. To retrieve these templates, you need to connect to the Internet and then follow these steps: Click the Office Button and then choose New.

The New window displays all the templates available from the Microsoft Web site, as shown in Figure Getting to Know Microsoft Office 3. Click the template you want to use and then click the Download button. Office downloads and creates a new file based on your chosen template. To open an existing file, you need to tell Office the location and name of the file you want to open.

Just follow these steps: Click the Office Button and then choose Open. An Open dialog box appears, as shown in Figure The Open dialog box lets you change drives and folders to find the file you want to use.

Optional To choose a different drive to look for files, click Computer under the Favorite Links panel see the left side of Figure Then click the drive where you want to load the file, such as the C: Optional Click a folder and then click Open to search for a file inside a folder. Repeat this step as many times as necessary. Click the file you want to open and then click Open.

Your chosen file appears ready for editing.

Getting to Know Microsoft Office When you click the Open command under Microsoft Word, Excel, PowerPoint, and Access, an additional window appears to the right that contains a list of the last files you opened.

Saving files Saving a file stores all your data on a hard disk or other storage device such as a Compact Flash card. The first time you save a file, you need to specify three items: By default, Office stores all your files in the Documents folder. The format of your file defines how Office stores your data. The default file format is known as Office format, which simply means that only people with Office can reliably open and view the contents of that file.

A drop-down menu appears. Click Save. Getting to Know Microsoft Office Figure The Save As dialog box lets you choose the name, file format, and a location to save your file. Optional To specify a drive and folder to save your file, click Browse Folders.

This causes the dialog box to expand, as shown in the bottom dialog box in Figure Now you can click Computer, under Favorite Links, and then click a folder. Or, click the New Folder button; when the New Folder dialog box appears, type a name for your new folder and then click OK.

Click in the File Name text box and type a descriptive name for your file. Getting to Know Microsoft Office Saving a file for older versions of Microsoft Office If you need to share files with people using older versions of Microsoft Office, you need to save your files in a different file format known as , such as Word Document or PowerPoint Presentation.

When you save files in the format, Microsoft Office saves your files with a three-letter file extension, like. When you save files in the Office format, Microsoft Office saves your files with a four or five-letter file extension, such as. Click the Office Button and then choose Save As. A Save As dialog box appears. Click in the Save as Type list box. A list of different formats appears, as shown in Figure Choose the format option, such as Word Format or Excel Format.

Most programs can accept files stored in the format, but many older programs cannot, so you may have to resort to saving a file in one of these other formats instead.

The Save as Type list box lets you choose a file format for saving your file. Optional Click in the File Name text box and type a descriptive name for your file.

Microsoft Word 2007 for Dummies.pdf

Closing a file simply removes the file from your screen but keeps your Office program running so you can edit or open another file. To close a file, follow these steps: Click the Office Button and then choose Close. Click Yes to save your changes, No to discard any changes, or Cancel to keep your file open. If you click either Yes or No, Office closes your file. Using the Quick Access toolbar The Quick Access toolbar appears to the right of the Office Button refer to Figure near the top of the screen, displaying icons that represent commonly used commands such as Save, Undo, and Redo as shown in Figure If you click the Print icon in the Quick Access toolbar, Office immediately prints one copy of your entire file through the default printer.

If you want to specify a different printer to use, the number of copies to print, or specific pages to print, click the Office Button and choose Print instead. The Redo icon reverses the last Undo command you chose. For example, if you delete a paragraph, Office makes that paragraph disappear. Then if you immediately click the Undo icon, the paragraph magically reappears. If you immediately click the Redo icon, the Redo command reverses the Undo command and deletes the paragraph once more.

The Undo icon is unique in that it offers two ways to use it. First, you can click the Undo icon to undo the last action you chose.

Second, you can click the downward-pointing arrow that appears to the right of the Undo icon to display a list of one or more of your previous actions, as shown in Figure The Undo icon displays a list of actions you can undo. Getting to Know Microsoft Office The most recent action you chose appears at the top of this list, the second most recent action appears second, and so on.

To undo multiple commands, follow these steps: Click the downward-pointing arrow that appears to the right of the Undo icon in the Quick Access toolbar. Move the mouse pointer to highlight one or more actions you want to undo.

Click the left mouse button.

A Beginner’s Guide to Microsoft Office

Office undoes all the multiple actions you selected. Adding icons The Quick Access toolbar is designed to put your most commonly used commands where you can always find them. To add other icons to the Quick Access toolbar, follow these steps: A pull-down menu appears. You can add an icon to the toolbar by just clicking on an icon name, such as Quick Print or New, from the pull-down menu.

Click More Commands. An Options window appears, as shown in Figure The panel on the right shows all the current icons on the Quick Access toolbar. The panel on the left shows all the additional icons you can add. The Options window lets you select the icons you want to add to the Quick Access toolbar. The left panel displays a list of icons and commands. Click an icon and then click the Add button.

Optional Repeat Steps 3 and 4 for each additional icon you want to add to the Quick Access toolbar. Click OK.

Your chosen icon or icons now appears on the Quick Access toolbar. Removing icons You can remove icons from the Quick Access toolbar at any time. All you need to do is download the course and open the PDF file. This specific program is classified in the Database category where you can find some other similar courses.

Thanks to people like you? Who share their knowledge, you can discover the extent of our being selected to easily learn without spending a fortune! Microsoft Access Tutorial. But also many other tutorials are accessible just as easily! Computer PDF guide you and allow you to save on your studies. You should come see our Database documents.

You will find your happiness without trouble! The latest news and especially the best tutorials on your favorite topics, that is why Computer PDF is number 1 for courses and tutorials for download in pdf files - Microsoft Access Tutorial.

Download other tutorials for advice on Microsoft Access Tutorial. We will do everything to help you! And you dear surfers what you need? The best course and tutorial, and how to learn and use Microsoft Access Tutorial.A New dialog box lets you create a blank file or use an existing template. Laura Moss Media Development Manager: Each tab displays a different group of related commands.

A list of programs appears on the Start menu, as shown in Figure Tip: To create a shortcut to.

Just kidding! Office removes your selected icon from the Quick Access toolbar. The Windows Clipboard can store only one item. We will do everything to help you! Browsing the Help Window Each Office program comes with its own help files that you can access at any time.