1 / 26

Lesson 1 – Getting Started with a Database

Lesson 1 – Getting Started with a Database. Lesson Objectives. Identify basic database structure. Work with a Microsoft Access database. Identify components of Access. Navigate Access recordsets. Modify datasheet appearance. Print and save a recordset. Manage Access files.

theus
Download Presentation

Lesson 1 – Getting Started with 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 1 – Getting Started with a Database

  2. Lesson Objectives • Identify basic database structure. • Work with a Microsoft Access database. • Identify components of Access. • Navigate Access recordsets. • Modify datasheet appearance. • Print and save a recordset. • Manage Access files.

  3. Identifying the Basic Database Structure • Databases are logically organized collections of data. • Microsoft Access uses a relational model for its design. • All data are stored in tables. • A table is a major database object that stores all data in a subject-based list of rows and columns. • A database table looks similar to a table displayed in a spreadsheet program or a word processor.

  4. Identifying the Basic Database Structure • Records are a set of related data about one subject • Fields contain an individual data elements within a record

  5. Identifying the Basic Database Structure • Tables are made up of records • Records are made up of related fields • Rows in a table • Fields are the smallest storage element • Columns in a table

  6. Identifying the Basic Database Structure • A recordset is a collection of records • Tables and Queries • Use by both Forms and Reports • Major objects in Access include: • Tables • Store all data • Queries • Organize data • Forms • Display data to the computer screen • Reports • Used to Print data

  7. Identifying the Basic Database Structure • Forms can display, add, edit, or delete recordsets • Reports can only display recordsets

  8. Manage a Database • Access limits certain file operations • An open database cannot be moved or renamed • Databases in this book will not fit on a 3.5 inch diskette • Database must not be Read-Only

  9. Start a Database

  10. Open a Database • Default mode to open Access is Shared • Other modes are: • Read-only • Exclusive use • Exclusive Read-only • Enable the database before working

  11. Identify Components of Access

  12. Manipulate the Navigation Pane • Displays and organizes major objects

  13. Open and Close Major Objects • Leszynski Naming Convention • No spaces or underscores • Used by software developers and programmers

  14. Open and Close Major Objects • Navigation Pane contains all Major objects

  15. Explore Datasheet and Design Views • Major objects have different views • Datasheet View • Design View • Change View by: • View Command • View Shortcut buttons • Right-clicking object

  16. Use Navigation Buttons in a Table • Datasheet View has two Modes • Edit Mode • Change content in a field • Insertion point (I-beam) visible • Navigation Mode • Entire field selected • Move between fields using • Keyboard • Record navigation buttons

  17. Use Navigation Buttons in a Table • Parts of Datasheet View

  18. Hide and Unhide Columns • Columns in Datasheet View can be hidden

  19. Change Column Widths and Row Heights • By default all columns are the same width • Each column can be individually resized • Each row shares the same height

  20. Use the Font Command Group • Font appearance are applied to entire datasheet • Alignments are applied to individual fields

  21. Print a Query • Print Methods: • Office Button , then Print • Keystroke • Can only print the Datasheet View of a Query

  22. Print a Table • Change page orientation in Print Preview

  23. Publish a Table • XPS – XML Paper Specification • Savable file format • Viewable using an internet browser • Can select quality of document

  24. Lesson 1 Summary • An Access database is relational, the most common type of database in use today. • Major Access database objects include tables, queries, forms, and reports. • A record is composed of related fields, a table is composed of related records, and a database is composed of related tables. • A recordset is a Microsoft object-oriented data structure consisting of grouped records. • A recordset is most often displayed as either a form or a report.

  25. Lesson 1 Summary • An opened database cannot be moved or renamed. • In the navigation pane, major objects are organized by categories and groups. • The Leszynski Naming Convention is a method of naming objects that emphasizes the use of the three-letter prefixes to identify the type of object. • Datasheet View and Design View are two methods of displaying each major object.

  26. Lesson 1 Summary • The columns and rows of a datasheet can be hidden, displayed, or resized. • Format changes to a datasheet affect all text in every column and row. • In a datasheet, column widths can be changed individually; row heights must be all the same. • In a datasheet, some format commands can be applied to individual fields; other commands apply to the entire datasheet. • The Quick Print command sends a document directly to the default printer without allowing changes to the print options.

More Related