Which of the following is invalid field name in MS Access?

Student.Address

Student_Address

Students's Address

Student Address

Names of fields, controls, and objects in Microsoft Access desktop databases:

Can be up to 64 characters long.
Can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation point (!), an accent grave (`), and brackets ([ ]).
Can’t begin with leading spaces.
Can’t include control characters (ASCII values 0 through 31).
Can’t include a double quotation mark (“) in table, view, or stored procedure names in a Microsoft Access project.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.