MS Access - 3/22/2006

Today was a “study” day for the test next week, which will be over Chapters 5-7 (NOT chapter 8 as we had previously discussed).  This study day consisted of going through the Skills Assessments that are after Specialist Chapter 8.  I also passed out a study guide, which I’ll include below.

Homework:

• Study, study, study!

Microsoft Access Test Two (Study Guide)

• A PivotTable or PivotChart is a highly specialized, highly customizable way of presenting data that’s contained in a table or query.


• Access database files have the extension .mdb.


• An input mask automatically formats input for you.  You would use an input mask when you want phone numbers or social security numbers to all look the same.  (270) 843-6750.


• If you want to have Access create a form for you by asking you a series of questions (like an interview), you would start the Form Wizard.


• In designing a form, you can “tie” a field to a text box by indicating the field in the text box’s Control Source property.


• Know the proper structure to calculate values in queries using existing fields.  For example, to divide the TotalUnits field by the TotalPrice field you would type [TotalUnits]/[TotalPrice].


• Know the various ways to create tables, forms, and reports.


• Make sure you can do all of the skill assessments in the purple section of your book, just after Specialist Chapter 8.


• Making a forms makes your data entry process easier and more attractive.


• Navigation buttons are the buttons that allow you to navigate from one record to another inside tables, forms and reports.


• Queries allow you to pull up only certain information such as your male customers in Kentucky under the age of 35


• Reports allow you to arrange your data in an easy-to-read format on paper.


• Tables are the basic storage units in a database


• The difference between a page header and a report header is that the page header appears on the top of each page, the report header appears at the beginning of each report.  


• The Object Dependencies task pane allows you to view each object and everything that is tied to it with a relationship.  You can turn this feature on by clicking View, Object Dependencies.


• Turning on the form header can be accomplished by simply clicking View, Form Header/Footer.


• When you export data to a Word file, that Word file has the file extension .doc.


• When you export data to an Excel file, that Excel file has the file extension .xls.


• When you want your Access table to be automatically updated whenever you update a certain Excel file and vice versa, you would link the table to the Excel file.  To do that, you would click on File, Get External Data, Link Tables.


• Your Clipboard task pane allows you to hold up to 24 objects that you can later paste into various Office files.