Intro to Tables Flashcards
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
A table is a ….
A table consists of …
At table is a db object you use to store data about a particular subject such as employees or products.
A table consists of records and fields.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
Each record contains…
A record is also commonly called a ____ or ____.
Each record contains data about one instance of the table subject, such as a particular employee.
A record is also commonly called a row or an instance.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
Each field contains…
A field is also commonly called a ____ or ____.
Each field contains data about one aspect of the table subject, such as the first name or email address.
A field is also commonly called a column or an attribute.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
A record consists of field values, also commonly called…
a fact. E.g. Contoso, Ltd. or someone@example.com.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
What types of external data sources can you link to and how can Access use the link?
You can link to other data sources such as other databases, text files and Excel workbooks.Access can use the link as if it were a table. Depending on the source and the way the link is created you can edit the data in the linked table and create relationships. You cannot change the design of the external data by using the link.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
In MS Access, what is Datasheet View?
A view that displays data from a table, form, query, view or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
What is the limit for Access 2010 table size?
2GB, minus the space needed for the system objects.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
What is the limit for Access 2010 OLE Object field size?
1GB
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
How do you create a new table in an existing Database in Access 2010?
Open the database.
Click on the Create tab.
Click on Table in the Tables group.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
What is the difference between linking and importing data?
When you import data, you create a copy of the data in a new table in the current database. Subsequent changes to the data source will have no affect on the imported data and changes to the imported data do not affect the source data. Once the data is imported you can use the data without connecting to the source.
When you link to data, you create a linked table in the current database which represents a live link to the existing information stored elsewhere. When you change data in the linked table, you are changing it in the source. When the data changes in the source, it changes in the linked table. You must connect to the data source whenever you use a linked table.
Note: You cannot edit data in an Excel worksheet by using a linked table. As a workaround, import the source data into an Access db and then link to the database from Excel. (there is more information about this avail).
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
How do you import or link to external data? What are 10 possible sources?
On the External Data tab, in the Import and Link group, click on one of the available data sources and follow the instructions in the dialog boxes that appear. Possible sources include: Excel, other Access dbs, ODBC database, Text file, XML file, SharePoint list, Data Services (web), HTML document, Outlook folder, dBase file.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
How do you use a Web service to create a table?
On the External Data tab, in the Import & Link group, click More and then Data Services. Click Install new connection (if not already connected). Select the connection file you want to use and click OK. In the Create Link to Web Service Data dialog box, expand the connection you want to use. Select the table you want to link to. Optionally, type a name for the linked table int he Specify link name box. Click OK.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
List three requirements for a good primary key.
1) Each record has a unique value for the field or combination of fields.
2) The field or combination of fields is never empty or null - there is always a value.
3) The values do not change.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
How do you set or change the primary key?
Select the table.
On the Home tab, in the Views group, click View and the Design View.
In the table design grid, select the field or field you want to use (to select more than one field hold down CTRL).
On the Design tab, in the Tools group, click Primary Key.
http://office.microsoft.com/en-us/access-help/introduction-to-tables-HA010341584.aspx?CTT=5&origin=HA101829991
How do you set a table’s properties?
- Select the table.
- On the Home tab, in the Views group, click View, then Design View.
- On the Design tab, in the Show/Hid group, click Property Sheet.
