1 / 8

A Dummies Guide to Access

A Dummies Guide to Access. Microsoft Access 2007. What is access?. Access is a database software program. Databases are basically large lists of information of a certain sort for example Telephone directories These are just a paper based database of phone numbers

Download Presentation

A Dummies Guide to Access

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. A Dummies Guide to Access Microsoft Access 2007

  2. What is access? • Access is a database software program. • Databases are basically large lists of information of a certain sort for example • Telephone directories • These are just a paper based database of phone numbers • With access you can create digital databases which ease the task of finding what you need from them

  3. The Basics • Access’ main boasts are its ability to create tables and forms which make creating databases quick and easy • In the following video we will see briefly how this is done before going into more detail later on.

  4. Creating Tables and Forms

  5. The Banners • The Home Banner, From here we can change fonts, text formatting and size and all the basic options such as copy paste and the spell checker. • The Create Banner, • From here we can access all the options we need to create new tables, forms, reports and other things such as macros.

  6. The Banners – continued • The External Data Banner, from here we can get to the options that allow us to import data from external sources and also move data to external locations. • The Database Tools Banner, • From this banner we are able to access the options that let us create all the sections of databases link all the data together.

  7. The Banners - continued • The Datasheet banner, The datasheet banner is a pick of things from the other banners that will be most widely used. Table structure formatting and the data linking sections are found here

  8. The Guide • That is the end of this slide show, you will now be given a walkthrough of how to use ms access in an effective way. • Any questions?

More Related