|
||||||
|
Access Video Quiz B1.6 By Richard Rost 
16 hours ago
What Does Pencil Icon Mean When Editing a Record? What is Datasheet View primarily used for in an Access table? Welcome to another Microsoft Access Video Quiz. You will be asked five beginner-level questions covering tables, records and fields, AutoNumber primary keys, editing indicators in Datasheet View, and entering dates without a year. Answer each question, check your score, and see how well you know Microsoft Access. Recommended CoursesWant More?Keywords |
||||||||||||
| Age | Subject | From | |
| 24 hours | Post Your Quiz Score Here! | Richard Rost | |
More Information
Transcript
Welcome to another video quiz from Access Learning Zone. This one's for beginner-level users.
It's got five questions covering Access tables. You'll get three seconds for each question. So hit the pause button if you need more time because you're still busy eating second breakfast. Keep track of your score so you can see how we did at the end. Are you ready? Let's head out of the shire.
Question one: What is Datasheet View primarily used for in an Access table? A, designing fields and setting data types; B, adding and editing records; C, creating printed reports; or D, teaching the table to do spreadsheets.
That's going to be B, adding and editing records.
Question two: In Access terminology, what is a row of related data in a table called? A field, a column, a record, or a worksheet.
That's going to be a record. Remember, records are rows; fields are columns.
Question three: What normally happens to an AutoNumber primary key when you begin entering a new record? A, Access automatically assigns a new value; B, you must type the next available number; C, it copies the value from the previous record; or D, it waits until the database is printed.
That's going to be A, Access automatically assigns a new value.
Question four: In an Access datasheet, what does the pencil icon beside a record indicate? A, the record is locked permanently; B, the record contains a spelling error; C, the record has been deleted; or D, the record is being edited and has not yet been saved.
That is D, the record is being edited and has not yet been saved. It is dirty. Just like filthy hobbitses.
And question five: When you enter a date in an Access Date/Time field without including a year, what year does Access normally use? The year 1900, the current year, the next calendar year, or whichever year the database was created.
That is going to be the current year, the current system clock year.
All right, how'd you do? Did you get all five right? Are you a grand archivist of the 7 meal census? Or are you still looking for the any key between 11s and lunch?
Well, if you missed any, these topics and a lot more are covered in my Access Beginner Level 1 Class, Lesson 6, on entering data. It's absolutely free. You can find it on my website and on my YouTube channel. You'll find a link down below.
Thanks for playing. Be sure to post your score in the comments and let us know whether your database is ready for the fellowship or still filing hobbits under livestock. And until next time, live long and prosper.Intro
What is Datasheet View primarily used for in an Access table? Welcome to another Microsoft Access Video Quiz. You will be asked five beginner-level questions covering tables, records and fields, AutoNumber primary keys, editing indicators in Datasheet View, and entering dates without a year. Answer each question, check your score, and see how well you know Microsoft Access.
|
| |||
| Keywords: Access Video Quiz, Access tables, Datasheet View, adding and editing records, records vs fields, AutoNumber primary key, dirty record indicator, pencil icon in datasheet, Date/Time field default year, entering dates without year, Access table quiz PermaLink What Does the Pencil Icon Mean When Editing a Record in Microsoft Access? Video Quiz B1.6 |
