Microsoft Access Training Conquers Database Phobias

Download
Share  Add to  Flag Embed
Views:
 
Category: Product Traini..
     
 
License:   Some Rights Reserved

Presentation Description

Learn how Microsoft Access training can conquer any phobias you may have about databases.

Comments

Presentation Transcript

Conquer Your Database Phobias With A Microsoft Access Course: 

Conquer Your Database Phobias With A Microsoft Access Course

Microsoft Access is one of the Microsoft Office suite of programs which users are inclined to put off learning, particularly if they have little or no experience of databases. When people compare it with Excel, they will usually conclude that Access looks the more difficult to learn out of the two programs.: 

Microsoft Access is one of the Microsoft Office suite of programs which users are inclined to put off learning, particularly if they have little or no experience of databases. When people compare it with Excel, they will usually conclude that Access looks the more difficult to learn out of the two programs.

This is probably because Excel, in spite of its huge power and complexity, has an immediacy about it which appeals to almost every one. It is pretty easy for most people to put together a basic spreadsheet which produces useful results for them.: 

This is probably because Excel, in spite of its huge power and complexity, has an immediacy about it which appeals to almost every one. It is pretty easy for most people to put together a basic spreadsheet which produces useful results for them.

By comparison, Access can seem a little opaque; and this is why an Access training course can be so useful in easing someone in to the database management environment.: 

By comparison, Access can seem a little opaque; and this is why an Access training course can be so useful in easing someone in to the database management environment.

As is always the case with computer software, in order to use the program effectively, owners of Microsoft Office need to be shown, firstly, the basic tenets of the software and, secondly, how it can benefit them.: 

As is always the case with computer software, in order to use the program effectively, owners of Microsoft Office need to be shown , firstly, the basic tenets of the software and, secondly, how it can benefit them.

Microsoft Access is, basically, database-management software, which enables you to create and maintain relational databases management systems (RDBMS). Databases are nothing new: they are simply collections of data with a fixed structure.: 

Microsoft Access is, basically, database-management software, which enables you to create and maintain relational databases management systems (RDBMS). Databases are nothing new: they are simply collections of data with a fixed structure.

This structure makes it easy to search and sort the information and display and print it in any number of different formats. Such collections of data existed before the advent of computers; but computers offer an unprecedented degree of flexibility in the way information can be manipulated.: 

This structure makes it easy to search and sort the information and display and print it in any number of different formats. Such collections of data existed before the advent of computers; but computers offer an unprecedented degree of flexibility in the way information can be manipulated.

In the same way that Excel can be equally useful for engineers, mathematicians, statisticians and doctors, Access does not force the user to work with any particular type of information.: 

In the same way that Excel can be equally useful for engineers, mathematicians, statisticians and doctors, Access does not force the user to work with any particular type of information.

A database can be as simple as a two-dimensional list of contacts or as complex as the operation of a small business including its stock-control, order-processing, invoicing, etc.: 

A database can be as simple as a two-dimensional list of contacts or as complex as the operation of a small business including its stock-control, order-processing, invoicing, etc.

This flexibility stems from two key aspects of the program: firstly, it deals with any type of data and allows developers to carefully define the nature of each category of information within the database, whether numeric, textual or concerned with dates and times.: 

This flexibility stems from two key aspects of the program: firstly, it deals with any type of data and allows developers to carefully define the nature of each category of information within the database, whether numeric, textual or concerned with dates and times.

Secondly, Access comprises six different types of object, each of which offer users a powerful set of tools and facilities for handling a key set of useful attributes of their data.: 

Secondly, Access comprises six different types of object, each of which offer users a powerful set of tools and facilities for handling a key set of useful attributes of their data.

One of the main functions of Microsoft Access training is to fully explain these six object types and offer new users a chance to practice working with them, make mistakes, ask questions and develop some degree of confidence and competence in using each one.: 

One of the main functions of Microsoft Access training is to fully explain these six object types and offer new users a chance to practice working with them, make mistakes, ask questions and develop some degree of confidence and competence in using each one.

Firstly we have tables: the fundamental repository that actually holds your data. Tables resemble Excel lists and are made up of fields and records. Each record represents a single item of data and, importantly, all records have exactly the same format.: 

Firstly we have tables: the fundamental repository that actually holds your data. Tables resemble Excel lists and are made up of fields and records. Each record represents a single item of data and, importantly, all records have exactly the same format.

This consistency is achieved by the definition of fields, the equivalent of column headings in an Excel list. In a table containing information about company staff, the fields would probably include such things as first name, last name, salary and date of birth.: 

