powerpoint presentation on ms access 2010

• My presentations

Auth with social network:

Download presentation

We think you have liked this presentation. If you wish to download it, please recommend it to your friends in any social system. Share buttons are a little bit lower. Thank you!

Presentation is loading. Please wait.

To view this video please enable JavaScript, and consider upgrading to a web browser that supports HTML5 video

INTRODUCTORY MICROSOFT ACCESS Lesson 1 – Access Basics

Published by Roxana Udy Modified over 10 years ago

Similar presentations

Presentation on theme: "INTRODUCTORY MICROSOFT ACCESS Lesson 1 – Access Basics"— Presentation transcript:

The Advantage Series © 2004 The McGraw-Hill Companies, Inc. All rights reserved Working with Access Microsoft Office Access 2003 Chapter 1.

Microsoft Office 2010 Basics and the Internet

Microsoft Access.

1 After completing this lesson, you will be able to: Create a database. Create a table using the Table Wizard. Create and modify a table in Design view.

1 After completing this lesson, you will be able to: Create a new presentation using a design template. Enter text in the Slide pane. Create a new slide.

Objectives Start Publisher and identify parts of the Publisher screen.

INTRODUCTORY MICROSOFT ACCESS Lesson 6 – Integrating Access

Pasewark & Pasewark Microsoft Office XP: Introductory Course 1 INTRODUCTORY MICROSOFT ACCESS Lesson 3 – Creating and Modifying Forms.

Computer Concepts BASICS 4th Edition

Access 2007 ® Use Databases How can Microsoft Access 2007 help you to get and stay organized?

Jeopardy Objects Navigation Buttons True/False Parts of a Report Vocabulary Q $100 Q $200 Q $300 Q $400 Q $500 Q $100 Q $200 Q $300 Q $400 Q $500 Final.

Word Lesson 1 Microsoft Word Basics

Pasewark & Pasewark Microsoft Office XP: Introductory Course 1 INTRODUCTORY MICROSOFT ACCESS Lesson 4 – Finding and Ordering Data.

Pasewark & Pasewark Microsoft Office XP: Introductory Course 1 INTRODUCTORY MICROSOFT ACCESS Lesson 5 – Reports and Macros.

Access Lesson 2 Creating a Database

Microsoft Access 2003 Introduction To Microsoft Access 2003.

Office 2003 Introductory Concepts and Techniques M i c r o s o f t Access Project 1 Creating and Using a Database.

XP New Perspectives on Microsoft Office Access 2003, Second Edition- Tutorial 1 1 Microsoft Access 2003 Tutorial 1 – Introduction To Microsoft Access 2003.

Pasewark & Pasewark 1 Access Lesson 4 Creating and Modifying Forms Microsoft Office 2007: Introductory.

Access Lesson 4 Creating and Modifying Forms

About project

© 2024 SlidePlayer.com Inc. All rights reserved.

• Get started with computers
• Learn Microsoft Office
• Apply for a job
• Improve my work skills
• Design nice-looking docs
• Getting Started
• Smartphones & Tablets
• Typing Tutorial
• Online Learning
• Basic Internet Skills
• Online Safety
• Social Media
• Zoom Basics
• Google Docs
• Google Sheets
• Career Planning
• Resume Writing
• Cover Letters
• Job Search and Networking
• Business Communication
• Entrepreneurship 101
• Careers without College
• Job Hunt for Today
• 3D Printing
• Freelancing 101
• Personal Finance
• Sharing Economy
• Decision-Making
• Graphic Design
• Photography
• Image Editing
• Learning WordPress
• Language Learning
• Critical Thinking
• For Educators
• Translations
• Staff Picks
• English expand_more expand_less

PowerPoint 2010  - Getting Started with PowerPoint

Powerpoint 2010  -, getting started with powerpoint, powerpoint 2010 getting started with powerpoint.

PowerPoint 2010: Getting Started with PowerPoint

Lesson 1: getting started with powerpoint, introduction.

