powerpoint presentation on ms access 2010

Microsoft Access 2010 Overview of Microsoft Access Databases

Apr 05, 2019

260 likes | 565 Views

Microsoft Access 2010 Overview of Microsoft Access Databases. Chapter 1. Chapter Overview. Introduction Database Hierarchy Database Objects Tables, Queries, Forms, Reports, Macros and Modules Relational Databases. We Remember…. 10% of what we read 20% of what we hear

Share Presentation

• report view
• guided exercise
• relational database design
• older versions
• delete records

Presentation Transcript

Microsoft Access 2010Overview of Microsoft Access Databases Chapter 1

Chapter Overview • Introduction • Database Hierarchy • Database Objects • Tables, Queries, Forms, Reports, Macros and Modules • Relational Databases

We Remember…. • 10% of what we read • 20% of what we hear • 30% of what we see and hear • 50% of what we see someone do while explaining it • 90% of what we do ourselves

Learning Objectives • Microsoft Access • General Database Concepts • Relational Database Design • Application Development

Database Concepts • Data versus Information • Database hierarchy • Database (DBMS) • Table • Records (Rows) • Fields (Columns)

Commercial Systems • Oracle • Ingres • Informix (Unix) • DB2, SQL/DS (IBM) • Access (Microsoft) • SQL Server (Microsoft +) • Many older (Focus, IMS, ...) • Many limited PC (dBASE, Paradox, …)

Microsoft Access • Access 2007 and 2010 databases end with .accdb file extension – for example, sales.accdb • Databases made in older versions of Access have the file extension .mdb • NEVER remove a disk or flash drive until Access is completely shut down.

Database Objects • Tables – Ch. 2 • Forms – Ch. 3 • Queries – Ch. 4 • Reports – Ch. 5 • Macros – Ch. 7 • Modules (VBA) – Not covered

Tables • Store the data in a database – similar to a spreadsheet, but more organized. Contains records (rows) and fields (columns). • Datasheet View versus Design View • Field Properties – input mask, validation rule, data type, format, primary key, etc.

Queries • Allow you to ask questions (queries) about data in the database to extract information. • When have customers placed orders? • What products in inventory haven’t sold well?

Forms • Forms are used for entering data, displaying data or for building a menu system. • Basic Forms, Split Forms, Multiple Item Forms, Subforms • Form, Layout and Design View

Reports • Used to format and present the data in a professional, logical and useful manner. Often intended for printing and distribution. Can be built from tables or queries. • Reports (output) in a system dictate what data must be stored in the database. • Report, Layout and Design view and Print Preview

Macros • Small programs that can perform advanced operations, making the database more powerful and user-friendly. • Often used to open forms and reports or to automate portions of the database. • Special macro named Autoexec will run automatically when the database is opened.

Form and Report Wizards Useful as a starting point for building reports and forms. Provides a framework that you can customize and build upon.

Evolution of Databases

Relational Databases The real power of Access is derived from multiple tables and the relationships between those tables.

Quick Review What view is used to add, edit, and delete records in a table? a. the Design view b. the Datasheet view c. Either (a) or (b) d. Neither (a) or (b)

Quick Review Which represents the hierarchy of terms from smallest to largest? a. Database, table, record, field b. Field, record, table, database c. Record, field, table, database d. Field, record, database, table

Quick Review A __________ provides a convenient and attractive way to enter, display, and/or print the data in a table.

Quick Review Which form and report view allows you to immediately see the design changes you’re making? a. Datasheet b. Design c. Print Preview d. Layout

Homework 1 • Chapter 1 Guided Exercise • Chapter 2 Guided Exercise • Chapter 2 Applied Exercise

• More by User

Microsoft Access 2010

Microsoft Access 2010. Chapter 1 Databases and Database Objects: An Introduction. Objectives. Design a database to satisfy requirements Describe the features of the Access window Create a database Create tables in Datasheet and Design views Add records to a table. Close a database

1.32k views • 35 slides

Microsoft Access 2010. Chapter 7 Using SQL. Objectives. Change the font or font size for SQL queries Create SQL queries Include fields in SQL queries Include simple and compound criteria in SQL queries Use computed fields and built-in functions in SQL queries

595 views • 35 slides

Microsoft Access 2010. Chapter 10 Administering a Database System. Objectives. Create custom Quick Start fields Create a Web database and publish to Access Services Convert a database to and from earlier versions of Access

1.05k views • 77 slides

Microsoft Access 2010. Relational databases’ program Part of the Microsoft Office package Administer relational database Update database through forms Build complex queries Create reports Competitors: Oracle, PostgreSQL, MySQL. 1. Northwind 2003 database example

365 views • 21 slides

Microsoft Access 2010. Chapter 1 Databases and Database Objects: An Introduction. Objectives. Design a database to satisfy a collection of requirements Describe the features of the Access window Create a database Create tables in Datasheet and Design views Add records to a table.

683 views • 46 slides

