In a datasheet, what does each column represent?
What is the maximum length a text field can be?
According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
When creating a new table which method can be used to choose fields from standard databases and tables
What type of relationship is created when you select a primary key in both related tables?
This is the stage in database design where one gathers and list all the necessary fields for the database project.
What is the use of Referential Integrity in MS Access?
Which colors are used to define a custom color?
Relationship can be establish between two tables by
The ‘filter by selection’ allows you to filter those records
By default, what is the name of a new module in the Modules folder of the Project pane called?
The ______ is a wild card that represents one or more characters.
When a picture or other graphic image is placed in the report header section it will appear ________.
Which of the following queries can create a table?
How do you filter by selection?
Which of the following functions CANNOT be used in the Totals row?
In access, this view is used to create and modify the structure of a form.
What it is called to present information in a particular order based on numeric or alphabetical value?
A file containing relatively permanent data is
Which of the following is not a section in report design window?
What is the use of description field in table design window?
In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
What type of controls are text boxes when data from the recordset is visible?
A part of database that stores complete information about an entity such as employee, sales, orders etc.
A database object in MS Access that stores a question about the data in database?
Database access levels are specified so as to define who can access what in a database. It is identified through
The Table _______________ Wizard analyzes a database and recommends changes for normalization.
Which of the following database object can be used if you need to mail the invoice to customers?
You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
Which of the following is the default join between two recordsets?
The complete information about an entity in a database is called
Which is not an option for customizing a datasheet window?
What is a form in MS Access?
This type of database contains multiple tables that are connected to produce combined output from all tables.
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
In the form wizard dialog box, the fields from the selected table are displayed in this list box.
DCL provides commands to perform actions like
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.