PowerPoint 2010 is a presentation software that allows you to create dynamic slide presentations that can include animation, narration, images, and videos. In this lesson, you will learn your way around the PowerPoint 2010 environment , including getting to know the new Backstage view .

We will also show you how to use and modify the Ribbon and the Quick Access toolbar , in addition to learning how to create new presentations and open existing files .

Getting to know PowerPoint 2010

If you are familiar with PowerPoint 2007, you'll notice that there aren't too many changes to the 2010 interface other than Backstage view , which we'll cover later in this lesson.

However, if you are new to PowerPoint, you will first need to take some time to learn about slides and how to navigate PowerPoint .

Navigating PowerPoint to create a slide presentation

PowerPoint uses slides to build a presentation . To create an engaging presentation, PowerPoint allows you to add text, bulleted lists, images, charts, and video to your slides. You can add as many slides as you want to a presentation, and at any time you can view or play back your presentation by selecting one of the slide show play options.

Click the buttons in the interactive below to learn how to navigate and interact with slides in the PowerPoint window.

Quick Access Toolbar

The Quick Access toolbar lets you access common commands no matter which tab you are on in the Ribbon. By default, it shows the Save , Undo , and Repeat commands. You can add other commands to make it more convenient.

Zoom Control

Click and drag the slider to use the Zoom control. The number to the left of the slider bar reflects the zoom percentage.

You can also choose the Fit slide to current window button.

Slide Views

Adjust your slide view by choosing one of the following:

• Normal view is selected by default and shows the Slide and Outline tabs, along with displaying the current slide.

• Slide Sorter view displays smaller versions of all of the slides in the presentation.

• Reading view displays only the slides with buttons at the bottom of the screen for navigation.

• Slide Show will play your slides as an actual presentation.

You can also navigate your slide show by clicking and dragging the scroll bar or by selecting the Previous Slide and Next Slide arrows.

Outline Tab

The Outline tab conveniently displays the text content of each slide. You can edit your text directly from the outline view.

The Slides tab allows you to view and work with the slides in your presentation. You can add , delete , duplicate , and rearrange slides in the Slides tab. You can also add sections to the Slides tab to organize and divide your slides.

The Ribbon contains all of the commands you will need in order to perform common tasks. It has multiple tabs, each with several groups of commands, and you can add your own tabs to customize your favorites.

In addition, special tools tabs will appear when you're formatting certain items, like images and tables.

Working with your PowerPoint environment

The Ribbon and Quick Access toolbar are where you will find the commands you need to perform common tasks in PowerPoint. If you are familiar with PowerPoint 2007, you will find that the main difference in the PowerPoint 2010 Ribbon is that commands such as Open and Print are now housed in Backstage view .

The Ribbon contains multiple tabs , each with several groups of commands. Some tabs, like Drawing Tools or Table Tools , may appear only when you are working with certain items like images or tables. In addition, you can add your own customized tabs that contain your favorite commands.

Certain programs, such as Adobe Acrobat Reader , may install additional tabs to the Ribbon. These tabs are called add-ins .

To customize the Ribbon:

You can customize the Ribbon by creating your own tabs that house your desired commands. Commands are always housed within a group , and you can create as many groups as you need to keep your tabs organized. You can even add commands to any of the default tabs, as long as you create a custom group within the tab.

• Click New Tab . A new tab will be created with a new group inside it.
• Make sure the new group is selected.
• Select a command from the list on the left, then click Add . You can also drag commands directly into a group.

If you do not see the command you want, click on the Choose commands drop-down box and select All Commands .

To minimize and maximize the Ribbon:

The Ribbon is designed to be easy to use and responsive to your current task; however, if you find it is taking up too much of your screen space, you can minimize it.

• To maximize the Ribbon, click the arrow again.

When the Ribbon is minimized, you can make it reappear by clicking a tab. However, the Ribbon will disappear again when you are not using it.

The Quick Access toolbar

The Quick Access toolbar , located above the Ribbon, lets you access common commands no matter which tab you are on. By default, it shows the Save , Undo , and Repeat commands. You can add other commands to make it more convenient.

