UpWork (oDesk) & Elance MS-Access Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.
Ques: To ensure a value no greater than 30 is entered into a field you would use:
Ans: A validation ruleQues: To ensure a value no greater than 30 is entered into a field you would use:
Ques: The action of typing a record into a database is:
Ans: Data entry
Ques: Why use a database instead of a spreadsheet?
Ans: Multiple data from various tables are needed.
Ques: What is a form?
Ans: An Access object where you can enter, edit or display data from a table or query
Ques: Which query can you delete records?
Ans: Delete Query
Ques: Can a primary key be used as a non-primary key in another table?
Ans: Yes
Ques: Microsoft Access does not offer parameterized queries.
Ans: False
Ques: Before you split a database, you should:
Ans: Back up the database file
Ques: True or False: You can import an Excel spreadsheet to an Access table.
Ans: True
Ques: What would Format("210.6", "#,##0.00") return?
Ans: 210.60
Ques: How to you ensure that a field is filled out properly?
Ans: Use a validation rule.
Ques: What is a data type?
Ans: It determines the kind of values users can store in a field
Ques: What happens when you freeze a column?
Ans: It prevents the column from moving positions
Ques: What is a purpose of a report?
Ans: To represent data in a more aesthetic, professional manner
Ques: What would Format("1267.5", "Currency") return?
Ans: $1,267.50
Ques: 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.
Ans: True
Ques: Which one of these is not a valid database relationship?
Ans: many-to-pair
Ques: What is a drop down list?
Ans: A way to have a user select from list of values in a table or form.
Ques: An Access file can import:
Ans: All of these
Ques: Of these, which can comparison operator symbols be applied to?
Ans: All of these
Ques: Of these, what could be the purpose for splitting a database?
Ans: All of these
Ques: How do you sort data in order?
Ans: All of these
Ques: What kind of relationships can you do in a database?
Ans: All of these
Ques: How do you save a file?
Ans: All of these
Ques: When you press the Tab key, which way does the insertion point go?
Ans: The adjacent field
Ques: What is a primary key?
Ans: It uniquely identifies each record in a table.
Ques: True or False: You cannot assign a Macro to a Command Button.
Ans: False
Ques: What is a caption?
Ans: The label for a field when used on a form.
Ques: On the ribbon with the Window tools, how can you view opened queries, tables, and reports?
Ans: All of these
Ques: Can relationships be between primary keys and non-primary keys?
Ans: Yes
Ques: Where in an Access window can you search for a specific record?
Ans: 2 of these are correct
Ques: Which of these would be a proper way to type a parameter?
Ans: [Where was this shipped to?]
Ques: Why should you enter sample data in tables after creating them?
Ans: To check for potential data maintenance problems
Ques: Name the object that is linked to a table that is used to enter data?
Ans: Form
Ques: What language is used to extend and automate MS Access?
Ans: Visual Basic for Applications
Ques: Which two objects can a report object be based on?
Ans: Table and Query
Ques:When you use the Max function, you are searching for...
Ans: The largest value in a field
Ques: The Input Mask Wizard is used to....
Ans: Format data being entered into a table
Ques: What type of query is used to show data but that does not alter data on the table?
Ans: Select
Ques: Where can you find the # of results in a Query?
Ans: Lower left of the screen
Ques: What are relationships for?
Ans: To ensure referential integrity
Ques: What are the 3 buttons for sorting data?
Ans: Ascending, descending, clear all sorts
Ques: How does changing the appearance of a datasheet affect the underlying table structure?
Ans: It does not change the structure
Ques: 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?
Ans: Use the Object Dependencies Task Pane
Ques: Choose the correct criteria to enter when prompting a user for the Customer Name in a
Ans: [Enter the Customer Name]
Ques: An Input Mask is:
Ans:
A data pattern which dictates how users can enter data into a field
Ques: Which of these is not a valid aggregate function for a query search?
Ans: Quo
Ques: When you run a query to find records in related tables, Access, by default, uses... an Inner Join
Ans: an Inner Join
Ques: Can you modify information while viewing a report?
Ans : No, you can only view information with a report
Ques: The Following statements are all true except:
Ans: You can only have one criterion per line in the design grid
Ques: What does DAO stand for?
Ans: Data Access Object
Ques: What does DAO stand for?
Ans: Data Access Objects
Ques: How do you move to the last record in a table?
Ans: All are correct
Ques: What is an example of a comparison operator symbol?
Ans: All of these
Ques: You wish to filter data on a report before printing without changing the design of the report. How do you do this?
Ans: 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
Ques: What does a group header or group footer do?
Ans: Displays the field label of grouped data on the top or bottom of a report
Ques: Datasheet views are different from continuous forms in very subtle ways. Which of the following statement is false?
Ans: Datasheet Views cannot have code modules associated with them.
Ques: To adjust the length of fields in a report while displaying data you would use:
Ans: Layout View
Ques: Which of these can you apply conditional formating to?
Ans: Form
Ques: To query two tables that are unrelated you:
Ans: Create a junction table which contains fields common to both tables
Ques: You are creating a Macro and you require the SetValue Action, but it does not exist. What do you do?
Ans: Click the Macro Tools Design Tab and choose "Show all Actions" from the Ribbon
Ques: What is typically displayed on a Relationship Report?
Ans: The current date and database name
Ques: What would StrConv("Tech on the Net", 3) return?
Ans: Tech On The Net
Ques: You need to create a lookup field where more than one option can be chosen. Where would you do this?
Ans: In the Lookup Wizard check "Allow Multiple Values"
Ques: In the design view of a make table query the destination table name is displayed:
Ans: In the propery sheet with selection type query properties.
Ques: When you open an Access Form, what is the second event that fires?
Ans: On Load
Ques: Field selectors are located..
Ans: at the top of a table
Ques: Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?
Ans: 255
Ques: The report header displays on:
Ans: The first page only
Ques: Which of the following is not included in the Access Built-In Functions for SQL Aggregate
Ans: Median(«expression»)
Ques: What is the "iif" function named?
Ans: Immediate If
Ques: What does ADO stand for?
Ans: ActiveX Data Objects
Ques: 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?
Ans: RunCode
Ques: A calculated control is one form that uses an expression to generate the data value for the master key of a table
Ans: False
Ques: "Yes/No" answers in Access are commonly stored as:
Ans: 0 or -1
Ques: When you move between records on an Access Form, which one of the following events fires?
Ans: On Current
Ques: Which of the following is NOT a type of query in Access?
Ans: CrossSelect
Ques: What is the maximum size of Microsoft Access 2010 database file?
Ans: 2 GB, minus the space needed for system objects
Ques: When do you use the Lookup Wizard?
Ans: You want to lookup the value of a field from another table or create a list of values to choose from
Ques: Which of the following helps to study the information in a table and then make changes to streamline the data?
Ans: Table Analyzer Wizard
Ques: In a loop that begins with "Do Until rs.EOF = True", what problem occurs if you omit "rs.movenext"?
Ans: The code continues executing but Access appears to hang.
Ques: 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?
Ans: Combo Box contro
Ques: What would Mid("Alphabet", 3, 10) return?
Ans: phabet
Ques: 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?
Ans: One-to-many
Ques: What would Replace("alphabet", "bet", "hydro") return?
Ans: alphahydro
Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD UpWorkElanceTests ARSBD-JOBS DesignerTab UpLance
We recommend you to subscribe us to get update from your email. EmoticonEmoticon