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

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

A

Student.Address

B

Student_Address

C

Students's Address

D

Student Address

Solution:

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.

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

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

Full Name

Phone Number

Select Language

Select Course

Select Course

Select Course

Select Course

Select Course

Please leave this field empty.