To add commands to the Quick Access toolbar:

• Click the drop-down arrow to the right of the Quick Access toolbar .

Backstage view

Backstage view gives you various options for saving, opening, printing, and sharing your presentation. It is similar to the Microsoft Office button menu from PowerPoint 2007 and the File Menu from earlier versions of PowerPoint. However, instead of just a menu it's a full-page view, which makes it easier to work with.

To get to Backstage view:

• You can choose an option on the left side of the page.
• To get back to your document, click any tab on the Ribbon.

Click the buttons in the interactive below to learn about the different things you can do in Backstage view.

Save, Save As, Open, and Close

Familiar tasks such as Save , Save As , Open , and Close are now found in Backstage view.

Info contains information on the current presentation. You can also inspect your presentation and edit its permissions from this pane.

The Recent pane allows you to conveniently access recent presentations and file folders .

From here, you can create a new blank presentation , or you can choose from a large selection of templates .

From the Print pane, you can change the print settings and print your presentation. You can also see a preview of how your presentation will look on the page.

Save & Send

Save & Send provides options for you to share your presentation and change its file formats . In addition, you can create a video , CD , or handouts of your presentation from here.

From the Help pane, you can access Microsoft Office Help or check for updates for your software.

Here, you can change various PowerPoint options . For example, you can adjust the spelling and grammar check settings, AutoRecover settings, and Language preferences.

Creating and opening presentations

PowerPoint files are called presentations . When you start a new project in PowerPoint, you'll need to create a new presentation . You'll also need to know how to open an existing presentation .

To create a new blank presentation:

• Click the File tab. This takes you to Backstage view .
• Select New .
• Select Blank presentation under Available Templates and Themes . It will be highlighted by default.

To save time, you can create your presentation from an Office.com template , which you can also select under Available Templates and Themes .

To open an existing presentation:

• Select your desired presentation, then click Open .

If you have opened the existing presentation recently, it may be easier to choose Recent from the File tab instead of Open to search for your presentation.

Compatibility mode

Sometimes you may need to work with presentations that were created in earlier versions of PowerPoint, such as PowerPoint 2003 or PowerPoint 2000. When you open these types of presentations, they will appear in Compatibility mode .

Compatibility mode disables certain features, so you'll only be able to access commands found in the program that was used to create the presentation. For example, if you open a presentation created in PowerPoint 2003, you can only use tabs and commands found in PowerPoint 2003.

In the image below, the workbook has opened in Compatibility mode. Many of the newer slide transitions have been disabled, and only the 2003 transitions are available.

To exit Compatibility mode, you'll need to convert the presentation to the current version type. However, if you're collaborating with others who only have access to an earlier version of PowerPoint, it's best to leave the presentation in Compatibility mode so the format will not change.

To convert a presentation:

If you want access to all PowerPoint 2010 features, you can convert the presentation to the 2010 file format.

Note that converting a file may cause some changes to the original layout of the presentation.

• Click the File tab to access Backstage view.

• The presentation will be converted to the newest file type.
• Open PowerPoint 2010 on your computer. A new blank presentation will appear on the screen.
• Try minimizing and maximizing the Ribbon.
• Click through all of the tabs , and notice how the Ribbon options change.
• Try switching page views .
• Add any commands you want to the Quick Access toolbar .
• Close PowerPoint without saving the presentation.

/en/powerpoint2010/slide-basics/content/

MS ACCESS 2010

Mar 19, 2019

370 likes | 555 Views

MS ACCESS 2010. What is Database?. A database is a collection of data that is organized so that its contents can easily be accessed , managed, and updated. EXAMPLES OF DATABASES. What is Access?. ACCESS is a relational database management system.

Share Presentation

• date time fields
• report extracts selected data

Presentation Transcript

What is Database? • A database is a collection of data that is organized so that its contents can easily be accessed, managed, and updated.

EXAMPLES OF DATABASES

What is Access? • ACCESS is a relational database management system. • Relational databases allow you to organize your data into tables • Each table focuses on a specific topic; the various tables can then be linked to each other for inquiry and reporting purposes.

Database Objects

Database Objects • Microsoft Access uses four objects to create a Database: • Tables • Queries • Forms • Reports

Table • A table is the basic element of a Database and contains the data entered by users. • Each row (or record) contains information about a particular item (e.g., an employee). • The record is made up of several fields; each field contains one piece of information relating to the item (e.g., employee's name, address, phone, etc.).

Query • A query extracts selected data from a table (or another query) and presents it in spreadsheet format.

Form • A form is a graphical template based on a table (or query). • It is used to enter new data into the database or display existing data.

Report • A report extracts selected data from a table (or query) and formats it for printing.

What is a Table? • A table is a database object used to store, organize and view data. All other objects are based on the data stored in tables. • Tables are comprised of: • Fields - represented by columns • Records - stored as rows.

Text • Any character (alpha, special characters, numbers) • Up to 255 in length • Numbers cannot be used for calculations

Memo • Any character (alpha, special characters, numbers) • Up to 65,000 in length • Numbers cannot be used for calculations • Field cannot be sorted or indexed

Number • Numeric data to be used for mathematical calculations • Not to be used for currency fields • Field Size property further defines its function and size

Date/ time • Must be a valid date/time entry at entry time • Format property determines display format

Currency • Accepts monetary values with a dollar sign and decimal point. • It can be used for computations

Lookup • Creates a field that lets you look up a value from another table or from a list of values.

Attachment • Stores graphics, sound and other types of files attachments.

Hyperlinks • Stores a value that contains a hyperlink. • Clicking the value activates the link and opens a webpage or addresses a message to an email address.

Yes/No • Stores Yes/No, True/False or On/Off Values

Auto Number • Adds a unique numeric field value to each record in a table.

Calculated • Opens the Expression builder dialog box which lets you specify fields and operators to use in calculations.

Field Properties

Field Size • Sets a maximum size for data • Varies according to Data Type:

Input Mask • Controls the way data is entered; frequently used for telephone numbers, postal codes, SSN #’s, date/time fields. • ACCESS offers a Wizard for text and date/time data types.

Caption • You specify text for the label attached to a field; • Will be used as the column heading when displaying tables, queries and reports. • The default value is Field Name.

Default Value • Specifies a value that will be automatically entered when you create a new record.

Input Mask Characters

Primary Key • The primary key of a relational table uniquely identifies each record in the table. • It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person.

• More by User

Marina G. Erechtchoukova. 2. MS Access . Relational data modelData is stored in tables incorporated into database files with extension mdb" or accdb"Standard Windows interfaceStandard Help systemPart of MS Office suite . Marina G. Erechtchoukova. 3. Access Database Objects. Tables contain rows

817 views • 24 slides

MS Access 2003

MS Access 2003. Database Basics. Definitions. Database Relational database Table Record Field Primary key. Definitions continued. Form Report Query. Field types. Text (255 characters) Memo (64,000 characters) Number Currency Date/Time AutoNumber Yes/No OLE Object Hyperlink

283 views • 7 slides

MS Access 2007

MS Access 2007. Management Information Systems. Overview. What is MS Access? Access Terminology Access Window Database Window Create New Database Setting Field Properties Create New Query in Database Relational Database Management System Creating Forms in Database

597 views • 38 slides

MS ACCESS 2010. Introduction to Databases. Instructional Objectives. Students should be able to: Create a blank database Set up the tables Populate tables with data Maintain data in tables Add, update, delete Create queries, forms, and reports Other topics as time permits.

412 views • 25 slides

MS-Access XP

MS-Access XP. Lesson 5. Creating a Query with Expression Builder. Eg. Consider the following table. Table Name: Overtime Fields & Data types: Emp No (Number), OT Hours (Number) OT rate per hour for each employee is Rs. 30.

155 views • 10 slides

MS Access Advanced

MS Access Advanced. Instructor: Vicki Weidler Assistant:. Overview. Create PivotTables and PivotCharts Build forms based on joined tables Automate data entry Use grouped controls Design subforms Create and run macros Write simple SQL statements

524 views • 47 slides

Intermediate MS Access

Intermediate MS Access. Instructor: Vicki Weidler Assistant:. Unit 9: Creating Relational Databases. Overview. Normalize tables to reduce data redundancy Understand the requirements for first, second, third, fourth & fifth normal forms

795 views • 77 slides

MS Access. Database – collection of related data Relational Database Management System (RDBMS) – software that uses related data stored in different tables Table is made up of rows (records) and columns (fields) E.g. 7 records 3 fields. Basic steps to create a database.

210 views • 7 slides

MS-Access (database)

MS-Access (database). how to create blank data base. How to import CSV files. Book1. CSV How to make sure that our table has the same data type. How to change data type for any field How to fill new records. Reports: How to create report .

707 views • 10 slides

How To Get Free Access To Microsoft PowerPoint

E very time you need to present an overview of a plan or a report to a whole room of people, chances are you turn to Microsoft PowerPoint. And who doesn't? It's popular for its wide array of features that make creating effective presentations a walk in the park. PowerPoint comes with a host of keyboard shortcuts for easy navigation, subtitles and video recordings for your audience's benefit, and a variety of transitions, animations, and designs for better engagement.

But with these nifty features comes a hefty price tag. At the moment, the personal plan — which includes other Office apps — is at $69.99 a year. This might be the most budget-friendly option, especially if you plan to use the other Microsoft Office apps, too. Unfortunately, you can't buy PowerPoint alone, but there are a few workarounds you can use to get access to PowerPoint at no cost to you at all.

Read more: The 20 Best Mac Apps That Will Improve Your Apple Experience

Method #1: Sign Up For A Free Microsoft Account On The Office Website

Microsoft offers a web-based version of PowerPoint completely free of charge to all users. Here's how you can access it:

• Visit the Microsoft 365 page .
• If you already have a free account with Microsoft, click Sign in. Otherwise, press "Sign up for the free version of Microsoft 365" to create a new account at no cost.
• On the Office home page, select PowerPoint from the side panel on the left.
• Click on "Blank presentation" to create your presentation from scratch, or pick your preferred free PowerPoint template from the options at the top (there's also a host of editable templates you can find on the Microsoft 365 Create site ).
• Create your presentation as normal. Your edits will be saved automatically to your Microsoft OneDrive as long as you're connected to the internet.

It's important to keep in mind, though, that while you're free to use this web version of PowerPoint to create your slides and edit templates, there are certain features it doesn't have that you can find on the paid version. For instance, you can access only a handful of font styles and stock elements like images, videos, icons, and stickers. Designer is also available for use on up to three presentations per month only (it's unlimited for premium subscribers). When presenting, you won't find the Present Live and Always Use Subtitles options present in the paid plans. The biggest caveat of the free version is that it won't get any newly released features, unlike its premium counterparts.

Method #2: Install Microsoft 365 (Office) To Your Windows

Don't fancy working on your presentation in a browser? If you have a Windows computer with the Office 365 apps pre-installed or downloaded from a previous Office 365 trial, you can use the Microsoft 365 (Office) app instead. Unlike the individual Microsoft apps that you need to buy from the Microsoft Store, this one is free to download and use. Here's how to get free PowerPoint on the Microsoft 365 (Office) app:

• Search for Microsoft 365 (Office) on the Microsoft Store app.
• Install and open it.
• Sign in with your Microsoft account. Alternatively, press "Create free account" if you don't have one yet.
• Click on Create on the left side panel.
• Select Presentation.
• In the PowerPoint window that opens, log in using your account.
• Press Accept on the "Free 5-day pass" section. This lets you use PowerPoint (and Word and Excel) for five days — free of charge and without having to input any payment information.
• Create your presentation as usual. As you're using the desktop version, you can access the full features of PowerPoint, including the ability to present in Teams, export the presentation as a video file, translate the slides' content to a different language, and even work offline.

The only downside of this method is the time limit. Once the five days are up, you can no longer open the PowerPoint desktop app. However, all your files will still be accessible to you. If you saved them to OneDrive, you can continue editing them on the web app. If you saved them to your computer, you can upload them to OneDrive and edit them from there.

Method #3: Download The Microsoft PowerPoint App On Your Android Or iOS Device

If you're always on the move and need the flexibility of creating and editing presentations on your Android or iOS device, you'll be glad to know that PowerPoint is free and available for offline use on your mobile phones. But — of course, there's a but — you can only access the free version if your device is under 10.1 inches. Anything bigger than that requires a premium subscription. If your phone fits the bill, then follow these steps to get free PowerPoint on your device:

• Install Microsoft PowerPoint from the App Store or Google Play Store .
• Log in using your existing Microsoft email or enter a new email address to create one if you don't already have an account.
• On the "Get Microsoft 365 Personal Plan" screen, press Skip For Now.
• If you're offered a free trial, select Try later (or enjoy the free 30-day trial if you're interested).
• To make a new presentation, tap the plus sign in the upper right corner.
• Change the "Create in" option from OneDrive - Personal to a folder on your device. This allows you to save the presentation to your local storage and make offline edits.
• Press "Set as default" to set your local folder as the default file storage location.
• Choose your template from the selection or use a blank presentation.
• Edit your presentation as needed.

