This is to help you study for your Quarter 2 Exam, over chapters 10 and 11.
Do not only memorize this guide word for word, you should be prepared to show that you understand the terms and ideas listed below.
Click Read More below to read the study guide.
- Know what a database is
- Be able to find the database window and table windows
- Know the names for parts of access's interface, such as field name, fields, the menu bar, tool bar, ect...
- The different types of fields (AutoNumber, Date, Text, Number) and what information they hold.
- Basic guidelines when naming a field (Unique field names, shortest names that accurately describe what the hold, use complete words and avoid special characters)
- Rows in the table are called records
- The primary key has a unique entry for each record
- Know the record controls (those are the buttons at the bottom of a form that let you move to the previous, next, last and create a new record)
- Know the difference between a dynamic and a static web page. Know what part a database plays in dynamic web pages.
- Know how to create a table in design view, create forms, enter information, add a lookup value and print access databases.
Chapter 10
- The CHOOSE Function - =CHOOSE(<choice>,<option1>,<option2>,...<optionN>), Returns a value in a list that corresponds with <choice>.
- Naming a cell or range -Know where the Name box is and that Insert->Name->Define will let you name a range as well.
- The VLOOKUP Function - =VLOOKUP(<value>, <range>, <column>) - Finds the largest number in the first column of <range> which is less than or equal to <value>. returns the corresponding value in <column>. HLOOKUP is similar but uses a row instead of a column.
- Freezing Cells -Useful when working with large spreadsheets, allows cells to not move as you scroll.
- Hyperlinks can link to websites or places within excel documents. Insert-> Hyperlink
- When copying and pasting, paste special allows you to link the documents, which will allow changes to automatically be updated.
- TODAY() displays the current date, while NOW() displays the current date and time
- Worksheets can be protected by going to tools->protection->protect sheet or tools->protection->protect workbook. You can require a password to modify parts of the document.
- Data validation lets you require data to meet certain requirements before it can be entered in the worksheet.
- Data forms allow you to simplify data entry.
- Lists allow easy shorting and filtering and are created by going to Data->List->Create List
- Know how to write a choose function, vlookup function, and use them in a worksheet
*Be especially sure you know the guidelines for naming fields, developing a schema (know that term), field types and formatting.