This consistency is achieved by the definition of fields, the equivalent of column headings in an Excel list. In a table containing information about company staff, the fields would probably include such things as first name, last name, salary and date of birth.

A typical database will contain several such tables and Access allows you define relationships between the tables which help to prevent duplication and to preserve the integrity of your data.: 

A typical database will contain several such tables and Access allows you define relationships between the tables which help to prevent duplication and to preserve the integrity of your data.

A second important Access object is the query. Queries perform a variety of powerful operations on your data to produce useful results. Some queries allow you to search for records which match specific criteria, for example all invoices which are overdue for payment.: 

A second important Access object is the query. Queries perform a variety of powerful operations on your data to produce useful results. Some queries allow you to search for records which match specific criteria, for example all invoices which are overdue for payment.

In addition to extracting information in this way, queries can also generate summary information such totals, averages and counts.: 

In addition to extracting information in this way, queries can also generate summary information such totals, averages and counts.

Access also includes what are called action queries which perform a operations, such as creating a new table or deleting data which satisfies certain criteria.: 

Access also includes what are called action queries which perform a operations, such as creating a new table or deleting data which satisfies certain criteria.

Next, we have forms which are mainly used for inputting data. Although it is possible to enter information directly into a table, this approach does not offer much flexibility and does not allow you to take full advantage of any relationships you may have established between tables.: 

Next, we have forms which are mainly used for inputting data. Although it is possible to enter information directly into a table, this approach does not offer much flexibility and does not allow you to take full advantage of any relationships you may have established between tables.

Forms allow you to create a user interface which reflects the way that your users work and think and to offer a variety of methods for inputting data.: 

Forms allow you to create a user interface which reflects the way that your users work and think and to offer a variety of methods for inputting data.

Thus, instead of asking users to type in certain types of data, you might provide them with a drop-down menu or a series of radio buttons or checkboxes.: 

Thus, instead of asking users to type in certain types of data, you might provide them with a drop-down menu or a series of radio buttons or checkboxes.

Just as forms are used for input, reports are used to output data and are generally printed or converted into PDF files. Reports are typically based on queries, since in order to be useful, they will have to provide data which meets a given set of criteria.: 

Just as forms are used for input, reports are used to output data and are generally printed or converted into PDF files. Reports are typically based on queries, since in order to be useful, they will have to provide data which meets a given set of criteria.

In terms of how they are created, reports greatly resemble forms. Access offers a rich visual interface for designing reports and determining the order in which items are listed and the manner in which data is grouped and summarized.: 

In terms of how they are created, reports greatly resemble forms. Access offers a rich visual interface for designing reports and determining the order in which items are listed and the manner in which data is grouped and summarized.

Tables, queries, forms and reports are all concerned with storing and presenting your data. The other two Access objects are concerned with automation: they are macros and modules.: 

Tables, queries, forms and reports are all concerned with storing and presenting your data. The other two Access objects are concerned with automation: they are macros and modules.

Macros are the simpler of the two: a macro consists of a set of steps which you can generate by recording them or by choosing them. When the macro runs, the steps are performed, saving you the time it would have taken to perform each step manually.: 

Macros are the simpler of the two: a macro consists of a set of steps which you can generate by recording them or by choosing them. When the macro runs, the steps are performed, saving you the time it would have taken to perform each step manually.

Modules are much more powerful and provide developers with VBA (Visual Basic for Applications), a fully-fledged programming environment where they can create code that performs complex operations.: 

Modules are much more powerful and provide developers with VBA (Visual Basic for Applications), a fully-fledged programming environment where they can create code that performs complex operations.

This is the only one of Access's six object types which is not normally covered on a basic or intermediate training course, since it requires an intimate knowledge of all elements of the program.: 

This is the only one of Access's six object types which is not normally covered on a basic or intermediate training course, since it requires an intimate knowledge of all elements of the program.

An Access training course which introduces users to all the key aspects of the program and familiarizes them with the six types of object on which it is built will do much to remove any database phobias by which they may be plagued.: 

An Access training course which introduces users to all the key aspects of the program and familiarizes them with the six types of object on which it is built will do much to remove any database phobias by which they may be plagued.

Naturally, it is important that, after the course, users are given an opportunity to put the knowledge they have acquired into practice by actually building a database.: 

Naturally, it is important that, after the course, users are given an opportunity to put the knowledge they have acquired into practice by actually building a database.

This will help to consolidate their new skills by allowing them to construct systems which are useful and relevant to their work.: 

This will help to consolidate their new skills by allowing them to construct systems which are useful and relevant to their work.

Slide 31: 

www.macresource.co.uk