Microsoft Access 2010. Relational databases’ program Part of the Microsoft Office package Administer relational database Update database through forms Build complex queries Create reports Competitors: Oracle, PostgreSQL , MySQL. 1. Northwind 2003 database example

232 views • 7 slides

Microsoft Access 2010. Lesson 3, Part 1. Learning Objectives. Calibri size 11. Formatting a Table Datasheet. By default, Access creates every table in using the default font type and size. You cannot change the default font from this option only the “size” and “weight”.

323 views • 20 slides

Microsoft Access 2010. Lesson 3 – Part 1. Learning Objectives. Calibri size 11. Formatting a Table Datasheet. By default, Access creates every table in using the default font type and size. You cannot change the default font from this option only the “size” and “weight”.

305 views • 16 slides

Microsoft Access 2010. Chapter 3 Maintaining a Database. Objectives. Add , change, and delete records Search for records Filter records Update a table design Use action queries to update records Use delete queries to delete records

799 views • 62 slides

Microsoft Access 2010- Illustrated

Microsoft Access 2010- Illustrated . Unit B: Building and Using Queries. Objectives. Use the Query Wizard Work with data in a query Use Query Design View Sort and find data (continued). Objectives (continued). Filter data Apply AND criteria Apply OR criteria Format a datasheet.

378 views • 26 slides

Microsoft Access 2010. Chapter 5 Multitable Forms. Objectives. Add Yes/No, Date/Time, Memo, OLE Object , and Attachment fields Use the Input Mask Wizard Update fields and enter data Change row and column size Create a form with a subform in Design view

787 views • 47 slides

Microsoft Access 2010. Chapter 4 Creating Reports and Forms. Objectives. Create reports and forms using wizards Modify reports and forms in Layout view Group and sort in a report Add totals and subtotals to a report Conditionally format controls Resize columns

589 views • 42 slides

Microsoft Access 2010. Lesson 3 – Part 2. Input Mask – con’t. You can create a lookup field that stores multiple values per record. Example of Lookup Field. Apply a Smart Tag to a database .

231 views • 5 slides

Microsoft Access 2010. Lesson 2. Learning Objectives. Planning a Database. Determine what information to store in the database Determine a logical arrangement of tables Gather all information that will be a part of the database Decide which information to store in each table

377 views • 15 slides

Microsoft Access 2010. Chapter 2 Querying a Database. Objectives. Create queries using Design view Include fields in the design grid Use text and numeric data in criteria Save a query and use the saved query Create and use parameter queries Use compound criteria in queries

760 views • 58 slides

Microsoft Access 2010. Lab 10 Querying a Database http:// www.sophea.info/portal/Teaching/DelawareValleyCollege/tabid/64/Default.aspx. Objectives. Understand query and general guidelines for creating query Create queries using Query Design Use text and numeric data in criteria

554 views • 41 slides

Microsoft Access 2010. Chapter 6 Advanced Report Techniques. Objectives. Create and relate additional tables Create queries for reports Create reports in Design view Add fields and text boxes to a report Format report controls Group and ungroup report controls

709 views • 49 slides

Microsoft Access Overview

Microsoft Access Overview. Lydia Scheer, ITEP. The Database Environment. Access is a relational database Data stored with Access are related to one another in multiple ways Access maintains the data relationships when database is structured correctly

495 views • 35 slides

Microsoft Access 2010. MODULE 7. Chapter 1: Working with Databases Chapter 2: Using Forms and Tables Chapter 3: Working with Queries and Reports. Microsoft Access Overview. A database is an organized collection of related data.

695 views • 35 slides

Microsoft Access 2010. MODULE 7. Chapter 1: Working with Databases Chapter 2: Using Forms and Tables Chapter 3: Working with Queries and Reports. Working with Queries and Reports. Chapter 3. Skills You Learn. Use the Query Wizard Create a query in Design view

509 views • 29 slides

Microsoft access databases

Have you heard of customized Microsoft Access databases? EBS welcomes all small and medium-sized enterprises to explore our services. http://www.webdatabases.co

122 views • 6 slides

Upgrade from PowerPoint 2010 to PowerPoint in Microsoft 365

Still using PowerPoint 2010? Easily create more polished presentations with PowerPoint in Microsoft 365. Enjoy premium features like 3D, Inking, and more.

PowerPoint 2010 has been retired.

Get the most up-to-date version of PowerPoint and easily create polished presentations. Upgrade to Microsoft 365 today.

What’s new with PowerPoint in Microsoft 365?

Design and present with confidence

Enhanced design tools let you create fluid motion and bring your slides to life with just a few clicks.

Work together in sync

With 1 TB of OneDrive cloud storage, you can back up, share, and coauthor your presentations.

Take PowerPoint on the road, anywhere

Review and edit files at work, home, or anywhere in between with mobile apps.

Always up to date

Get exclusive, new features available only to PowerPoint in Microsoft 365.

