Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
BTEC COMPUTER SCIENCE assigments pearson college. per sem
Typology: Study notes
1 / 226
This page cannot be seen from the preview
Don't miss anything!
C:\Users\Norez\Downloads\Database1.accdb Table: Account Tuesday, December 21, 2021 Page: 1
18-12-2021 1:30:15 AM 1 {guid {469BCC74-F36E-4771- B8A8-05461BC1091D}} 21-12-2021 4:21:26 PM False 0 1 False Size 4
False False Fixed Size General False Default Default 0 False 255 0 Text Box {guid {DE10C018-89E5-4BBC-8CE3-04EA8066A833}} 0 True 0 Account_ID Account 0 Properties AlternateBackShade: AlternateBackTint: BackTint: DatasheetGridlinesThemeCol DefaultView: FilterOnLoad:
HideNewField: NameMap: OrderByOnLoad: PublishToWeb: ThemeFontIndex: Updatable: Columns 100 100 100 - 2 False False Long binary data True 1
True AlternateBackThemeColorInd BackShade: DatasheetForeThemeColorIn DateCreated: DisplayViewsOnSharePointSit GUID: LastUpdated: OrderByOn: Orientation: RecordCount: TotalsRow: Type Long Integer Name
GUID: OrdinalPosition: Required: ResultType: SourceField: SourceTable: TextAlign: ValidationRule: Tuesday, December 21, 2021 Page: 2 {guid {DE20CD60-6919-4E99-99E3-E074CEC1EFFB}} 0 3 1 False 0 Acc Name Account 0 True Date With Time
False False Fixed Size General False Default Default 0 False {guid {032E8FFE-1F0A-4B28-8361-28531AB7E691}} 0 3 2 False 0 1 Date Account 0 Date() Currency
False False Fixed Size General False Default
Default 0 False 255 $#,##0.00;($#,##0.00) {guid {8908713A-11FD-4C94-8CE5-AA462CA7578A}} 3 False 0 Fee Account 0
= 8 8 C:\Users\Norez\Downloads\Database1.accdb Table: Account Tuesday, December 21, 2021 Page: 3 Loc
Table Indexes Admission Officer_ID Attributes: RelationshipType: Name PrimaryKey Clustered: DistinctCount: Foreign: IgnoreNulls: Name: Primary: Required: Unique: Fields: Account_ID
User Permissions
C:\Users\Norez\Downloads\Database1.accdb Table: Admission Tuesday, December 21, 2021 Page: 5
{guid {A7DB7AC4-9FA1-4E09- 9D3A-44AE1BD09BCC}} 21-12-2021 4:20:41 PM False 0 1 False Size 4
False False Fixed Size General False Default Default 0 False 255 0 Text Box {guid {C957AF37-0A57-4164-BEFE-38D88DB2ADF7}} 0 True 0 Officer_ID Admission 0 Properties AlternateBackShade: AlternateBackTint: BackTint: DatasheetGridlinesThemeCol DefaultView: FilterOnLoad: HideNewField: NameMap: OrderByOnLoad: PublishToWeb: ThemeFontIndex: Updatable: Columns
Offier Name AggregateType: AllowZeroLength: AppendOnly: Attributes: CollatingOrder: ColumnHidden: ColumnOrder: ColumnWidth: CurrencyLCID: DataUpdatable: DisplayControl: Short Text 255
True False Variable Length General False Default Default 0 False Text Box C:\Users\Norez\Downloads\Database1.accdb Table: Admission GUID: IMEMode: IMESentenceMode: OrdinalPosition: Required: ResultType: SourceField: SourceTable: TextAlign: UnicodeCompression: Date AggregateType: AllowZeroLength: AppendOnly: Attributes: CollatingOrder: ColumnHidden: ColumnOrder: ColumnWidth: CurrencyLCID: DataUpdatable: GUID: IMEMode: IMESentenceMode: OrdinalPosition: Required: ResultType: ShowDatePicker: SourceField: SourceTable: TextAlign: ValidationRule: Relationships AdmissionAccount Admission Officer_ID Attributes: RelationshipType: AdmissionDepartment
Admission Officer_ID Attributes: RelationshipType: Tuesday, December 21, 2021 Page: 6 {guid {B8987283-C914-4F71-AE2D-8AC48FEA6C9C}} 0 3 1 False 0 Offier Name Admission 0 True Date With Time
False False Fixed Size General False Default Default 0 False {guid {29626263-4355-47CE-81C9-E08AC41BE5C4}} 0 3 2 False 0 1 Date Admission 0
=Date() Account Account_ID
C:\Users\Norez\Downloads\Database1.accdb Table: Admission AdmissionStudent Tuesday, December 21, 2021 Page: 7 Admission Officer_ID Attributes: RelationshipType: Name PrimaryKey Clustered: DistinctCount: Foreign: IgnoreNulls: Name: Primary: Required: Unique: Fields: Officer_ID User Permissions
admin Student Student_ID Not Enforced One-To-Many Number of Fields 1 False 1 False False PrimaryKey True True True Ascending Table Indexes
{guid {B470285F-58B7-4972- 94F7-3B62251717B6}} 18-12-2021 7:56:04 PM False 0 0 False Size 4
False False Fixed Size General False Default Default 0 False 255 0 Text Box {guid {938454F8-3D0A-47C6-A31B-BE362D4C0489}} 0 True 0 Course_ID Course 0 Properties AlternateBackShade: AlternateBackTint: BackTint: DatasheetGridlinesThemeCol DefaultView: FilterOnLoad: HideNewField: NameMap: OrderByOnLoad: PublishToWeb: ThemeFontIndex: Updatable: Columns 100 100 100 - 2 False False Long binary data True
True AlternateBackThemeColorInd BackShade: DatasheetForeThemeColorIn DateCreated: DisplayViewsOnSharePointSit GUID: LastUpdated: OrderByOn: Orientation: RecordCount: TotalsRow: Type Long Integer Name Course_ID AggregateType: AllowZeroLength: AppendOnly: Attributes: CollatingOrder: ColumnHidden: ColumnOrder: ColumnWidth: CurrencyLCID: DataUpdatable: DecimalPlaces: DefaultValue: DisplayControl: GUID: OrdinalPosition: Required: ResultType: SourceField: SourceTable: TextAlign: Course Name AggregateType:
