1]Before you close a database, you must save any changes you made to the data.
Get answer to your question and much more
2]A new blank desktop database includes one table named Table1.
Get answer to your question and much more
3]To navigate to a record in a table, switch to Table Design view.
Get answer to your question and much more
4]Table Design view shows how each table relates to other tables in the database.
Get answer to your question and much more
5]To enter data in a table, open it in Table Datasheet view.
Get answer to your question and much more
6]When you add a field to a table in Table Design view, entering the field name is optional.
Get answer to your question and much more
7]You can create a table in Table Datasheet view or Table Design view.
Get answer to your question and much more
8]Before you can rename a field, you must change its data type.
Get answer to your question and much more
9]A field with the Currency data type contains values such as quantities, measurements, andscores.
Get answer to your question and much more
10] To display data, it needs to be in Table Design.
Get answer to your question and much more
11] When you enter a record in a table, you are working in navigation mode.
Get answer to your question and much more
12] Press ESC to remove editing changes you made to the previous record.
Get answer to your question and much more
13] A form selects a subset of fields & records from one or more tables, & then presents selecteddata as a single datasheet.
Get answer to your question and much more
14] Of all the database objects, a table provides the most formatting, layout, and summary options.
Get answer to your question and much more
Try it!
To create a desktop database quickly, use one of the many templates provided with Access. Or, if you don’t find a template that meets your needs, create a database from scratch.
Create a database from a template
The easiest and fastest way to create your database is to use an Access template, which creates a ready-to-use database, complete with the tables, forms, reports, queries, macros, and relationships that you need to start working right away. If it doesn’t meet your needs exactly, customize it.
When you open Access, you see a set of templates. More are available online.
Tip: If a database is open, select File > Close to close it.
Open Access [or select File > New], and select a desktop database template.
Tip: If you don’t see the template you want, look for a template on Office.com. Beneath the Search for online templates box, select Databases. Then, in the Search box, enter one or more keywords.
Enter a name for your new database, and select its location. Then, select Create.
Messages you might see
If you see any of the following messages, here’s what to do:
Login dialog box with an empty list of users |
|
Getting Started page | To learn more about the database, use the links on the page, or, to explore the database, select other buttons and tabs. |
Create a database from scratch
If you don’t find the template you need, create your own.
Open Access [or select File > New], and select Blank desktop database.
Enter a file name, and then click Create. To save to file in a specific location, select Browse. Access creates the database with an empty table named Table1 and then opens Table1 in Datasheet view. It automatically adds a column, called ID, for the primary key.
Table1 isn’t saved automatically, so be sure to save it, even if you haven’t changed it.
You’re almost ready to enter data. But first, you need to define fields for the table, use Access to add other tables with fields, and then create relationships between them. For instructions, start with the Build tables and set data types module in this course.
Want more?
Database design basics
Excel training
Outlook training