4 Using Ms Access
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 4 Using Ms Access as PDF for free.
More details
- Words: 146
- Pages: 13
Using MS Access
Creating fields
Entering Records
When you reach the last field (Comments) press [Enter] again to move to the next line.
Number Types
Input Masks Date
of Birth Postcode State
99/90/00;;_ 0000;;_ >aaa
State
Validation Rules
Validation Rule
ACT or NSW or NT or QLD or SA or TAS or VIC or WA
Validation Text
Must be an Australian state.
Date of Birth Validation Rule Validation Text
Data Entry using a form
Using Data Entry Additional Rows
Create a new table Table Name: COURSE
CourseID
Fieldsize:10
Course
Code
Required:
YES Allow Zero Length: NO Course Leave
Title default properties as is
Add a field to STUDENTS table
CourseID • Data Type: Number • Fieldsize: Long Integer
Relationships Click Tools Menu > Relationshi ps
Creating fields
Entering Records
When you reach the last field (Comments) press [Enter] again to move to the next line.
Number Types
Input Masks Date
of Birth Postcode State
99/90/00;;_ 0000;;_ >aaa
State
Validation Rules
Validation Rule
ACT or NSW or NT or QLD or SA or TAS or VIC or WA
Validation Text
Must be an Australian state.
Date of Birth Validation Rule Validation Text
Data Entry using a form
Using Data Entry Additional Rows
Create a new table Table Name: COURSE
CourseID
Fieldsize:10
Course
Code
Required:
YES Allow Zero Length: NO Course Leave
Title default properties as is
Add a field to STUDENTS table
CourseID • Data Type: Number • Fieldsize: Long Integer
Relationships Click Tools Menu > Relationshi ps
Related Documents
4 Using Ms Access
November 2019 9
Ms Access
November 2019 27
Ms Access
May 2020 18
Ms-access
October 2019 29
Ms Access
May 2020 14