g the Input Mask Wizard. Select the Extension input mask and update the field to 9999, so that the 9999;;_is the final input.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Update the Input Mask property using the Input Mask Wizard. Select the Extension input mask and update the field to 9999, so that the 9999;;_is the final input.

 

Table Tools NP_AC19_CT_CS1-4c_ErikLeon_2: Database- C:\Users\Owner\OneDrive\Desktop\NP_AC19_CT_CS1-4c_Erikleon_2.accdb (Access 2007 - 2016 file fe
File
External Data
Database Tools
Help
Design
P Tell me what you want to do
Home
Create
* Insert Rows
Ex Delete Rows
Primary Builder Test Validation
Key
Object
Dependencies
View
Property Indexes
Create Data Rename/
Relationships
Ea Modify Lookups
Rules
Sheet
Macros v Delete Macro
Views
Tools
Show/Hide
Field, Record & Table Event
Relationships
E Employees X
All Access Obje.. © «
Field Name
Data Type
Description (Optional)
Search.
EmployeelD
EmployeeFirst
Employeelast
Email
Number
Tables
Short Text
_GradinglnfoTable
Input Mask Wizard
Short Text
Applications
Нуperlink
Which input mask matches how you want data to look?
I Companies
Salary
Currency
Extension
Short Text
I Employees
To see how a selected mask works, use the Try It box.
Industries
To change the Input Mask list, click the Edit List button.
Jobs
Input Mask:
Data Look:
Phone Number
Social Security Number
Zip Code
Extension
Password
I JobSeekers
(206) 555-1212
831-86-7180
Queries
98052-6399
E ApplicationDates
63215
*******
E ApplicationListing
Long Time
1:12:00 PM
E ApplicationListing Query
Try It:
E DirectorSeptember
E HighSalaries
Edit List
Cancel
< Back
Next >
Finish
Forms
3 JobSeekerEntry
3 JobsEntry
Reports
A
Companylisting
9 Joblisting
JobSeekerlisting
Field Properties
General Lookup
Field Size
255
Format
Input Mask
Caption
Default Value
Validation Rule
Validation Text
Required
Allow Zero Length
No
Yes
Indexed
No
Unicode Compression
Yes
IME Mode
No Control
IME Sentence Mode
None
Text Align
General
Transcribed Image Text:Table Tools NP_AC19_CT_CS1-4c_ErikLeon_2: Database- C:\Users\Owner\OneDrive\Desktop\NP_AC19_CT_CS1-4c_Erikleon_2.accdb (Access 2007 - 2016 file fe File External Data Database Tools Help Design P Tell me what you want to do Home Create * Insert Rows Ex Delete Rows Primary Builder Test Validation Key Object Dependencies View Property Indexes Create Data Rename/ Relationships Ea Modify Lookups Rules Sheet Macros v Delete Macro Views Tools Show/Hide Field, Record & Table Event Relationships E Employees X All Access Obje.. © « Field Name Data Type Description (Optional) Search. EmployeelD EmployeeFirst Employeelast Email Number Tables Short Text _GradinglnfoTable Input Mask Wizard Short Text Applications Нуperlink Which input mask matches how you want data to look? I Companies Salary Currency Extension Short Text I Employees To see how a selected mask works, use the Try It box. Industries To change the Input Mask list, click the Edit List button. Jobs Input Mask: Data Look: Phone Number Social Security Number Zip Code Extension Password I JobSeekers (206) 555-1212 831-86-7180 Queries 98052-6399 E ApplicationDates 63215 ******* E ApplicationListing Long Time 1:12:00 PM E ApplicationListing Query Try It: E DirectorSeptember E HighSalaries Edit List Cancel < Back Next > Finish Forms 3 JobSeekerEntry 3 JobsEntry Reports A Companylisting 9 Joblisting JobSeekerlisting Field Properties General Lookup Field Size 255 Format Input Mask Caption Default Value Validation Rule Validation Text Required Allow Zero Length No Yes Indexed No Unicode Compression Yes IME Mode No Control IME Sentence Mode None Text Align General
Table Tools
NP_AC19_CT_CS1-4c_ErikLeon_2: Database- C:\Users\Owner\OneDrive\Desktop\NP_AC19_CT_CS1-4c_Erikleon_2.accdb (Access 200
File
Home
Create
External Data
Database Tools
Help
Design
P Tell me what you want to do
* Insert Rows
Ex Delete Rows
Primary Builder Test Validation
Key
Property Indexes
Relationships
Object
Dependencies
View
Create Data Rename/
a Modify Lookups
Rules
Sheet
Macros v Delete Macro
Views
Tools
Show/Hide
Field, Record & Table Events
Relationships
All Access Obje... © «
Search.
Employees X
Field Name
Data Type
Description
EmployeelD
Number
Tables
EmployeeFirst
EmployeeLast
Short Text
_GradinglnfoTable
Input Mask Wizard
Short Text
I Applications
Нуperlink
Currency
Email
Which input mask matches how you want data to look?
I Companies
Salary
Extension
Short Text
Employees
To see how a selected mask works, use the Try It box.
Industries
To change the Input Mask list, dick the Edit List button.
Jobs
Input Mask:
Data Look:
Phone Number
Social Security Number
Zip Code
Extension
Password
Long Time
JobSeekers
(206) 555-1212
831-86-7180
Queries
98052-6399
E ApplicationDates
63215
特
E ApplicationListing
1:12:00 PM
9 Applicationlisting Query
Try It:
E DirectorSeptember
A HighSalaries
Edit List
Cancel
<Back
Next >
Finish
Forms
8 JobSeekerEntry
3 JobsEntry
Reports
CompanyListing
Joblisting
JobSeekerListing
Field Properties
General Lookup
Field Size
255
Format
Input Mask
Caption
Default Value
Validation Rule
Validation Text
Required
Allow Zero Length
Indexed
No
Yes
No
Unicode Compression
Yes
IME Mode
No Control
IME Sentence Mode
Text Align
None
General
Transcribed Image Text:Table Tools NP_AC19_CT_CS1-4c_ErikLeon_2: Database- C:\Users\Owner\OneDrive\Desktop\NP_AC19_CT_CS1-4c_Erikleon_2.accdb (Access 200 File Home Create External Data Database Tools Help Design P Tell me what you want to do * Insert Rows Ex Delete Rows Primary Builder Test Validation Key Property Indexes Relationships Object Dependencies View Create Data Rename/ a Modify Lookups Rules Sheet Macros v Delete Macro Views Tools Show/Hide Field, Record & Table Events Relationships All Access Obje... © « Search. Employees X Field Name Data Type Description EmployeelD Number Tables EmployeeFirst EmployeeLast Short Text _GradinglnfoTable Input Mask Wizard Short Text I Applications Нуperlink Currency Email Which input mask matches how you want data to look? I Companies Salary Extension Short Text Employees To see how a selected mask works, use the Try It box. Industries To change the Input Mask list, dick the Edit List button. Jobs Input Mask: Data Look: Phone Number Social Security Number Zip Code Extension Password Long Time JobSeekers (206) 555-1212 831-86-7180 Queries 98052-6399 E ApplicationDates 63215 特 E ApplicationListing 1:12:00 PM 9 Applicationlisting Query Try It: E DirectorSeptember A HighSalaries Edit List Cancel <Back Next > Finish Forms 8 JobSeekerEntry 3 JobsEntry Reports CompanyListing Joblisting JobSeekerListing Field Properties General Lookup Field Size 255 Format Input Mask Caption Default Value Validation Rule Validation Text Required Allow Zero Length Indexed No Yes No Unicode Compression Yes IME Mode No Control IME Sentence Mode Text Align None General
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Processes of 3D Graphics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education