• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 3 pages
Exam (elaborations)

3328 Microsoft AccessData

Document preview thumbnail
Preview 1 out of 3 pages

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
$8.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
TOPDOCTOR
5.0
(1)
Sold
10
Followers
5
Items
3387
Last sold
1 year ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.