Do note that PowerPoint mobile comes with some restrictions. There's no option to insert stock elements, change the slide size to a custom size, use the Designer feature, or display the presentation in Immersive Reader mode. However, you can use font styles considered premium on the web app.

Method #4: Use Your School Email Address

Office 365 Education is free for students and teachers, provided they have an email address from an eligible school. To check for your eligibility, here's what you need to do:

• Go to the Office 365 Education page .
• Type in your school email address in the empty text field.
• Press "Get Started."
• On the next screen, verify your eligibility. If you're eligible, you'll be asked to select whether you're a student or a teacher. If your school isn't recognized, however, you'll get a message telling you so.
• For those who are eligible, proceed with creating your Office 365 Education account. Make sure your school email can receive external mail, as Microsoft will send you a verification code for your account.
• Once you're done filling out the form, press "Start." This will open your Office 365 account page.

You can then start making your PowerPoint presentation using the web app. If your school's plan supports it, you can also install the Office 365 apps to your computer by clicking the "Install Office" button on your Office 365 account page and running the downloaded installation file. What sets the Office 365 Education account apart from the regular free account is that you have unlimited personal cloud storage and access to other Office apps like Word, Excel, and Outlook.

Read the original article on SlashGear .

Microsoft 365 Basic now includes ransomware protection for your files and photos at no extra cost.

Use Word, Excel, PowerPoint and more for free on the web

Office is now Microsoft 365

Get the free Microsoft 365 mobile app*

Start using Microsoft 365 today

Anywhere access

Whether you’re at work or on the go, create your best work on your favorite browser.

Familiar experience

The familiar Microsoft 365 experience you know and trust, so there’s nothing new to learn.

Work with anyone

Share your documents with anyone and work together in real-time.

Word for the web

Craft great-looking resumes, newsletters, and documents while inviting others to review and coauthor in real time. Plus, access free Word templates, formatting tools for APA, MLA, and Chicago style, and add functionality with free add-ins.

Excel for the web

Organize your data in familiar spreadsheets and workbooks, with all changes saved automatically. Create modern visuals that turn numbers into valuable insights. Work together in real time knowing that everyone is on the same page.

PowerPoint for the web

Turn your ideas into compelling presentations using professional-looking templates. Use animations, transitions, photos, and videos to tell one-of-a-kind stories. Co-author team presentations at the same time, from anywhere.

Start now at Microsoft365.com

No installation required. It's free.

* Availability of mobile apps varies by country/region.

Follow Microsoft 365

• Chat with sales
• Contact sales

Available M-F 9 AM to 6 PM.