Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data manipulation, :, Demetra, : :, repeated data is moved into its own…
Data manipulation
Iverson's
-
-
-
- Right click > Change to > Combo Box
- Show Table > Select Table Framework(Depends)
- Field > Subject ID(Depends) and Field > Subject_Name > Sort > Ascending
-
-
Data type
-
Currency: Use for the amount of money and with a currency symbols. For example, $350.
Text: Large amounts of alphanumeric data: sentences and paragraphs. For example, phone numbers are used in Text because some phone numbers use hyphens and possibly parentheses
Numeric: For numeric values such as 1, 2, 3 ....
Autonumber: type of data used in Microsoft Access tables to generate an automatically incremented numeric counter. It may be used to create an identity column which uniquely identifies each record of a table.
Date/time: Used to identify a certain date or time. For example, 13-Aug-2020. There are many types of dates, one of the example is dd-mm-yyyy (Medium Date)
Alphanumeric:It is a combination that consists of number and letters. Alphanumeric is a data type means that any numbers it contains is to be treated as just another character.
Alpha(bet) + Numeric(al)
-
-
-
-
AdiVincent
-
Importing data from csv file, dont forgert to change data type.
Hayley's branch :tada: :tada::tada: (do not touch) Data Verification - To check the data entered into system are identical to the data on the original source document.
Method 2) Visual checking = Data is compared to what is on a form/document/card with what is typed in to check that both match
Method 1) Double entry of data = data is entered twice; only if it matches is it accepted for processing. When you create a new password, you have to enter it twice to check you have not made a mistake.
Data Validation
Definition: A process performed by a computer when the data entered. To check whether the data satisfies certain criteria. Data is checked against the set of validation rules which you set when developing the database system
-
-
-
-
-
-
-
-
-
-
-
-
- repeated data is moved into its own table
-
-