Bring your presentations to life

Create memorable presentations with help from intelligent technology in just a few steps. Start with an elegant design and add rich animation, cinematic motion, 3D models, icons, and more.

Reach your audience

Tell your story with confidence using slide-by-slide notes viewable by you. Translate slides into other languages and use the built-in accessibility checker to help get your message across to everyone.

Collaborate with others

Work together on presentations with Microsoft 365. Get help and feedback from teammates in real time with coauthoring and comments. Save files to the cloud to easily share—anywhere, any time, on any device.

Compare PowerPoint 2010 and PowerPoint with Microsoft 365

Ready for microsoft 365, top questions, what’s the difference between office 2010 and microsoft 365.

Office 2010 include essential applications such as Word, Excel, PowerPoint, and Outlook. They’re available as a one-time purchase for use on a single PC.

Microsoft 365 plans include premium versions of these applications plus other services that are enabled over the Internet, including online storage with OneDrive and Skype minutes for home use. With Microsoft 365 you get the full, installed Office experience on PCs, Macs, tablets (including iPad® and Android™ tablet) and phones. Microsoft 365 plans are available as a monthly or annual subscription.  Learn more .

How do I know if my computer can run Microsoft 365?

See  system requirements  for compatible versions of Windows and macOS, and for other feature requirements.

Is internet access required for Microsoft 365?

You don’t need to be connected to the Internet to use Office applications, such as Word, Excel, and PowerPoint, because the applications are fully installed on your computer.

However, Internet access is required to install and activate all the latest releases of Office suites and all Microsoft 365 subscription plans. For Microsoft 365 plans, internet access is also needed to manage your subscription account, for example to install Office on other PCs or to change billing options. Internet access is also required to access documents stored on OneDrive, unless you install the OneDrive desktop app.

You should also connect to the Internet regularly to keep your version of Office up to date and benefit from automatic upgrades. If you don’t connect to the Internet at least every 31 days, your applications will go into reduced functionality mode, which means that you can view or print your documents but cannot edit the documents or create new ones. To reactivate your Office applications, reconnect to the Internet.

Will I still have control of my documents with Microsoft 365?

Yes. Documents that you have created belong fully to you. You can choose to store them online on OneDrive or locally on your PC or Mac.

If you cancel your subscription or it expires, you can still access and download all your files by signing in to OneDrive directly using the Microsoft account you used to set up Microsoft 365. You do lose the additional storage that comes with your subscription, so you must save your files elsewhere or buy more OneDrive storage if your OneDrive account exceeds the free storage quota.

When would my subscription start?

If you purchase an auto-renew subscription, your subscription starts when you complete your purchase. You can purchase auto-renew subscriptions from Office365.com, MicrosoftStore.com, iTunes®, and some other retailers. If you purchase a pre-paid subscription, your subscription starts when you activate your subscription and land on your My Account page. You can purchase pre-paid subscriptions from a retailer or reseller, or a Microsoft support agent.

How do I share Microsoft 365 with other people?

If you have an active Microsoft 365 Family subscription, you can share it with up to five other people (six total). Each person you share your subscription with can use any of your available installs on their PCs, Macs, iPads, Android tablets, Windows tablets, iPhones® or Android phones, get an additional 1 TB of cloud storage, and manage their own installs from www.account.microsoft.com .

To add someone to your subscription, visit  www.office.com/myaccount  and follow the onscreen instructions to add a user. Each person you add will receive an email with the steps they need to follow. Once they have accepted and completed the steps, their information, including the installs they are using, will appear on your My Account page. You can stop sharing your subscription with someone or remove a device they are using at  www.office.com/myaccount .

What is “the cloud”?

“The cloud” is a friendly way of describing web-based computing services that are hosted outside of your home or organization. When you use cloud-based services, your IT infrastructure resides off your property (off-premises), and is maintained by a third party (hosted), instead of residing on a server at your home or business (on-premises) that you maintain. With Microsoft 365, for example, information storage, computation, and software are located and managed remotely on servers owned by Microsoft. Many services you use every day are a part of the cloud—everything from web-based email to mobile banking and online photo storage. Because this infrastructure is located online or “in the cloud,” you can access it virtually anywhere, from a PC, tablet, smartphone, or other device with an Internet connection.

PowerPoint 2010 resources

Office 2010 help topics.

Find user guides, training, and other support for Office 2010

Other versions of Office

Learn about other versions of Office and how you can upgrade to the new Microsoft 365.

Download Office 2010

Download and install Office 2010 using an existing product key.

• A Microsoft 365 subscription unlocks the most up-to-date premium version of PowerPoint on all your devices. Previous versions include  PowerPoint 2013 ,  PowerPoint 2010 ,  PowerPoint 2007 , and PowerPoint 2003.
• iTunes, iPhone, and iPad are registered trademarks of Apple Inc., registered in the U.S. and other countries. Android is a trademark of Google Inc.

Follow Microsoft 365