Question:* The action of typing a record into a database is:
Answer: • Data entry
Question:* Forms are bound to tables. What does this mean?
Answer: • Forms are based on tables
Question:* Why use a database instead of a spreadsheet?
Answer: • Multiple data from various tables are needed.
Question:* Conditional formatting...
Answer: • allows you to apply formatting to data when a certain criterion is met
Question:* What is a form?
Answer: • An Access object where you can enter, edit or display data from a table or query
Question:* Is it possible to create a Crosstab query in Access?
Answer: • Yes
Question:* Which query can you delete records?
Answer: • Delete Query
Question:* The Is Null criteria searches for fields that are ____.
Answer: • empty
Question:* Can a primary key be used as a non-primary key in another table?
Answer: • Yes
Question:* What is VBA?
Answer: • The programming language used in Access Modules
Question:* Each row of a table is called a:
Answer: • Record
Question:* What would LCase("124ABCd") return?
Answer: • 124abcd
Question:* Microsoft Access does not offer parameterized queries.
Answer: • False
Question:* What is the maximum number of indexes that you can create on an Access table?
Answer: • 32
Question:* How can you define how various tables of information are related?
Answer: • Use the Relationships property to define them.
Question:* A primary key can be described as:
Answer: • A field or a combination of fields that contain unique values
Question:* What is a report?
Answer: • The best method for printing the results of data in a database.
Question:* This holds data in a database:
Answer: • Table
Question:* The functions of Avg, Sum, Count, etc. can be found in which tool group?
Answer: • Totals
Question:* Before you split a database, you should:
Answer: • Back up the database file
Question:* True or False: Embedded macros can be attached to the event property of a form, report or control.
Answer: • True
Question:* True or False: You can import an Excel spreadsheet to an Access table.
Answer: • True
Question:* What would Format("210.6", "#,##0.00") return?
Answer: • 210.60
Question:* How to you ensure that a field is filled out properly?
Answer: • Use a validation rule.
Question:* What is a data type?
Answer: • It determines the kind of values users can store in a field
Question:* Which of the following is not an Access object?
Answer: • Spreadsheets
Question:* To change the type of data input for a specific field, you:
Answer: • All of these
Question:* If tables are for storing data, what are queries used for?
Answer: • Retrieving the data you want from the tables.
Question:* What happens when you freeze a column?
Answer: • It prevents the column from moving positions
Question:* The primary advantage of using indexing is that:
Answer: • It speeds up searches and sorting on the field.
Question:* Each customer has one address and each customer can have multiple orders. This is an example of a:
Answer: • One-to-many relationship.
Question:* True or False: Access allows you to import data from Excel.
Answer: • True
Question:* What is a purpose of a report?
Answer: • To represent data in a more aesthetic, professional manner
Question:* To add a table to a database, you:
Answer: • All of these
Question:* What would UCase("Tech on the Net") return?
Answer: • TECH ON THE NET
Question:* What would Format("1267.5", "Currency") return?
Answer: • $1,267.50
Question:* What is an input mask?
Answer: • A pattern for all data to be entered in the field.
Question:* True or False: You use an AutoNumber data type when you want unique numeric values to be created automatically by Access when you create a record.
Answer: • True
Question:* How do you limit the types of records you are viewing in a table?
Answer: • Use a filter
Question:* What does an ACCDE file do?
Answer: • All of these
Question:* You want to make sure that a unique number is always recorded on a new record. You would set the data type to:
Answer: • Autonumber
Question:* Which one of these is not a valid database relationship?
Answer: • many-to-pair
Question:* What would Left("Alphabet", 4) return?
Answer: • Alph
Question:* What is a drop down list?
Answer: • A way to have a user select from list of values in a table or form.
Question:* In an appointment database, you want to record the time of each appointment. What would you set the data type to?
Answer: • Date/Time
Question:* What can you do to distribute the front-end database?
Answer: • All of these
Question:* An Access file can be exported into:
Answer: • All of these
Question:* You want to make sure the data in a record is always recorded in dollars. You would set the data type to:
Answer: • Currency
Question:* An Access file can import:
Answer: • All of these
Question:* Of these, which can comparison operator symbols be applied to?
Answer: • All of these
Question:* Of these, what could be the purpose for splitting a database?
Answer: • All of these
Question:* How do you sort data in order?
Answer: • All of these
Question:* What kind of relationships can you do in a database?
Answer: • All of these
Question:* How do you save a file?
Answer: • All of these
Question:* You can import data into Access from:
Answer: • All of these
Question:* Which are comparison operators?
Answer: • All of these
Question:* What would LCase("Tech on the Net") return?
Answer: • tech on the net
Question:* What are ways to collect data?
Answer: • All of these
Question:* In an Access Query, if you would like your result to display blank values, what criteria would you use?
Answer: • is null
Question:* In a query looking for salespeople whose first name starts with "L" but last name starts with "O", what kind of condition will you set?
Answer: • And
Question:* What is the best way to view and print the results of a query?
Answer: • Report
Question:* When you press the Tab key, which way does the insertion point go?
Answer: • The adjacent field
Question:* What is a primary key?
Answer: • It uniquely identifies each record in a table.
Question:* Which data type allows for text and numbers to be added to a field?
Answer: • Text
Question:* True or False: You cannot assign a Macro to a Command Button.
Answer: • False
Question:* You can edit the field size for allowable characters in:
Answer: • Design View
Question:* To edit how a form looks, you go to:
Answer: • Design view
Question:* What is a caption?
Answer: • The label for a field when used on a form.
Question:* On the ribbon with the Window tools, how can you view opened queries, tables, and reports?
Answer: • All of these
Question:* What do you call a value that is automatically entered in a filed for new records?
Answer: • Default value.
Question:* How do you make sure that a field from a query is displayed in the results?
Answer: • The "Show" checkbox is checked
Question:* Can relationships be between primary keys and non-primary keys?
Answer: • Yes
Question:* How do you ensure that a field is filled out in a table?
Answer: • Set the "Required" setting to "Yes"
Question:* Where in an Access window can you search for a specific record?
Answer: • 2 of these are correct
Question:* What does field size do?
Answer: • Restricts the number of characters in a field to a preset amount.
Question:* Which of the following is NOT a valid data type in an Access table?
Answer: • AutoIncrement
Question:* Which database object acts as a storage container for the data?
Answer: • Table
Question:* A good feature for having a unique primary key is:
Answer: • Use the AutoNumber feature
Question:* Which of these is a proper example of how to write an equation for a query?
Answer: • [Amount]+[Field Name]
Question:* Which of these would be a proper way to type a parameter?
Answer: • [Where was this shipped to?]
Question:* If you delete a field from a table:
Answer: • Both the field and the data are erased
Question:* Why should you enter sample data in tables after creating them?
Answer: • To check for potential data maintenance problems
Question:* What is the shortcut key combination for stopping the execution of a query?
Answer: • CTRL+Break
Question:* Access _____ the saved query each time it is opened.
Answer: • runs
Question:* Which of the following is NOT a valid data type in an Access table?
Answer: • AutoIncrement
Question:* Which of the following takes you through the process of creating a table
Answer: • Wizard
Question:* What is the file extension of an Access 2010 database?
Answer: • .accdb
Question:* What character do you use to concatenate two character strings?
Answer: • & (Ampersand Operator)
Question:* To ensure a value no greater than 30 is entered into a field you would use:
Answer: • A validation rule
Question:* Which of these is considered a record?
Answer: • 1 row of data
Question:* The Where function does what?
Answer: • Limit records displayed to those that match a condition
Question:* You need a shortcut on a form to print a specific report. Which form design tool do you use?
Answer: • Command Button
Question:* Name the object that is linked to a table that is used to enter data?
Answer: • Form
Question:* True or False: Data in a subdatasheet can be edited.
Answer: • True
Question:* What language is used to extend and automate MS Access?
Answer: • Visual Basic for Applications
Question:* Your sales entry form does not tab through in the order you want between fields. You should:
Answer: • Manually set tab sequence on the form
Question:* Which two objects can a report object be based on?
Answer: • Table and Query
Question:* How do you create a new table by importing an Excel Spreadsheet?
Answer: • External Data tab->Excel button in Import group
Question:* In Microsoft Office Access 2010, which "Filter By Group" Options available in database objects pane:
Answer: • All of Them
Question:* True or false: In the 2007 and later versions of Access, databases are not encrypted when a database password is applied.
Answer: • False
Question:* When you use the Max function, you are searching for...
Answer: • The largest value in a field
Question:* What does setting "Allow Zero Length" to "Yes" in a text field allow?
Answer: • It allows zero-length strings in the field.
Question:* How do you move to the last record in a table?
Answer: • Both of these
Question:* What is each column in a table called?
Answer: • An attribute.
Question:* In query design, if you want to find all records where the CITY field begins with the letter D you would enter:
Answer: • Like "D*"
Question:* What is the difference between regular version and runtime version of Microsoft Access?
Answer: • The runtime version allows users to use the Access application but they cannot use its design surfaces.
Question:* The Input Mask Wizard is used to....
Answer: • Format data being entered into a table
Question:* What type of query is used to show data but that does not alter data on the table?
Answer: • Select
Question:* What would Len("Tech on the Net") return?
Answer: • 15
Question:* What keyboard shortcut key do you press to get help?
Answer: • F1
Question:* What would Len("Tech on the Net") return?
Answer: • 15
Question:* If you wanted to create a query that added records to an existing table (without overwriting existing records), what kind of query would you create?
Answer: • Append Query
Question:* In a report, what does the date control insert?
Answer: • The current date each time it's opened
Question:* Access will allow Joins between two linked tables on different servers.
Answer: • True
Question:* Where can you find the # of results in a Query?
Answer: • Lower left of the screen
Question:* Which Database Tool allows you to identify tables with repeating information and suggest a more normalized table design?
Answer: • Analyze Table
Question:* True or False: To hide repeating data in a column on a report you would set the Hide Duplicates Property to "No."
Answer: • False
Question:* If you wanted to create a query that removed records from an existing table, what kind of query would you create?
Answer: • Delete Query
Question:* What are relationships for?
Answer: • To ensure referential integrity
Question:* If you wanted to create a query that added records to an existing table (without overwriting existing records), what kind of query would you create?
Answer: • Append Query
Question:* You want to limit what people can enter on a Form. They easiest way is to:
Answer: • Use a drop down menu
Question:* What are the 3 buttons for sorting data?
Answer: • Ascending, descending, clear all sorts
Question:* You have imported data from Excel. You want Access to help you split your data into different tables. What do you do?
Answer: • Use the Analyze Table tool
Question:* If you wanted to create a query that removed records from an existing table, what kind of query would you create?
Answer: • Delete Query
Question:* What would Len("124ABCd") return?
Answer: • 7
Question:* How does changing the appearance of a datasheet affect the underlying table structure?
Answer: • It does not change the structure
Question:* Do you have to have relationships set up in Access?
Answer: • No, but it is a good practice.
Question:* Before deleting a query object in your database you need to check whether any report objects are based on it. How do you do this?
Answer: • Use the Object Dependencies Task Pane
Question:* What would Replace("alphabet", "bet", "hydro") return?
Answer: • alphahydro
Question:* What is the maximum number of indexes that you can create on an Access table?
Answer: • 32
Question:* Where can you check the number of records you have in a database?
Answer: • Bottom of the window
Question:* What are two ways to enter data into your database?
Answer: • Via a form and directly into a table.
Question:* Choose the correct criteria to enter when prompting a user for the Customer Name in a Query.
Answer: • [Enter the Customer Name]
Question:* What is the name of a query to which you can add records?
Answer: • append query
Question:* An Input Mask is:
Answer: • A data pattern which dictates how users can enter data into a field
Question:* What is most commonly used for data entry?
Answer: • Form
Question:* Which of these is not a valid aggregate function for a query search?
Answer: • Quo
Question:* When you run a query to find records in related tables, Access, by default, uses...
Answer: • an Inner Join
Question:* To find records within two dates you use
Answer: • The BETWEEN and AND operator
Question:* Can you modify information while viewing a report?
Answer: • No, you can only view information with a report
Question:* Which of the following is not a valid view for an Access Form?
Answer: • Edit View
Question:* A best practice in managing a relational database such as the Access Jet database engine is:
Answer: • Normalizing the data
Question:* When can you set referential integrity between two tables?
Answer: • All of these
Question:* The Following statements are all true except:
Answer: • You can only have one criterion per line in the design grid
Question:* To create a table relationship you would click on...
Answer: • Database Tools, Relationships
Question:* You can use SQL to write Queries.
Answer: • Yes.
Question:* How do you resize a column?
Answer: • Click and drag along the right border of a field
Question:* Which term is used to refer to a single piece of data stored in a field?
Answer: • Value
Question:* What happens when Best Fit is used?
Answer: • Text is formatted to fit the cell better
Question:* You require a Grand total to be printed on a Report. You create a calculated field and place the control in which section on the report?
Answer: • Report Footer
Question:* How would one bypass the the execution of AutoExec Macro when you open Microsoft Office Access database?
Answer: • Press and hold Shift Key
Question:* Which one listed below is not a valid version of MS Access?
Answer: • 2005
Question:* In which row of the query design grid do you specify what is used to filter the results?
Answer: • Criteria
Question:* Each sales person has many customers. Each customer can have many orders. In building a query for how much in sales a salesperson is generating, what kind of relationship will exist between customer and orders?
Answer: • One-to-many
Question:* How do you create a switchboard?
Answer: • Database Tools -> Switchboard Manager
Question:* What does it mean to enforce referential integrity.
Answer: • You can't update the data to violate the record's relationship.
Question:* What does an Action Query do?
Answer: • Modifies data in some way.
Question:* What would Mid("Alphabet", 3, 10) return?
Answer: • phabet
Question:* You require a form control that provides a text box to which a drop-down list is attached. Users can either type a value directly into the text box or select from the list of choices available. Which control will you choose?
Answer: • Combo Box control
Question:* Normalization is the process of:
Answer: • organizing data in a database to produce optimized table structures
Question:* When creating or editing a table in design view, the 'Required' field property default value is 'No'.
Answer: • True
Question:* In a loop that begins with "Do Until rs.EOF = True", what problem occurs if you omit "rs.movenext"?
Answer: • The code continues executing but Access appears to hang.
Question:* What does the Run button do?
Answer: • Executes and renders the results of the query in a new tab
Question:* Which of the following helps to study the information in a table and then make changes to streamline the data?
Answer: • Table Analyzer Wizard
Question:* What is one way to run a macro when opening an Access Database?
Answer: • Create a Macro named AutoExec
Question:* When do you use the Lookup Wizard?
Answer: • You want to lookup the value of a field from another table or create a list of values to choose from
Question:* What is the maximum size of Microsoft Access 2010 database file?
Answer: • 2 GB, minus the space needed for system objects
Question:* What keyboard shortcut will bypass autoexec macros when opening an Access database?
Answer: • Hold down Shift while opening the database
Question:* True or False: You can upgrade a 2003 or earlier Access file (.mdb) to a 2007 or later Access file (.accdb) while a database password is configured.
Answer: • False
Question:* How do you password protect your database?
Answer: • Open Database in exclusive mode->Database Tools-> Encrypt with Password
Question:* If the "Row Source" property on a combo box was set to "Beginner";"Intermediate";"Advanced", what value would you assign to the "Row Source Type" property on that combo box?
Answer: • Value List
Question:* You want to create a flexible query that prompts the user for additional criteria. What will you create?
Answer: • Parameter Query
Question:* How do you copy a record?
Answer: • Right-click the start of a row and click copy
Question:* Which of these aspects of a Linked Table cannot be changed?
Answer: • Table definition
Question:* What would be considered summary data?
Answer: • Count, Sum or Average
Question:* What would RTrim("Tech on the Net ") return?
Answer: • "Tech on the Net"
Question:* When compacting a database, what must you check?
Answer: • Ensure no other users are working on the Database at the time
Question:* Double Clicking the Active Tab on the Ribbon will:
Answer: • Hide or Unhide the Ribbon
Question:* When editing a relationship in the Relationships screen, which of these is not an option?
Answer: • Disable Referential Integrity
Question:* Access is available for a Mac.
Answer: • False
Question:* What format must the filename be in to be protected?
Answer: • .ACCDE
Question:* What does DAO stand for?
Answer: • Data Access Objects
Question:* Can an access database application be run in a Linux environment?
Answer: • No
Question:* In Design View, what is the first step to create a query?
Answer: • Create->Query Design-> Double-click on table name
Question:* You put the following code near the top of an Access form: Global rs10 As DAO.Recordset The code causes an error because?
Answer: • Global Variables cannot be declared in Form Objects
Question:* Which of the following is NOT a type of query in Access?
Answer: • CrossSelect
Question:* When you move between records on an Access Form, which one of the following events fires?
Answer: • On Current
Question:* To filter a table in Datasheet view, what do you use?
Answer: • Filter by Selection
Question:* Which of the following are views that a table can be changed to?
Answer: • Datasheet
Question:* "Yes/No" answers in Access are commonly stored as:
Answer: • 0 or -1
Question:* What is the defining feature of a back-end copy of a split database?
Answer: • _be added to the database name
Question:* A calculated control is one form that uses an expression to generate the data value for the master key of a table.
Answer: • False
Question:* Which of the following Access 2010 macro actions does not require you to select "Show All Actions" in order to use it in Macro Design?
Answer: • RunCode
Question:* In the design view of an update query the top row, labeled field is:
Answer: • The field name from the table being updated.
Question:* What does ADO stand for?
Answer: • ActiveX Data Objects
Question:* What does a Pass-Through Query do?
Answer: • Sends a SQL statement to a remote server for execution.
Question:* What is the "iif" function named?
Answer: • Immediate If
Question:* Which of the following is not included in the Access Built-In Functions for SQL Aggregate
Answer: • Median(«expression»)
Question:* The Yes of a Yes/No data type field equates to which?
Answer: • -1
Question:* The report header displays on:
Answer: • The first page only
Question:* Which of the following is considered an "Unsafe Action" in an Access 2010 macro and would require you to "Show All Actions" in order to use it in Macro Design?
Answer: • SaveObject
Question:* Concerning the code below, which of the following statement is False? Dim rst as ADODb.Recordset
Answer: • Recordset variables must always be named 'rst'.
Question:* Is it possible to use the record MACRO function in Access?
Answer: • No, this is not supported in Access
Question:* Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?
Answer: • 255
Question:* Field selectors are located...
Answer: • at the top of a table
Question:* When you open an Access Form, what is the second event that fires?
Answer: • On Load
Question:* What would Format("0.981", "Percent") return?
Answer: • 98.10%
Question:* Which of these statements are false?
Answer: • It is not possible to sort query results.
Question:* In the design view of a make table query the destination table name is displayed:
Answer: • In the propery sheet with selection type query properties.
Question:* What would Format("210.6", "Standard") return?
Answer: • 210.60
Question:* Concerning encryption, which of the following statement is True?
Answer: • MD5 Encryption and hashing can be done in Access VBA using .NET functions.
Question:* What are the three wildcard characters Access allows you to use when searching?
Answer: • *, #, ?
Question:* What must be the same for a relationship to work?
Answer: • Must have same data type and field size
Question:* You need to create a lookup field where more than one option can be chosen. Where would you do this?
Answer: • In the Lookup Wizard check "Allow Multiple Values"
Question:* What would StrConv("Tech on the Net", 3) return?
Answer: • Tech On The Net
Question:* True or False: Union Queries must be created by manually writing the SQL.
Answer: • True
Question:* What would Instr(20,"Tech on the Net","t") return?
Answer: • 0
Question:* On printing a report you find that the Comments field is printing </div> for every record in the Comments field. How do you rectify this?
Answer: • Change the text format property for the field to Rich Text
Question:* How do you widen the columns in the design grid?
Answer: • Double-Click on the right border of the top of the column
Question:* What is typically displayed on a Relationship Report?
Answer: • The current date and database name
Question:* Which is not a benefit of upsizing to an SQL server?
Answer: • Time delayed recoverability
Question:* You are creating a Macro and you require the SetValue Action, but it does not exist. What do you do?
Answer: • Click the Macro Tools Design Tab and choose "Show all Actions" from the Ribbon
Question:* You can add your company logo to a form in:
Answer: • Design & Layout Views
Question:* How do you print a database?
Answer: • Use the print option after clicking the Microsoft button
Question:* To query two tables that are unrelated you:
Answer: • Create a junction table which contains fields common to both tables
Question:* What key displays the Database Window?
Answer: • F11
Question:* Which of these can you apply conditional formating to?
Answer: • Form
Question:* What does DAO stand for?
Answer: • Data Access Object
Question:* To adjust the length of fields in a report while displaying data you would use:
Answer: • Layout View
Question:* Datasheet views are different from continuous forms in very subtle ways. Which of the following statement is false?
Answer: • Datasheet Views cannot have code modules associated with them.
Question:* Which of these statements is true?
Answer: • You do not need to put a $ in front of numbers in criteria
Question:* What does a group header or group footer do?
Answer: • Displays the field label of grouped data on the top or bottom of a report
Question:* You wish to filter data on a report before printing without changing the design of the report. How do you do this?
Answer: • In Layout view, select the Home Tab and click Filter, uncheck the Select All check box, and check the values you want to filter on
Question:* What would Instr(1,"Tech on the Net","n") return?
Answer: • 7
Question:* What type of database is Access?
Answer: • File server database
Question:* What is an example of a comparison operator symbol?
Answer: • All of these
Question:* What would Len("Tech on the Net") return?
Answer: • 15
Question:* How do you move to the last record in a table?
Answer: • All are correct
Question:* What does DAO stand for?
Answer: • Data Access Objects
Question:* What does DAO stand for?
Answer: • Data Access Object
No comments:
Post a Comment