1 / 14

Access Project 1

Access Project 1. Creating and Using a Database. Features of Microsoft Access . Data Entry and update – You can add, change, and delete data Queries (questions) – You can ask and receive instant answer to questions about the data in the database Forms – You can create forms to view the data

kioko
Download Presentation

Access Project 1

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. Access Project 1 Creating and Using a Database

  2. Features of Microsoft Access • Data Entry and update – You can add, change, and delete data • Queries (questions) – You can ask and receive instant answer to questions about the data in the database • Forms – You can create forms to view the data • Reports – You can create reports to display the data

  3. Terminology • DBMS – Database Management System • Data – Is a collection of raw facts, figures, and symbols. (information) • Database – Describes a collection of data organized in a manner that allows access, retrieval, and use of that data.

  4. Terminology • Database management System – (Access) is a software tool that allows you to use a computer to create a database; add, change, delete, sort and retrieve data in the database; Create forms and reports using the database. • In access a database consists of a collection of tables.

  5. Terminology • In access a database consists of a collection of tables. • Records – rows in a table (contains information) • Field – Columns in a table, contains a specific piece of information within a record.

  6. Terminology • Unique Identifier – A unique number or combination of characters that identifies a record • Primary Key – a Unique Identifier

  7. Fields within a table • Field Name – Each field in a table must have a unique name. • Names can be up to 64 characters in length • Names can contain letters, digits, and spaces, as well as most punctuation symbols • Names cannot contain periods, exclamation points (!), accent graves (`), or square brackets ([]). • Same name cannot be use twice

  8. Fields within a table • Data type – Indicates the type of data the field will contain. Some data types include: • Text – The field can only contain characters. A max of 255 characters is allowed. • Number – The field can contain only numbers. Numbers can be positive or negative. • Currency – The field can contain only monetary data. The values will appear with currency symbols. • Table 1-1 page AC17 has additional data types

  9. Fields within a table • Description – Access allows you to enter a detailed description of the field.

  10. The Access Window • Title Bar – Includes the title of the application (might include the name of the file) • Menu Bar – It is a special toolbar that displays menu names • Menu – Is a list of commands. It can contain submenus

  11. The Access Window • Toolbars – Contains buttons that allow you to perform certain tasks more quickly than using the menu bar. • Taskbar – Displays the start button, any active windows and the current time • Status Bar – It contains special information that is appropriate for the task you are performing.

  12. Access Project 1 Complete

More Related