Question

For Microsoft Access

• Define the four types of Action Queries: Make-table, Update, Delete, Append

• What is an index? What field is automatically indexed? Advantages and disadvantages?

• What is a macro? An action? An argument?

• What is a command button?

• What are events? Event properties? Examples of event properties?

• What is a submacro? How is it represented in code?

• Why are the InputBox function and GoToControl action useful for the FindRecord action?

• What is the ExportWithFormatting action typically used for?

• What does the MessageBox action do?

• What is SQL? What is it used for?

• Know the following SQL keywords: SELECT, FROM, WHERE, ORDER BY,
  INSERT INTO, VALUES

• What does VBA stand for? Why is it considered to be an event-driven language?

• What is the difference between a standard module and a class module? (public vs local)

• What is a sub procedure? Is one created every time you code an event procedure in a form?

• What is the Visual Basic Editor? What are the three main areas within it? What is each area for?

• Which property allows us to select more than one item from a list box?

• How do we remove the gray box that surrounds an image attachment in a form?

• What is the difference between a front-end and a back-end database? How does the front end “talk” to the back end?

• What does the performance analyzer do?

• What must be done before you can password protect your database?

• What is most common object that is loaded initially when creating an Access application? How is this configured?

• What are startup options? Why do we turn some of these off?

• Is it possible to disable the ribbon in an Access application? If so, how?

Answer 1

HOMEWORKLIB POLICY is that if there are sub-parts to the question , only first 4 parts are answered.

Make-table query : The Make-Table query is classed as one of the Action Queries, however this is different from the other types. Rather than modifying the data contained in an existing database table, a Make-Table query creates a new database table from the results of the query.

Update query: An Update Query is an action query (SQL statement) that changes a set of records according to criteria (search conditions) you specify.

Delete query : A DELETE query is an action query (SQL statement) that deletes a set of records according to criteria (search conditions) you specify

Append Query : An append query selects records from one or more data sources and copies the selected records to an existing table

Index : You can use an index to help Access find and sort records faster. An index stores the location of records based on the field or fields that you choose to index. After Access obtains the location from the index, it can then retrieve the data by moving directly to the correct location. In this way, using an index can be considerably faster than scanning through all of the records to find the data.index is a special data structure

- For primary key, access automatically creates an index for you

Advantages and Disadvantages of Index :

Advantages

• Speed up SELECT query
• Helps to make a row unique or without duplicates(primary,unique)
• If index is set to fill-text index, then we can search against large string values. for example to find a word from a sentence etc.

Disadvantages

• Indexes take additional disk space.
• indexes slow down INSERT,UPDATE and DELETE, but will speed up UPDATE if the WHERE condition has an indexed field. INSERT, UPDATE and DELETE becomes slower because on each operation the indexes must also be updated.

Macro: A Macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls