3328 Microsoft AccessData
Database - answer-Collection of data Tables - answer-Store data Record - answer-rpw/observation Field - answer-column Form - answer-Input data through interface. data input via a form is stored in an underlying table Query - answer-Extract, update, delete data from a table. Does not permanently store data, although results look similar Report - answer-Display data, read only AutoNumber - answer-Automatically assigned Calculated Field - answer-Expression to calculate a value (such as revenue) Yes/No - answer-T/F value (-1 for yes, 0 for no) Default Value - answer-Preset value to a field (state) Input Mask - answer-Force user to enter data in a consistent format Join tables to - answer-Use data from multiple tables in the same query Tables must be related - answer-through a common variable/attribute Parameter Queries - answer-Allow the user to enter in criteria Access is a _____ database - answer-Relational In SAP we could input data through several forms - answer-purchase requisition, vendor invoice, purchase order, receiving report, etc Three types of relationships - answer-one to many, one to one, and many to many Data Sheet View - answer-enter, sort, and filter data
Document information
- Uploaded on
- June 24, 2024
- Number of pages
- 3
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers