1 / 15

Lesson 29: Building a Database

Lesson 29: Building a Database. Learning Objectives. After studying this lesson, you will be able to: Identify key database design techniques Open an existing database Create a database table using Design view Create a form Create a report Create a table from an Excel worksheet

maik
Télécharger la présentation

Lesson 29: Building a Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lesson 29: Building a Database

  2. Learning Objectives • After studying this lesson, you will be able to: • Identify key database design techniques • Open an existing database • Create a database table using Design view • Create a form • Create a report • Create a table from an Excel worksheet • Create a new database using a template

  3. Planning a Database Design Asking questions helps identify objects Reports Fields Tables Foreign keys Forms Queries • What info do you want to obtain from the database? • What pieces of data do you need for the info? • What groups do the fields fit into? • How do the groups interconnect? • What is the most efficient way to input data? • What questions will the data answer?

  4. Opening a Database • Same basic procedures used to open files in other computer programs • Enabling content to control security

  5. Saving a Database as a New File • File > Save As command in Access is different from other applications Save an existing object as a new object Save an existing databaseas a new database

  6. Opening Database Objects • Database objects are grouped by type on the Navigation Pane • Procedures for opening database objects similar to those used to open programs from the Desktop: • Double-click the object in the Navigation Pane • Right-click object in the Navigation Pane and choose Open • Drag the object name from the Navigation Pane to the work area of the Access window

  7. Working with Tabbed Objects • Each open object in the database window is identified by a tab • To switch among open objects, click a tab

  8. Creating Database Objects • The Create tab of the Ribbon contains tools for creating all database objects • Tools on the Ribbon are grouped by object type • Each object type has several different formats to choose from

  9. Creating a Simple Form – Input • Forms are used to input data into database tables • Forms obtain their field names and data from tables or queries • Simple forms contain all fields for the table or query on which they are based

  10. Creating Simple Reports – Output • Processes data into meaningful information • Formats data for printing • Contains all fields from the associated table

  11. Creating a Table Using Design View

  12. Importing Data from Excel • Creates new tables from data stored in other programs • External Data tab on the Ribbon contains Import tools • Most import procedures use Wizards

  13. Create a Database Using a Template • In Access, database templates are ready-to-use databases • Each template contains a set of objects designed for a specific purpose • Storing contacts, tracking projects, etc. • Each object in the database created with a template can be customized to meet specific needs

  14. Finding and Selecting Templates Sample templates Business templates group downloaded from Microsoft Search for more templates

  15. Lesson 29: Building a Database

More Related